Hello
I used API express, I connected to an external MYSQL, OK.
I created the call OK and I get the below response, after executing my SQL query
[{
"MenuName": "Food",
"MenuSubID": 4,
"MenuSubName": "Fast Food"
}, {
"MenuName": "Food",
"MenuSubID": 5,
"MenuSubName": "Mexican"
}, {
"MenuName": "Sport",
"MenuSubID": 3,
"MenuSubName": "Tenis"
}]
through an SQL component
I THEN want to change the format of this JSON result, via Script component (?) to the below
"MenuName": "Food"
"MenuSubID": 4, "MenuSubName": "Fast Food"
"MenuSubID": 5, "MenuSubName": "Mexican"
"MenuName": "Sport"
"MenuSubID": 3 "MenuSubName": "Tenis"
Thanks