Start a new topic

Format json entry (DIY no-code)

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!

1 person has this question

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,

Hello,


is there any news about to formatting timestamps?


Thanks, Alex

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.

Login or Signup to post a comment