Query with the InfluxDB API
This page documents an earlier version of InfluxDB. InfluxDB v2.7 is the latest stable version. View this page in the v2.7 documentation.
The InfluxDB v2 API provides a programmatic interface for all interactions with InfluxDB. To query InfluxDB 2.1, do one of the following:
- Send a Flux query request to the
/api/v2/queryendpoint. - Send an InfluxQL query request to the /query 1.x compatibility API.
In your request, set the following:
- Your organization via the
orgororgIDURL parameters. Authorizationheader toToken+ your API token.Acceptheader toapplication/csv.Content-typeheader toapplication/vnd.flux(Flux only) orapplication/json(Flux or InfluxQL).- Query in Flux or InfluxQL with the request’s raw data.
Use gzip to compress the query response
To compress the query response, set the Accept-Encoding header to gzip.
This saves network bandwidth, but increases server-side load.
Flux - Example query request
Below is an example curl request that sends a Flux query to InfluxDB 2.1:
curl --request POST \
http://localhost:8086/api/v2/query?orgID=INFLUX_ORG_ID \
--header 'Authorization: Token INFLUX_TOKEN' \
--header 'Accept: application/csv' \
--header 'Content-type: application/vnd.flux' \
--data 'from(bucket:"example-bucket")
|> range(start: -12h)
|> filter(fn: (r) => r._measurement == "example-measurement")
|> aggregateWindow(every: 1h, fn: mean)'
curl --request POST \
http://localhost:8086/api/v2/query?orgID=INFLUX_ORG_ID \
--header 'Authorization: Token INFLUX_TOKEN' \
--header 'Accept: application/csv' \
--header 'Content-type: application/vnd.flux' \
--header 'Accept-Encoding: gzip' \
--data 'from(bucket:"example-bucket")
|> range(start: -12h)
|> filter(fn: (r) => r._measurement == "example-measurement")
|> aggregateWindow(every: 1h, fn: mean)'
InfluxQL - Example query request
Below is an example curl request that sends an InfluxQL query to InfluxDB 2.1:
curl --request -G http://localhost:8086/query?orgID=INFLUX_ORG_ID&database=MyDB&retention_policy=MyRP \
--header 'Authorization: Token INFLUX_TOKEN' \
--header 'Accept: application/csv' \
--header 'Content-type: application/json' \
--data-urlencode "q=SELECT used_percent FROM example-db.example-rp.example-measurement WHERE host=host1"
curl --request -G http://localhost:8086/query?orgID=INFLUX_ORG_ID&database=MyDB&retention_policy=MyRP \
--header 'Authorization: Token INFLUX_TOKEN' \
--header 'Accept: application/csv' \
--header 'Content-type: application/json' \
--header 'Accept-Encoding: gzip' \
--data-urlencode "q=SELECT used_percent FROM example-db.example-rp.example-measurement WHERE host=host1"
InfluxDB returns the query results in annotated CSV.
Was this page helpful?
Thank you for your feedback!
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, use the following resources:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.