From a LoRaWan TTN node I get next payload: [payload] The path to value 3908 is payload_fields.echteld. The value 3908 (“echteld”) must be saved in an Influx DB (without password) on 192.168.2.185 named “waterstanden” via the Influx DB Out Node. These are my settings: [db1] [db2] I have trie…

Excellent, all working. So the final problem was just that you were using the wrong select statement to fetch the data. In Influx a measurement is roughly equivalent to a table in a conventional sql database.

I don't think much is right unfortunately. For example, what does it say about how to specify the measurement, and how have you tried to do that?

Hi Colin. Just tried (again) what is written in the info (see below), but no succes :frowning: Node Help A simple influxdb output node to write values and tags to an influxdb measurement. The fields and tags to write are in msg.payload . If msg.payload is a string, number, or boolean, it will…

So what don't you understand? If you don't understand the basics of message structure, have a look at the section in the node red docs on messages? https://nodered.org/docs/user-guide/messages

As far as my knowledge goes, even after reading all the info mentioned, I did nothing wrong setting up this node but still it doesn't work. That's why I'm here, asking a more experienced user to check and help me with the specific and right settings.

[image] HaVi: If the measurement field is not set in the node configuration, the user can send in data with a specified measurement name in msg.measurement to overwrite the measurement field in the configuration of the node. What have you done to achieve that?

Show us your flow where you are doing what the info says, which is to provide the measurement name in msg.measurement, or just to put the measurement name in the node if it is fixed. In the image you posted earlier you told the node to use a measurement named "msg.payload.echteld", which I assume i…

The measurement named "msg.payload.echteld" was one of many, please see the list of all I tried in the above post. Just did a fresh new install of NodeRED but the problem stays the same. This is my flow (TTN access key edited with xxxxxxxxxx): [{"id":"3588197a.a23a96","type":"tab","label":"Testen…

this page will explain how to get the right path to data (assuming it’s not a buffer). https://nodered.org/docs/user-guide/messages

[image] HaVi: The measurement named "msg.payload.echteld" was one of many Do you mean the actual name of the measurement is msg.payload.echteld or that the measurement name is in msg.payload.echteld?

Node-RED

Node-RED Forum

TTN Payload to InluxDB

General

HaVi 12 June 2019 10:58 9

I've tried them all:

msg.measurement
msg.echteld
echteld
payload.echteld
msg.payload
payload
object
payload.object
payload.object.echteld
object.echteld

Topic		Replies	Views
Store data in InfluxDB show in Chronograf General database	34	952	27 July 2022
Input data to Influxdb General database	35	2742	8 January 2022
Writing HTTP request values to InfluxDB General	28	2854	18 May 2019
Help needed with MQTT to influx General	23	4215	11 May 2020
Trouble writing to an InfluxDB General	10	606	22 May 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.

TTN Payload to InluxDB

Related topics