Hey there, i have a esp32 with a DHT22 Sensor on it and let it send via mosquito in my node-red installation. Everything works fine so far. Now I try to keep that data to visualise it via Grafana. I want to store it in an influx database/ bucket but I don't have any luck to find out how to do that…

And for those who have the same problem in the future, here’s the oh so simple solution. Get a function node, put this in: msg.payload = Number(msg.payload); return msg; In my case Number(msg.payload.AM2301.Temperature); Plug it to the influx out node and there you go!

Have a look at node-red-contrib- influxdb

thanks, I didn't tell clearly I have a connecting to influx (through the influx out node) and I also can see my topics there, but my values are not there, so something must be wrong with my data format.

Without knowing what structure you've set in your InfluxDB data, we cannot know the answer. Have a search through the forum for an old post by me that recommends some settings and structures for storing sensor data (for home automation but it could be for anything). It shows some recommended ways o…

True, sorry for the inconvenience. msg.payload : Object object Time: "2023-11-16T18:04:41" AM2301: object Temperature: 19.8 Humidity: 59.9 DewPoint: 11.8 TempUnit: "C" That's what I get as "pure" Data from my ESP / Sensor. I googled couple hours now and couldn't find anything that`d help me how t…

[image] eli5: where I can read it. That would be the post I told you about.

Thank you, but sorry I can’t see there either the syntax and/or the nodes I need to use. In your post it’s necessary to know how sql databases work, what I neither know :face_with_peeking_eye: Please, could you give me a closer hint

[image] eli5: I plugged the "influx-out" node directly to the Tasmota node Click on the influx out node and then the little book tab in the right hand pane. That will tell you the valid formats for writing with that node. In addition the node's readme has a number of examples which should hel…

I thought you wanted to save all the fields, not just temperature. In fact, the temperature is already a number, so you don't the call to Number(). Which means you could just use a Change node to Move msg.payload.AM2301.Temperature To msg.payload.

I wanted first to understand how to save any value. If I could save them all together it’d be better I guess. But now I have something to start with. I’d really appreciate if you could tell me how to do that. When I gave influx the value without the number conversion, I get the error that it’s a s…

Node-RED

Node-RED Forum

esp32-Tasmota-nodered-influx

General

TotallyInformation 16 November 2023 17:21 7

How to effectively use InfluxDB - FAQs - Node-RED Forum (nodered.org)

Topic		Replies	Views
Send JSON data to influxdb from Node-red General	15	1055	1 March 2023
Data in influxdb General	7	250	7 February 2023
Node-Red to InfluxDB General	4	164	18 May 2024
Beginner-questions: save BMP280-Data to InfluxDB General	9	1096	14 January 2021
Multiple DS18B20 temperature sensor (Tasmota->NodeRed->InfluxDB)) General	7	5987	17 July 2019

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.

esp32-Tasmota-nodered-influx

Related topics