rowsModifiedsince is not returning all rows meeting the criteria
![LJR](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I have an app that queries a source sheet, looks for rows modified in the last few days, checks if the attachment has already been posted to SharePoint, and, if not, grabs the attachment and posts it in SharePoint.
This is one if my GET calls …
https://api.smartsheet.com/2.0/sheets/[sheetID]?rowsModifiedsince=2025-01-30T01:00:00Z
(sheetID removed for security)
The returned dataset includes fourty-four (44) rows from the source Smartsheet sheet, but there should be fourty-six (46) rows. The two missing rows are within the rowsModifiedsince parameter.
This has happened a handful of times since putting this app into production. The dates are formatted correctly, and there are no other parameters on the GET call. I have not been able to deduce why the returned data set is incomplete. Can anyone help?
Answers
-
Could it be because your app is set to your timezone and the system columns are set to UTC?
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
-
@Michelle Choate 2 - I've tried adjusting rowsModifiedsince by as much as 48 hours thinking maybe there was some misconfig due to timezones, but the rows are still not included in the returned data set. I've also reached out to Smartsheet Support about this in the past, but they were not helpful. I've also tried different platforms (PowerAutomate and Postman), but the returned dataset did not change between platforms.
-
Hmm. That is super strange! @Darren Mullen - have you seen this behavior before?
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate
-
Thanks for the shout out. I've never queried a sheet over the API using the modifiedsince flag.
It would be interesting to see if you created a filter on the sheet based on the modified date does it give you what you want, and then you could GET the sheet with the filter applied by the filter ID.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives