Smartsheet API response is incomplete.

tegautam

I am using this API -

https://api.smartsheet.com/2.0/sheets/{SHEETid}?rowsModifiedSince=2023-01-15T00:00:00.000 , this is not returning all the rows that are modified since the given time.

From the UI , I can apply the same filter and get desired rows.

Genevieve P.

Hi @tegautam

Is it possible that you're seeing different results based on time-zone?

The Smartsheet API uses the UTC time zone in ISO-8601 format, see: Dates and Times in the API documentation.

This means that if you're looking for rows modified since January 15th at 00:00, it's looking for 00:00 in UTC. However if you're based in a different timezone, for example if you're in Sydney, Australia with a timezone of AEDT, then there are 11 hours between UTC and AEDT. Therefore, rows modified in the first 11 hours of your day would not show up as they would be seen as being modified in January 14th in UTC.

Then if you're using the Modified Date system column in your sheet, this will show you time based on your current profile settings, meaning that rows modified in your timezone would show up in the filter.

Let me know if that helps explain your missing data!

Cheers,

Genevieve