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…

dceejay 6 June 2020 21:16 7

If you're doing it in a function node - just use local context - no need to expose it to the flow.

Topic		Replies	Views
MQTT to MYSQL help is needed General database , function-node , mqtt	4	511	21 May 2022
Code function to collect data from mqtt General database , function-node	5	1221	31 January 2022
Adding multiple MQTT data to one function node General	7	2190	5 October 2020
Input multiple sensor outputs into mysql General	13	1937	16 November 2020
MySQL NODE-RED table General	33	11598	8 February 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.

Combine several messages from MQTT into one request to DataBase

Related topics