Forum | Appery.io

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

Hello,

It is impossible to use parameters with the same name in the only one JSON object

What I want to do is take the output of the JSON (api express SQL component), change the grouping and then give the final changed JSON response.

Can be done by Mapping component?

The result I want is (simplyfied)

Food
4, Fast Food
5, Mexican

Sport
3, Tenis

So using Mapping component, I would like to group the initial output by MenuName (Food, Sport)

Or can by done in a Script component?

Any feedback please. Should have been easy.

You use incorrect JSON format, please use JSON below:
pre{
{"MenuName": "Food"},
{"MenuSub":[
{
"MenuSubID": 1,
"MenuSubName": "Fast Food"
},
{
"MenuSubID": 4,
"MenuSubName": "Food"
}
]}
}/pre