Customer Forum

Change date time formats for API response

KPS Posted: 2019-02-20 04:24


When I retrieved a user using API I got the datatime format as given below:
"updated_at": "Tue Feb 19 07:21:12 UTC 2019"
Is it possible to provide any other data time format for the responses via customization in the Workbooks desktop? Is this according to the format '%o %B %Y %H:%M:%S %Z'?

Please suggest.

Sam (Workbooks Online) Posted: Wed, 20.02.2019 - 11:59

Hi Krishna,

By default the API will return the long datetime format in  '%o %B %Y %H:%M:%S %Z', however datetime fields also have a short format of '%d/%m/%Y %H:%M:%S'. I would recommend referring to our API Developer Guide where we do have a section on Dates & Times which contains information on how to format these.

Hope this helps.