Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Reports and Pagination

edited 12/09/19 in Archived 2016 Posts


  I've written a google script that mirrors a smartsheet - it checks hourly and syncs the google sheet to reflect the latest info in smartsheets.  It works great with sheets, and all of the rows populate correctly.  However, when I switch the target to a report, only 100 rows will sync.  


When I switched to looking at a report, I changed the url and everything so that I am reading data from the report - the first 100 rows are right.  I read the section of the dev notes about pagination and the includeAll=true parameter.  This is working fine for sheets, but not reports.  Do reports support pagination, and if so, is there a different option or parameter I should use to get around the default 100 rows?  


Thanks for any insight!


This discussion has been closed.