How can we help you today?

Start a new topic
Discussions LaMetric Forums Development topics

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
4 CommentsSorted by Oldest First

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.

If you're familiar with scripting languages like JavaScript or Python, you can write a custom script to fetch the JSON data, parse the date, and format it as desired. You can then integrate this script into your DIY app using a web hook or other integration methods.

Login or Signup to post a comment
More topics in Development topics
See all 149 topics