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…

Combine several messages from MQTT into one request to DataBase

General

Steve-Mcl 6 June 2020 21:20 10

Absolutely but sometimes its the right thing to do

however (another assumption) i suspect the OP thought he'd have to do 50 change nodes (hence wanting to avoid context)

Far too many assumptions

Topic		Replies	Views
Join messages from individual ''sensors'' into one json object Developing Nodes	25	3508	31 October 2020
Adding multiple MQTT data to one function node General	7	1300	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	1683	5 March 2021
Combining Messages General	11	1029	16 March 2020

Combine several messages from MQTT into one request to DataBase

Related Topics