Can someone help me to send JSON data to Influxdb from node-red. You can find my output data in the attached image and the influx node I have. I am using influx 2.0 version. My data will change every 10secs so, I can't hard code anything here. Thank you :slight_smile: [Influx]

Assuming you are sending to the Influx Out node then look in the help text and you will see that is not a valid structure for the data. You need the measurement in msg.measurement, and in msg.payload you need [ { field1: value, field2: value }, { tag1: value, tag2: value } …

Start by removing the json node. Influx requires a measument, fields, values and timestamp - and unless you are not using them for aggregations, no strings. I am using the influx batch node myself, which accepts arrays of timeseries measurements. Example how I insert data (note the tag to disting…

Thank you, but how can I generalise the code so that values are taken from ESP32? It would be a real-time data coming from ESP32.

Show us what the data from the esp looks like?

[ESp32_Output] This is what my esp32 output looks like, I have two device_IDs, and every 5secs I get data from these two devices which come as a string. As you can see in the first image, I just split the data and put it in JSON so that I can send it to AWS, but I need to do it with influxdb.

Do you have control of the esp code? If so then I suggest you change it to return a JSON string that you can feed into a JSON node to give you a javascript object. In the debug it shows a whole array of data, are you combining multiple readings together? If so then don't bother, just send them on…

// Parse the incoming message data var data = msg.payload; var parts = data.split(';'); var geodata = parts[0]; var device_id = parts[1]; var temperature = parts[2]; var humidity = parts[3]; var wind_speed = parts[4]; // Build the InfluxDB data point var timestamp = new Date().toISOString(); var me…

I have used the same syntax, I am just calling the measurement, field, and tags from the above piece of code. I tried doing it the same way as you mentioned and still, it doesn't give any output in influxdb.

The code you showed does not give anything like the structure I posted. Feed your output into a debug node and show us what it looks like. [Edit] I mean show us what you are feeding to the influx node.

// Parse the incoming message data var data = msg.payload; var parts = data.split(';'); var geodata = parts[0]; var device_id = parts[1]; var temperature = parts[2]; var humidity = parts[3]; var wind_speed = parts[4]; // Send the data point to InfluxDB [{ measurement: "windanalysis", field…

[image] dhanushmh: Debug looks like this after this function node Does that look like the structure I posted?

Node-RED

Node-RED Forum

Send JSON data to influxdb from Node-red

General

dhanushmh 15 February 2023 15:08 13

Could you please how can I change this in my code? I am a bit new to node-red and I am not understanding how can I write this. Sorry for the simple questions.

Topic		Replies	Views
Node-Red to InfluxDB General	4	161	18 May 2024
esp32-Tasmota-nodered-influx General	15	369	2 December 2023
Beginner-questions: save BMP280-Data to InfluxDB General	9	1094	14 January 2021
Node-RED data to influxDB General	9	6042	17 October 2019
Inporting data into InfluxDB database General database	19	268	7 May 2023

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Send JSON data to influxdb from Node-red

Related topics