API & Developers

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

rowsModifiedsince is not returning all rows meeting the criteria

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

Trending in API & Developers