InfluxDB 1.x compatibility API
The InfluxDB v2 API includes InfluxDB 1.x compatibility /write and /query
endpoints that work with InfluxDB 1.x client libraries and third-party integrations
like Grafana and others.
View full v1 compatibility API documentation
Authentication
InfluxDB Cloud requires all query and write requests to be authenticated using InfluxDB authentication tokens.
Use InfluxDB authentication tokens with the following authentication schemes:
Authenticate with the Token scheme
Token authentication requires the following credential:
- token: InfluxDB authentication token
Use the Authorization header with the Token scheme to provide your
token to InfluxDB.
Syntax
Authorization: Token <token>
Example
#######################################
# Use a token in the Authorization header
# to query the InfluxDB 1.x compatibility API
#######################################
curl --get "http://localhost:8086" \
--header "Authorization: Token YourAuthToken" \
--header 'Content-type: application/json' \
--data-urlencode "db=mydb" \
--data-urlencode "q=SELECT * FROM cpu_usage"
/**
* Use a token in the Authorization header
* to query the InfluxDB 1.x compatibility API
*/
const https = require('https');
const querystring = require('querystring');
function queryWithToken() {
const queryparams = {
db: 'mydb',
q: 'SELECT * FROM cpu_usage',
};
const options = {
host: 'localhost:8086',
path: "/query?" + querystring.stringify(queryparams),
headers: {
'Authorization': 'Token YourAuthToken',
'Content-type': 'application/json'
},
};
const request = https.get(options, (response) => {
let rawData = '';
response.on('data', () => {
response.on('data', (chunk) => { rawData += chunk; });
})
response.on('end', () => {
console.log(rawData);
})
});
request.end();
}
Authenticate with a username and password scheme
Use the following schemes with clients that support the InfluxDB 1.x convention of username and password (that don’t support the Authorization: Token scheme):
Manage credentials
Username and password schemes require the following credentials:
- username: InfluxDB Cloud username
- password: InfluxDB Cloud authentication token
Basic authentication
Use the Authorization header with the Basic scheme to provide username and password credentials to InfluxDB.
Most HTTP clients provide a Basic authentication option that
accepts the <username>:<password> syntax
and encodes the credentials before sending the request.
Syntax
Authorization: Basic <username>:<password>
Example
#######################################
# Use an InfluxDB 1.x compatible username
# and password with Basic Authentication
# to query the InfluxDB 1.x compatibility API
#######################################
# Use default retention policy
#######################################
# Use the --user option with `--user <username>:<password>` syntax
# or the `--user <username>` interactive syntax to ensure your credentials are
# encoded in the header.
#######################################
curl --get "http://localhost:8086/query" \
--user "OneDotXUsername":"yourPasswordOrToken" \
--data-urlencode "db=mydb" \
--data-urlencode "q=SELECT * FROM cpu_usage"
/**
* Use an InfluxDB Cloud username and token
* with Basic Authentication
* to query the InfluxDB 1.x compatibility API
*/
const https = require('https');
const querystring = require('querystring');
function queryWithUsername() {
const queryparams = {
db: 'mydb',
q: 'SELECT * FROM cpu_usage',
};
const options = {
host: 'localhost:8086',
path: '/query?' + querystring.stringify(queryparams),
auth: 'exampleuser@influxdata.com:YourAuthToken',
headers: {
'Content-type': 'application/json'
},
};
const request = https.get(options, (response) => {
let rawData = '';
response.on('data', () => {
response.on('data', (chunk) => { rawData += chunk; });
})
response.on('end', () => {
console.log(rawData);
})
});
request.end();
}
Query string authentication
Use InfluxDB 1.x API parameters to provide username and password credentials through the query string.
Consider when using query string parameters
- URL-encode query parameters that may contain whitespace or other special characters.
- Be aware of the risks when exposing sensitive data through URLs.
Syntax
/query/?u=<username>&p=<password>
/write/?u=<username>&p=<password>
Example
#######################################
# Use an InfluxDB 1.x compatible username and password
# to query the InfluxDB 1.x compatibility API
#######################################
# Use authentication query parameters:
# ?u=<username>&p=<password>
# Use default retention policy.
#######################################
curl --get "http://localhost:8086/query" \
--data-urlencode "u=OneDotXUsername" \
--data-urlencode "p=yourPasswordOrToken" \
--data-urlencode "db=mydb" \
--data-urlencode "q=SELECT * FROM cpu_usage"
/**
* Use an InfluxDB 1.x compatible username and password
* to query the InfluxDB 1.x compatibility API
*
* Use authentication query parameters:
* ?u=<username>&p=<password>
*
* Use default retention policy.
*/
const https = require('https');
const querystring = require('querystring');
function queryWithToken() {
const queryparams = {
db: 'mydb',
q: 'SELECT * FROM cpu_usage',
u: 'OneDotXUsername',
p: 'yourPasswordOrToken'
};
const options = {
host: 'localhost:8086',
path: "/query?" + querystring.stringify(queryparams)
};
const request = https.get(options, (response) => {
let rawData = '';
response.on('data', () => {
response.on('data', (chunk) => { rawData += chunk; });
})
response.on('end', () => {
console.log(rawData);
})
});
request.end();
}
InfluxQL support
The compatibility API supports InfluxQL, with the following caveats:
- The
INTOclause (e.g.SELECT ... INTO ...) is not supported. - With the exception of
DELETEandDROP MEASUREMENTqueries, which are still allowed, InfluxQL database management commands are not supported.
Compatibility endpoints
/query
The /query 1.x compatibility endpoint queries InfluxDB Cloud using InfluxQL.
GET https://cloud2.influxdata.com/query
/write
The /write 1.x compatibilty endpoint writes data to InfluxDB Cloud using patterns from the InfluxDB 1.x /write API endpoint.
POST https://cloud2.influxdata.com/write
Database and retention policy mapping
The database and retention policy (DBRP) mapping service maps InfluxDB 1.x database and retention policy combinations to InfluxDB Cloud buckets.
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.