Live Data Connector changed Modified Date/Time?
I use the Live Data Connector (LDC) to pull data into an Access database. I wasn't seeing some recent changes, so I wrote a query to find the MAX of MODIFIED, and I was surprised to see the MODIFIED field through the LDC hadn't happened yet! It's 10:30 AM here (USA Central) and the LDC is telling me that my records were modified at 4:30 PM.
Does Smartsheet display the time in the Pacific time zone, and the LDC use GMT?
Best Answer
-
The time that's displayed in your Smartsheet account will be based on your Personal Settings, see: Adjust Your Personal Account Settings.
However, the Live Data Connector uses the Smartsheet API, which returns all dates and times in the UTC time zone in ISO-8601 format. (See the API documentation on this, here: https://smartsheet-platform.github.io/api-docs/#dates-and-times)
More information can be found in the Smartsheet Live Data Connector documentation, here. I hope this helps!
Cheers,
Genevieve
Answers
-
The time that's displayed in your Smartsheet account will be based on your Personal Settings, see: Adjust Your Personal Account Settings.
However, the Live Data Connector uses the Smartsheet API, which returns all dates and times in the UTC time zone in ISO-8601 format. (See the API documentation on this, here: https://smartsheet-platform.github.io/api-docs/#dates-and-times)
More information can be found in the Smartsheet Live Data Connector documentation, here. I hope this helps!
Cheers,
Genevieve
-
Thanks Genevieve!
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives