Liquid Template unable to parse date correctly with time zone offset

Sumit Gaur 235

Hi Team,

we are using set-body policy with liquid template to transform our API request to backend soap service request. in the request we have a string field for creation date in which the datetime format comes like this : 2024-09-20T10:47:35.085884-04:00 with a time zone offset in respect to UTC. when we map this field as is to our liquid template the liquid template change the datetime format to 9/20/2024 2:47:35 PM where it removes the offset and gives us the UTC time. i have tried to use the Date filter as mentioned in the msdn documents, but it also not able to preserve the offset value and though format the date correctly as it comes in input but changes the time to UTC time with an offset of +00.00, e.g. 2024-09-20T14:47:35.085+00:00, the filter i use in this case was as shown below, how can i preserve the date in same format as it is coming in the original request.

 Date: "yyyy-MM-ddTHH:mm:ss.fffzzz"

LeelaRajeshSayana-MSFT 15,556 Reputation points Microsoft Employee

2024-09-23T17:16:45.85+00:00

Hi @Sumit Gaur Thank you for posting the question here. I was referencing the Liquid documentation on which this Liquid filters are based on. The filtering for the date format from the documentation appears to be following the strftime

Can you give a try on the following format date : "%m/%d/%Y %I:%M:%S.%L %p %z" and see if you get the expected result?
Sumit Gaur 235 Reputation points

2024-09-24T11:55:26.83+00:00

Hi @LeelaRajeshSayana-MSFT this won't work as Azure APIM uses dot-liquid version and set body policy is configured in C# mode and not ruby of the liquid template and it take date in pascal formatting as mentioned in here: https://learn.microsoft.com/en-us/azure/api-management/set-body-policy#using-liquid-templates-with-set-body

the above format don't work with Azure APIM or logic app where also you can use liquid template.
LeelaRajeshSayana-MSFT 15,556 Reputation points Microsoft Employee

2024-09-27T15:20:25.5933333+00:00

Hi @Sumit Gaur I just wanted to check if you have any additional questions or need any further assistance with this issue. If the below response answers your query, please do click Accept Answer and Yes for the answer, as it might be beneficial to other community members reading this thread. Thank you

1 answer

LeelaRajeshSayana-MSFT 15,556 Reputation points Microsoft Employee

2024-09-24T20:58:56.47+00:00
Hi @Sumit Gaur Can you please add the setting parse-date="false" within your like this

<set-body parse-date="false"> //get your date object </set-body>

This setting should prevent the dates from getting parsed to System.DateTime (mm/dd/yyyy hh:mm:ss) format and should retain the same date value. Please let us know if you encounter the same behavior even after applying this setting.
Please sign in to rate this answer.
Sumit Gaur 235 Reputation points

2024-09-25T09:15:47.9166667+00:00

Hi @LeelaRajeshSayana-MSFT

thanks you this has worked, date was not parsed this time.

LeelaRajeshSayana-MSFT 15,556 Reputation points Microsoft Employee

2024-09-25T13:47:20.37+00:00

Hi @Sumit Gaur Glad to know that the issue is resolved. I appreciate it if you can mark the response as Accepted Answer so that it would help other community members identify the solution. I appreciate your contributions on this platform.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Liquid Template unable to parse date correctly with time zone offset

1 answer

Your answer