Format json entry (DIY no-code) : Support

K

Kilvearn

started a topic 10 months ago

Hello, I'm using the DIY app, in the "no-code" version. I'm using a URL that returns a JSON and I want to get some date from it and format it (pretty print). Unfortunately, in the JSON, the date has this format : 2024-03-13T17:27:17+0100 And in the DIY, I cannot find any way to format it with a pattern (e.g. dd/MM/yyyy). Is there any way to do it with the no-code version? Thanks a lot in advance for any help!

LaMetric Support

said 10 months ago

Hi!

Thanks for reaching out to us and for sharing your feedback.

Unfortunately, currently, it isn't possible to return data in the format you described.

But we will take your request into our account when working on further updates.

Best regards,

A

Alexander Palm

said 7 months ago

Hello,

is there any news about to formatting timestamps?

Thanks, Alex

A

Adam Tony

said 3 months ago

In the DIY app's no-code version, you can format a date from a JSON string by extracting the relevant parts year, month, and day using string manipulation. Split the date string at the T to isolate the date portion, and then rearrange it to the desired format dd/MM/yyyy by concatenating the day, month, and year.

How can we help you today?