Hello everyone, I am just getting back into Node-Red and I am trying to send MQTT payloads. I have an Excel spreadsheet that contains one column with the topics and one column with the commands. I have read the excel using node-red-contrib-spreadsheet-in. This gives me an array of objects contai…

Not sure waht your output is as it not an array of objects. My best guess is it should be an array of strings. Try this [{"id":"5850ef51.1cf508","type":"inject","z":"20bb0f7f9fab47a8","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.…

Topic		Replies	Views
Problems with MQTT flow after Excel import and msg modifications General	7	280	29 April 2023
How to add topic in received payload array General	18	1385	19 November 2021
Split JSON Object Array General	34	1170	8 November 2024
Make an ARRAY after a text input node. General	18	2794	5 October 2019
Combining values from an Array into a single word General	24	317	5 August 2024

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.

How to create payloads (strings merged/concatenated from array objects) from Excel data?

Related topics