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 21:15 6

The join is really simple. Give it a go.

Topic		Replies	Views
Join messages from individual ''sensors'' into one json object Developing Nodes	25	3710	31 October 2020
Creating Json message from multiple messages General	9	107	2 January 2025
Adding multiple MQTT data to one function node General	7	2056	5 October 2020
Combine a message from mqtt and a select result from db Dashboard	2	839	19 November 2019
Dynamically sending MQTT Messages from Object Array General	9	1773	5 March 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.

Combine several messages from MQTT into one request to DataBase

Related topics