Hi, I want to write some data to InfluxDB. Everything works fine but now i want to write some tags instead of a fixed input. I've got the following but node red see it as text and not a var. [Function] It's propably something simple but i'm kinda new in this and just learning. Thanks at advanc…

OK, in that case you need something like this var counter=flow.get('count'); var text=flow.get('text'); msg.payload = [ { measurement: "Test", fields: { }, timestamp: new Date() } ]; msg.payload[0].fields[text] = counter return msg; However, it seems odd to…

[image] Ward: now i want to write some tags instead of a fixed input In Influxdb the word 'tag' has a specific meaning. Fields and Tags are very different. Do you mean you want to write the number in count to the field called text? That doesn't sound particularly likely. Can you explain e…

@bakman2 the code is inserted properly now. @Colin Indeed is just want to enter a field set no tag set. The text is just the field key and the number is the field value. I just want to insert a number (in the example 100) as field value in a flow var (count) and the name of the field key stored …

Thanks for the reply Colin. It's just for learning purposes but eventually i want collect data from a PLC and transmit those values at 5s intervals in InfluxDB and i want to alter the schema design like i want it. So no single valuepoint each writing. How do you suggest i do that best?

[image] Ward: i want to alter the schema design like i want it. So no single valuepoint each writing. Can you explain what you mean by that please and why you want to do it.

For example if we want to log the kwh of different machines. I want to make a measurement of a tagset and a fieldset where the tagset contains the name of the machine and the fieldset the value of the kwh every hour. So if we want to log a extra machine then we can write a different name in the tag…

OK, I understand what you want to do, but not what what problem you are having. If you always want to add data to the database with the current timestamp it is easier to use the Influxdb Out node rather than the batch node. Then all you have to do is to get the data in, put it all in the payload a…

That's absolutely true i just went further with a previous tutorial that ended with the batch node and now you mentioned it, it is better to use a Out node. Thanks alot for the info, now i can play a little more with the info given to me. Kind regards, Ward

Node-RED

Node-RED Forum

Adding a var in msg.payload

General

bakman2 17 April 2020 10:20 2

Please export your flow again, read this post and edit your post.

Topic		Replies	Views
Function won't populate tag in Influx database General	16	283	28 October 2025
NodeRed to InfluxDB, unable to set 'tags' General	19	704	15 March 2023
Not able to insert msg.tags in influx dB using node-red-contrib-influxdb General function-node , influxdb	4	96	19 June 2025
Transform data into InfluxDB data type(tags and fields) Industrial database , function-node	15	1045	13 December 2022
Input data to Influxdb with dynamic fields General	2	845	14 November 2021

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.

Adding a var in msg.payload

Related topics