API express change JSON result format

[Takis]

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

[Serhii Kulibaba]

Hello,

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

[Takis]

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?

[Takis]

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)

[Takis]

[Takis]

[Takis]

[Takis]

Or can by done in a Script component?

[Takis]

Any feedback please. Should have been easy.

[Serhii Kulibaba]

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