How to Connect and Use InfluxDB Data in Bold Reports
Published:
Updated:
How can we connect Bold Reports to InfluxDB, and what are the available methods for establishing this connection?
Bold Reports supports connecting to InfluxDB through the Web API (REST API) data connector. This approach can be used with InfluxDB v1.x, v2.x, and v3.x by configuring the appropriate API endpoint, authentication method, and query format for the respective version.
| InfluxDB Version | Web API |
|---|---|
| InfluxDB v1.x | Supported |
| InfluxDB v2.x | Supported |
| InfluxDB v3.x | Supported |
Connecting to InfluxDB Using Web API
Below are the reference request formats and snippets for InfluxDB v1.x, v2.x, and v3.x using the Bold Reports Web API connector.
InfluxDB v1.x — Web API Connection Examples
Sample – GET Request
| Method | GET |
|---|---|
| URL | http://demo.influx.local:8086/query?db=mydb&q=SELECT mean(value) FROM temperature WHERE time >%3D now() - 1h |
Sample: POST Request
| Method | POST |
|---|---|
| URL | http://demo.influx.local:8086/query |
| Body (x-www-form-urlencoded) | db=mydb&q=SELECT max(usage) FROM cpu_load WHERE host=‘edge-01’ AND time >= now() - 30m |
InfluxDB v2.x — Web API Connection Example
Sample – POST Request (Recommended)
| Method | POST |
|---|---|
| URL | http://demo.influx.local:8086/api/v2/query |
| Headers | Authorization: Token INFLUX_API_TOKEN_ABC123 Accept: application/json Content-Type: application/vnd.flux |
| Body | { “query”: “from(bucket:"sensors") > range(start: -1h) > filter(fn: ® => r._measurement == "temperature") > aggregateWindow(every: 1m, fn: mean)” } |
InfluxDB v3.x — Web API Connection Example
Sample – POST Request
| Method | POST |
|---|---|
| URL | http://demo.influx.local:8181/api/v3/query_sql |
| Headers | Authorization: Bearer |
| Body | { “query”: “SELECT time, temperature FROM sensors WHERE time > now() - interval ‘1 hour’” } |
Choosing the Correct Connector in Bold Reports
For InfluxDB v1.x → Use Web API connector
For InfluxDB v2.x → Use Web API connector
For InfluxDB v3.x → Use Web API connector
This is the recommended and supported approach for connecting InfluxDB data to Bold Reports.
