Hi, I have searched & read through some of the topics on here to figure this out before posting, however I haven't found anything to help me solve this. Prior to looking on here I have made several attempts to work this out and none came close to what I want to achieve therefore not even worth post…

If i understand correctly, try this example [{"id":"48fe1953.6ae07","type":"inject","z":"b779de97.b1b46","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"name\":\"tom field\",\"roomaccess\":\"room 4\",\"time…

thierryd 21 September 2021 15:11 5

@E1cid Thank you! This is exactly what I was looking for. It would have taken me forever to work out the code in the change node

Topic		Replies	Views
Extracting data from arrays and concatanating General	6	69	10 October 2024
Get number from output mysql General	3	332	19 April 2020
Extract specific values from nested JSON array from Influxv2 query General database	8	2193	4 August 2022
Store and retrieve an array from database General	4	1402	10 June 2021
How to convert object into array? General	6	4797	13 October 2020

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.

Nested Array from MySQL Statement

Related topics