cancel
Showing results for 
Search instead for 
Did you mean: 

Need to change JSON response

swatifunde
Contributor

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
image

Can some one help me here

1 ACCEPTED SOLUTION

Apologies, the datatype is local datetime. That’s why.

I believe .toString() will do the job

View solution in original post

41 REPLIES 41

Leave the “$” in the mapping root.

If I did it then I am not getting expected response
image

I don’t need group field in the response

Map $group in the expression for $content

I got it now, there is still square bracket in the response . is it possible to remove it?or due to multiple objects it will be remain there.
image

If you check above, we did discuss the square brackets. But that was when I thought you are sending only one object in the response. If you’re sending multiple objects, you have to wrap them in an array, and send that array as one object (which you did with the group object name above, but you said you don’t need the response to be like that), or as a list of objects.