Convert mysql DB Tabel to nested JSON

ccontzen — Thu, 05 Oct 2023 09:37:16 GMT

Dear all,

im trying to create a JSON file from a mySQL Database Table.

the table looks like this:

the desired output should look like this

"ID":"1",

"Street":"Somewherestreet",

"City":"Somewherecity"

"Type": "FamilyHead",

"FirstName": "Chris",

"LastName": "Somebody",

"Members":[

{"FirstName": "Anna",

"LastName": "Somebody"},

{"FirstName": "Frank",

"LastName": "Somebody"}

"ID":"2",

....

Ho can i group the data and create a clean nested json?

Any hint would be helpful

Regards,

Christian

Re: Convert mysql DB Tabel to nested JSON

marlon-muela — Mon, 30 Oct 2023 12:35:14 GMT

You can use the data pill of the table output and use the formula .to_json to convert the value as a JSON output.