Need to change JSON response

[swatifunde]

Hello Community,

I want to 9know how can I get below JSON response

{
“pvProjectID”: “2427827wj”,
“p6ActivityList”: [
{
“pvPprojectID”: “smhcvxsn,x”,
“pvActivityId”: “mxcxzvcb”,
“imo_Vorgangskategorie”: null,
“okz_Komponentenstruktur”: “01”,
“imo_Prozessnummer_Code”: “.Jnxbz1”,
“imo_ZugNummer”: “0m,xzn7”,
“imo_WagenNummer”: “Z”,
“activityName”: “xzb IT”,
“plannedFinishDate”: “2029-02-14T17:00:00.000”,
“blProjectFinish”: “2029-02-14T17:00:00.000”
},
{
“pvActivityId”: “FmzbxzcD”,
“imo_Vorgangskategorie”: null,
“okz_Komponentenstruktur”: “xzbvbzx1”,
“imo_Prozessnummer_Code”: “bxz0”,
“imo_ZugNummer”: “0z7”,
“imo_WagenNummer”: “Z”,
“activityName”: “cxcxzx g”,
“plannedFinishDate”: “2029-03-08T17:00:00.000”,
“blProjectFinish”: “2029-03-08T17:00:00.000”
}
],
“errorText”: “string”
}

Right now I managed to get response in below format

Can some one help me here

[swatifunde]

If we want to add parameter(Project id) in the request URL, to fetch the data for a particular project ID then it would be single response so in that case no need to add Group by N snap. right?

I tried to pass Project ID as parameter but somehow it is not taking any affect on end API.

[bojanvelevski]

Yes, your statement is correct.

As for the other part, the problem must be in the logic where you included that parameter in the pipeline. Whether is in a Filter snap, in the Oracle snap itself, etc.