Reports and Pagination

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!

Find more posts tagged with

API and Developers

Reports

Comments

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!