Skip to main content

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.

influx auth

Supported Queries​

influx operations

Write Data​

This operation writes data to a bucket.

Required Parameters:​

  • Bucket
  • Organization name or ID
  • Data

Optional Parameters:​

  • Precision
write query operations

Example​

temperature, location = office value = 23.5

Query Data​

Retrieves data from InfluxDB buckets.

Required Parameters:​

  • Organization name or ID
  • Flux query
query data operations

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
generate query operations

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 operations

Retrieve Query Suggestions for a Branching Suggestion​

This operation retrieve query suggestions for a branching suggestion.

Required Parameters:​

  • Name
retrieve operations

Analyze a Flux Query​

This Analyzes a Flux query.

Required Parameters:​

  • Query
analyze query operations

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.

list operations

Create a Bucket​

This operation creates a bucket in database.

Required Parameters:​

  • Query
create operations

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
retrieve operations

Update a Bucket​

This operaition updates the bucket in database.

Required Parameters:​

  • Bucket ID
  • Query
update operations

Example​

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

Delete a Bucket​

This operation delete the bucket in database.

Required Parameters:​

  • Bucket ID
delete operations