JSON date format Integromat

939
2
Jump to solution
03-03-2022 11:37 AM
JayJohnsonWashoeCounty
Occasional Contributor III

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

Jay
Washoe County GIS
0 Kudos
1 Solution

Accepted Solutions
JayJohnsonWashoeCounty
Occasional Contributor III

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

JayJohnsonWashoeCounty_0-1647552093329.png

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/highl...

Jay
Washoe County GIS

View solution in original post

0 Kudos
2 Replies
JayJohnsonWashoeCounty
Occasional Contributor III

@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?

Jay
Washoe County GIS
0 Kudos
JayJohnsonWashoeCounty
Occasional Contributor III

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

JayJohnsonWashoeCounty_0-1647552093329.png

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/highl...

Jay
Washoe County GIS
0 Kudos