JSON Deserialize Step Date field issue

Unknown

JSON Deserialize Step Date field issue

Unknown

Hi,

I have an issue with the regional date format. I’m using to deserialize a string being returned from an external rest service (Deserialize step).

When the day of date value is less than 13 (Europe format) it works. It’s obviously a regional formatting issue but I don’t know how to resolve it for this step to work.

Thanks

Unknown

Hi,

Unfortunately, we do not have a native setting for data structure Date type conversion for the moment. However, you can use a workaround to fix this issue. For the workaround, you should change the data type of Date property in the JSON structure to String and use Parse Date with Format step after JSON Deserialize step. So, JSON Deserialize step will output date values as a string and you will format this value by using Parse Date with Format step. Please check below forum post for details. If you have to use this conversion in many places, then you can create a converter flow and apply it in necessary flows. Please check the below link about building converter flows.

https://support.decisions.com/forum/topic2550-date-format-issue.aspx
https://documentation.decisions.com/docs/using-converter-flows

Regards