Query with the InfluxDB API
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?org=my-org \
--header 'Authorization: Token YOURAUTHTOKEN' \
--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?org=my-org \
--header 'Authorization: Token YOURAUTHTOKEN' \
--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?org=my-org?database=MyDB&retention_policy=MyRP \
--header 'Authorization: Token YOURAUTHTOKEN' \
--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?org=my-org?database=MyDB&retention_policy=MyRP \
--header 'Authorization: Token YOURAUTHTOKEN' \
--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.
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.