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…

Nested Array from MySQL Statement

General

thierryd 21 September 2021 12:34 3

Thanks for the prompt response...
I meant to include this but forgot. This is something similar to what I'm aiming for, I'd like the 'pin' to be nested beneath 'id'. Ignore the rfid's as I won't be using those for the moment.

Topic		Replies	Views
Extracting data from arrays and concatanating General	6	57	10 October 2024
Combining "form" and "dropdown" payload data and building a mysql query General	3	1267	20 July 2020
Function Arrays from Database General	3	936	2 August 2019
Insert array of json data in mariadb General	19	4634	28 October 2018
Extract SQL data from database General	10	6578	20 December 2021

Nested Array from MySQL Statement

Related topics