Live Data Connector changed Modified Date/Time?

James Keuning

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?

Genevieve P.

Hi @James Keuning

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

Genevieve P.

Hi @James Keuning

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

James Keuning

Thanks Genevieve!