Hello everyone! I'm a newbee at Node-Red and I'd like to collect information from my MQTT and push it to my database. Initially I subscribe for a branch of topics (Devices/+) and receive around 50 MQTT messages. Now I'd like to combine them into one single object and store it into database at once…

And fianlly it looks like this: [image] With code similar to this: switch (msg.topic){ case 'Dacha/pressure': lLocation="Dacha"; lArea="Pantry"; lMeasurement="Pressure" msg.valid=true; break; case 'Dacha/temp': lLocation="Dacha"; lA…

Steve-Mcl 6 June 2020 20:26 2

Indeed

See this article in the cookbook for an example of how to join messages into one object.

Topic		Replies	Views
Join messages from individual ''sensors'' into one json object Developing Nodes	25	3511	31 October 2020
Adding multiple MQTT data to one function node General	7	1319	5 October 2020
Combine a message from mqtt and a select result from db Dashboard	2	798	19 November 2019
Dynamically sending MQTT Messages from Object Array General	9	1684	5 March 2021
Combining Messages General	11	1030	16 March 2020

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.

Combine several messages from MQTT into one request to DataBase

Related Topics