topic Re: JSON date format Integromat in ArcGIS Online Questions

JSON date format Integromat

JayJohnsonWashoeCounty — Thu, 03 Mar 2022 19:37:52 GMT

I'm generating an email on an added feature in an AGOL hosted feature layer.

Along with other attribute data I'd like to include a date from an attribute field in the email.

Currently, I'm getting this in the JSON:

"startDate":1804105800000,"endDate":1804116600000

How can I convert this to human readable in the body of the email?

Jay

Re: JSON date format Integromat

JayJohnsonWashoeCounty — Thu, 03 Mar 2022 23:31:49 GMT

@Anonymous User - Hey Peter, any thoughts on why a date from an AGOL hosted feature layer would be coming through Integromat in JSON as (presumably) milliseconds from 1970 instead of something more usable?

Any way to parse this into human readable format in Integromat?

Re: JSON date format Integromat

JayJohnsonWashoeCounty — Thu, 17 Mar 2022 21:25:14 GMT

The solution to formatting this kind of date properly in Integromat (now Make) is as follows:

Thanks to an old post from an AnonymousUser for this solution: https://community.esri.com/t5/arcgis-survey123-questions/webhook-emailed-date-issue/m-p/794129/highlight/true#M8984