Hi, I'm using node-Red (V2.0.3) to write to an Influx server (1.8.10) with two databases using this contrib. Writing the data is going Ok but I'm being stumped by writing a node-Red function to query the timestamp of the last measurements (PT1H) in a database (energy). I've managed to get the outp…

Using the Influx In node you don't need anything in the message you pass to the node except msg.query. Tell it which database to use in the Server config (click the pen to the right of the Server field. Also setup the access credentials in there. Set the Version to 1.x as I assume you are using i…

@Colin thanks for the response. The access credentials are already in the Server config as you say, so although they were necessary for the cURL, they are not needed in the message header. However, the Influxdb In Node doesn't have anywhere to specify the database ("energy" in my case), screenshot…

[image] Bodad: the Influxdb In Node doesn't have anywhere to specify the database It is in the Server config. Also I note you still have 1.8-flux selected. As I said before, you are not using the Flux query language so you must select 1.x. The measurement is in the query.

@Colin you are right. I've changed the server to 1.x and included the database name there and the query now runs. It's confusing that v1.8.10 database needs 1.x rather than 1.8 server specifying in the node. I used the 1.8 specification to write all my data points, which seem to have gone in fine…

Node-red-contrib-influxdb specifying parameters in a function node

General

Colin 1 January 2022 15:30 6

1.x means any 1.x, not using the Flux query language, so that includes 1.8.
If you want to use the Flux query language that is only supported by 1.8 and 2.0 so for those you can use 1.8-flux or 2.0-flux.

In fact the error you were getting was probably because it was trying to interpret your query as a Flux query instead of InfluxQL.

Topic		Replies	Views
Node-red-contrib-influxdb function to pass a specific time query General database	13	3164	1 December 2021
Inluxdb in node General	3	131	17 March 2024
Specify a bucket in a Node-RED InfluxDB query node General	11	465	4 April 2025
Read-Commands InfluxDB General	4	380	1 September 2022
Node NodeRed - influxDB2.5 General database	2	325	2 January 2023

Node-red-contrib-influxdb specifying parameters in a function node

Related topics