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

pmancevski
New Contributor III

Hi @swatifunde,

It would be good if you add the structure of incoming data. It would be easier to help you.

Thanks,
Pero M.

swatifunde
Contributor

thanks for your response, I donโ€™t have access on source system to change response

swatifunde
Contributor

Is there anyone who can help me with this ??

koryknick
Employee
Employee

@swatifunde - I believe that @pmancevski was simply asking for you to paste the textual response you currently have so we can work towards the format you need. It makes coming up with the expressions easier if you donโ€™t need to try to recreate the original structure.