Convert Unix timestamp to human-readable date using Liquid in APIM policy

Question

Hello,

I have timestamp value returned by Azure APIM policy using Liquid:

"date_last_beat": "1672157423"

and I would like to convert it to human-readable format using Liquid.

I tried something like this using "date" and "Date" but it does not work:

"date_last_beat" : "{{device.date_last_beat | date: %D}}"
"date_last_beat" : "{{device.date_last_beat | Date: %D}}"
"date_last_beat" : "{{device.date_last_beat | date: “%d/%m/%y”}}"

Is there something special when using it with Azure API Management?

Thanks

Answer 1

Hi @Djordje Novakovic Thanks for reaching out. Simple conversions like below works with liquid template however, for unix time (Epoch timestamp), it seems there is no way. The reason is that we use dotliquid nuget package and that package does not support this specific conversion

Reference: https://github.com/dotliquid/dotliquid/issues/322

Feel free to leave your feedback at aka.ms/apimwish so that other users who are in need to similar feature can upvote it and PG can take it forward.

Do let me know if you have any further queries.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.