Select to view content in your preferred language

EXTRACT TIME IN AGOL using API

112
2
Jump to solution
2 weeks ago
AAlkhri
New Contributor

Question: Converting Timestamps from AGOL User Data to Human-Readable Dates 

 

I'm using the following URL to extract user information from my ArcGIS Online (AGOL) account:

 

https://[My_AGOL_Account].arcgis.com/sharing/rest/portals/self/users?start=@Value(start)&num=100&f=json

 

This returns user data, including a field called `lastLogin` (or similar), which contains timestamps in Unix epoch format in milliseconds — for example: `1634238560000` or `1753130454000`.

 

When I paste these values into an [Epoch Converter](https://www.epochconverter.com/), they correctly translate to human-readable dates. However, when I try to convert them in **FME**, I can't get the TimeConverter** transformer to work properly. I've tried various formats and settings, but FME doesn't interpret the timestamp correctly.

 

**My Question:** 

How can I convert these millisecond-based Unix timestamps (like `1634238560000`) into readable date/time values for the entire table ?

 

 

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
AAlkhri
New Contributor

what was working with me is remove the digits , so the number will be just 10 dig 1634238560. SO THAT ACCPET TO COVERT 

View solution in original post

0 Kudos
2 Replies
JoshuaBixby
MVP Esteemed Contributor

Originally seconds was the granularity of Unix time, and some time converters are still stuck in the past.  Try converting milliseconds to seconds and see if the time converter works.

0 Kudos
AAlkhri
New Contributor

what was working with me is remove the digits , so the number will be just 10 dig 1634238560. SO THAT ACCPET TO COVERT 

0 Kudos