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	8	262	13 May 2023
How to add topic in received payload array General	19	1360	3 December 2021
Split JSON Object Array General	35	1044	6 February 2025
Make an ARRAY after a text input node. General	18	2753	5 October 2019
Combining values from an Array into a single word General	25	293	3 November 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