โ09-23-2022 07:57 AM
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
Solved! Go to Solution.
โ10-06-2022 06:42 AM
Apologies, the datatype is local datetime. Thatโs why.
I believe .toString()
will do the job
โ10-06-2022 06:25 AM
Thatโs how datetime, binary and some other datatypes are handled in Snaplogic. If you need plain string value for the date fields, youโll need to stringify them.
$plannedFinishDate.toLocaleDateTimeString()
โ10-06-2022 06:37 AM
I already tried that option but getting Null values
โ10-06-2022 06:42 AM
Apologies, the datatype is local datetime. Thatโs why.
I believe .toString()
will do the job
โ10-06-2022 07:00 AM
Thanks a lot for your support ๐
โ10-06-2022 07:02 AM
Anytime @swatifunde