InfluxDB

ToolJet can connect to InfluxDB databases to read and write data. Use the Token authentication scheme to authenticate to the InfluxDB API. For more info visit InfluxDB docs.

Connection

ToolJet connects to InfluxDB using :

• API Token
• Host
• Port
• Protocol (HTTP/HTTPS)

:::info For generating API Token visit InfluxDB docs. :::

Supported Queries

• Write data
• Query data
• Generate an Abstract Syntax Tree (AST) from a query
• Retrieve query suggestions
• Retrieve query suggestions for a branching suggestion
• Analyze a Flux query
• List buckets
• Create a bucket
• Retrieve a bucket
• Update a bucket
• Delete a bucket

Write Data

This operation writes data to a bucket.

Required Parameters:

• Bucket
• Organization name or ID
• Data

Optional Parameters:

• Precision

Query Data

Retrieves data from InfluxDB buckets.

Required Parameters:

• Organization name or ID
• Flux query

Example

from(bucket: "sensor_data") 
|> range(start: -1h) 
|> filter(fn: (r) => r["_measurement"] == "temperature")

Generate an Abstract Syntax Tree (AST) from a Query

This operation analyzes flux query and generates a query specification.

Required Parameters:

• Query

Example

from(bucket: "website_metrics")
  |> range(start: -7d)
  |> filter(fn: (r) => r["_measurement"] == "page_views")
  |> group(columns: ["url"])
  |> sum(column: "_value")
  |> sort(columns: ["_value"], desc: true)

Retrieve Query Suggestions

This query retrieve query suggestions.

Retrieve Query Suggestions for a Branching Suggestion

This operation retrieve query suggestions for a branching suggestion.

Required Parameters:

• Name

Analyze a Flux Query

This Analyzes a Flux query.

Required Parameters:

• Query

Example

from(bucket: "sensor_data")
  |> range(start: -1d)
  |> filter(fn: (r) => r["_measurement"] == "humidity")
  |> mean(column: "_value")

List Buckets

This operation lists all the buckets in a database.

Create a Bucket

This operation creates a bucket in database.

Required Parameters:

• Query

Example

POST http://localhost:8086/api/v2/buckets
Content-Type: application/json
Authorization: Token your_auth_token

{
  "name": "new_bucket",
  "orgID": "your_org_id",
  "retentionRules": [
    {
      "everySeconds": 3600
    }
  ]
}

Retrieve a Bucket

This operation retrieve a bucket in a database.

Required Parameters:

• Bucket ID

Update a Bucket

This operaition updates the bucket in database.

Required Parameters:

• Bucket ID
• Query

Example

{
  "name": "updated_bucket_name",
  "retentionRules": [
    {
      "everySeconds": 7200
    }
  ]
}

Delete a Bucket

This operation delete the bucket in database.

Required Parameters:

• Bucket ID