Reports and Pagination

mstew · 09/28/16

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 · 09/28/16

try the page parameter

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

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

mstew · 09/28/16

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 · 09/29/16

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!

Welcome to the Smartsheet Forum Archives

Reports and Pagination

Comments

Categories