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. Can someone help me here please, im pretty new to all that stuff and a bit lost right now. Thanks in advance

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 of using tags and values.

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 to format / handle my data. I plugged the "influx-out" node directly to the Tasmota node and also tried to ask chat-gpt (with not really helpful results). Both attempts gave me just the keys in my bucket in influx but no value in it. So im looking for someone to tell me how its usually done or where I can read it.

[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 help. node-red-contrib-influxdb (node) - Node-RED

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 string and no visualisation is possible.

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	14	1182	15 February 2023
Data in influxdb General	6	276	9 December 2022
Node-Red to InfluxDB General	3	185	18 February 2024
Beginner-questions: save BMP280-Data to InfluxDB General	8	1144	15 November 2020
Multiple DS18B20 temperature sensor (Tasmota->NodeRed->InfluxDB)) General	7	6026	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