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, pleaseVisit the Current Forums.
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?
I was hoping there'd be something similar to the includeAll parameter so I could grab all the rows in one fell swoop, but I can just make the page bigger with pageSize and/or grab page by page. Out of curiosity, I wonder why you can do an all-grab for sheets but not reports?
I imagine it is due to the sheer size reports can be. For example a user in a large org can select all the sheets shared to them and come up with thousand and thousands of rows.
Benjamin Walker Employee
