Use the InfluxDB v1 HTTP query API and InfluxQL

Use the InfluxDB v1 HTTP API /query endpoint and InfluxQL to query data stored in {{< product-name >}} and return results in JSON or CSV format. The /query endpoint provides compatibility for InfluxDB 1.x workloads that you bring to InfluxDB 3.

Before you can use the v1 query API, databases and retention policies must be mapped to buckets.

[!Note]

Flight queries don't use DBRP mappings

When using Flight RPC or Flight SQL to query InfluxDB, specify the bucket name. Flight queries don't use DBRP mappings. See how to get started querying with Flight and SQL or InfluxQL.

• Query the v1 /query endpoint
  • Parameters
  • Authorization
  • Return results as JSON or CSV
• Tools for querying the v1 API
  • Interactive clients
• Troubleshoot failures
  • Database not found
  • Quota and limit errors

Query the v1 /query endpoint

To query using HTTP and InfluxQL, send a GET or POST request to the v1 /query endpoint.

{{< api-endpoint endpoint="https://{{< influxdb/host >}}/query" method="get" api-ref="/influxdb3/cloud-serverless/api/#operation/GetLegacyQuery" >}}

Parameters

For {{% product-name %}} v1 API /query requests, set parameters as listed in the following table:

[!Note] When bringing v1 API workloads to {{% product-name %}}, you'll need to adjust request parameters in your client configuration or code.

Timestamp precision

Use one of the following values for timestamp precision (epoch):

• ns: nanoseconds
• us: microseconds
• ms: milliseconds
• s: seconds
• m: minutes
• h: hours

Authorization

To authorize a query request, include a token that has read permission for the bucket. Use Token authentication or v1-compatible username and password authentication to include a token in the request.

Return results as JSON or CSV

By default, the /query endpoint returns results in JSON format.

To return results in CSV format, include the Accept header with the application/csv or text/csv MIME type--for example:

{{% code-placeholders "DATABASE_(NAME|TOKEN)" %}}

curl --get https://{{< influxdb/host >}}/query \
  --header "Authorization: Token DATABASE_TOKEN" \
  --header "Accept: application/csv" \
  --data-urlencode "db=DATABASE_NAME" \
  --data-urlencode "q=SELECT * FROM home"

{{% /code-placeholders %}}

Tools for querying the v1 API

Interactive clients

To test InfluxDB v1 API queries interactively from the command line, use common HTTP clients such as cURL and Postman.

{{< code-tabs-wrapper >}} {{% code-tabs %}} Token Auth Basic Auth Query String Auth {{% /code-tabs %}} {{% code-tab-content %}}

{{% code-placeholders "DATABASE_NAME|API_TOKEN" %}}

curl https://{{< influxdb/host >}}/query \
  --header "Authorization: Token API_TOKEN" \
  --data-urlencode "db=DATABASE_NAME" \
  --data-urlencode "q=SELECT * FROM home"

{{% /code-placeholders %}}

Replace the following:

• {{% code-placeholder-key %}}DATABASE_NAME{{% /code-placeholder-key %}}: the database name mapped to the bucket
• {{% code-placeholder-key %}}API_TOKEN{{% /code-placeholder-key %}}: an API token with read access to the specified database.

{{% /code-tab-content %}} {{% code-tab-content %}} {{% code-placeholders "DATABASE_(NAME|TOKEN)" %}}

curl --get https://{{< influxdb/host >}}/query \
  -user "":"API_TOKEN" \
  --data-urlencode "db=DATABASE_NAME" \
  --data-urlencode "q=SELECT * FROM home"

{{% /code-placeholders %}} {{% /code-tab-content %}}

{{% code-tab-content %}} {{% code-placeholders "DATABASE_(NAME|TOKEN)" %}}

curl --get https://{{< influxdb/host >}}/query \
  --data-urlencode "u=ignored" \
  --data-urlencode "p=DATABASE_TOKEN" \
  --data-urlencode "db=DATABASE_NAME" \
  --data-urlencode "q=SELECT * FROM home"

{{% /code-placeholders %}} {{% /code-tab-content %}}

{{< /code-tabs-wrapper >}}

Troubleshoot failures

Troubleshoot problems and errors encountered when using the HTTP API to query {{% product-name %}}.

Database not found

If a DBRP doesn't exist for the db=DATABASE_NAME and rp=RETENTION_POLICY_NAME combination in the query request, the response body contains an error message, for example "database not found:...".

Quota and limit errors

HTTP API /query requests are subject to usage quotas and limits.