Documentation

/query 1.x compatibility API

InfluxDB Cloud only

The /query 1.x compatibility endpoint queries InfluxDB 2.0 using InfluxQL. Use the GET request method to query data from the /query endpoint.

GET https://cloud2.influxdata.com/query

The /query compatibility endpoint use the database and retention policy specified in the query request to map the request to an InfluxDB 2.0 bucket. For more information, see Database and retention policy mapping.

If you have an existing bucket that does’t follow the database/retention-policy naming convention, you must manually create a database and retention policy mapping to query that bucket with the /query compatibility API.

Authentication

Use basic authentication or token authentication. For more information, see Authentication.

Query string parameters

URL-encode all query string parameters.

db

Required – The database to query data from. This is mapped to an InfluxDB 2.0 bucket. See Database and retention policy mapping.

rp

The retention policy to query data from. This is mapped to an InfluxDB 2.0 bucket. See Database and retention policy mapping.

q

Required – The InfluxQL query to execute. To execute multiple queries, delimit queries with a semicolon (;).

epoch

Return results with Unix timestamps (also known as epoch timestamps) in the specified precision instead of RFC3339 timestamps with nanosecond precision. The following precisions are available:

  • ns - nanoseconds
  • u or µ - microseconds
  • ms - milliseconds
  • s - seconds
  • m - minutes
  • h - hours

Query examples

Query using basic authentication
curl -G https://cloud2.influxdata.com/query \
  -u username:YourAuthToken \
  --data-urlencode "db=mydb" \
  --data-urlencode "q=SELECT used_percent FROM mem WHERE host=host1"
Query a non-default retention policy
curl -G https://cloud2.influxdata.com/query \
  -H "Authorization: Basic username:YourAuthToken" \
  --data-urlencode "db=mydb" \
  --data-urlencode "rp=customrp" \
  --data-urlencode "q=SELECT used_percent FROM mem WHERE host=host1"
Execute multiple queries
curl -G https://cloud2.influxdata.com/query \
  -H "Authorization: Token YourAuthToken" \
  --data-urlencode "db=mydb" \
  --data-urlencode "q=SELECT * FROM mem WHERE host=host1;SELECT mean(used_percent) FROM mem WHERE host=host1 GROUP BY time(10m)"
Return query results with millisecond Unix timestamps
curl -G https://cloud2.influxdata.com/query \
  -H "Authorization: Token YourAuthToken" \
  --data-urlencode "db=mydb" \
  --data-urlencode "rp=myrp" \
  --data-urlencode "q=SELECT used_percent FROM mem WHERE host=host1"
  --data-urlencode "epoch=ms"
Use curl to execute InfluxQL queries from a file
curl -G https://cloud2.influxdata.com/query \
  -H "Authorization: Token YourAuthToken" \
  --data-urlencode "db=mydb" \
  -F "q=@path/to/influxql.txt"
  -F "async=true"

New! Cloud or OSS?