Reports and Pagination

mstew

Hi!

  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!

Benjamin Walker

try the page parameter

http://smartsheet-platform.github.io/api-docs/#paging

 

/reports/{{reportId}}?page=2

mstew

Great, thanks!  Got it working

 

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?

Benjamin Walker

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.

 

Glad you got it working!