You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository was archived by the owner on Jan 9, 2023. It is now read-only.
According the Smartsheet API documentation, the Get Report endpoint should allow all rows of a Summary Report to be returned when you do not enter the pageSize or page query parameters in the API call:
If neither pageSize nor page is specified, returns all rows in the sheet.
However, when I use the get_report function in practice, the page_size argument must be still defaulting to 100, because I only get the first 100 rows of my Summary Report returned.
importsmartsheetreport_name="My Summary Report Example"# Get Report Id using nameaction=smartsheet_client.Reports.list_reports(include_all=True)
reports=action.dataforreport_infoinreports:
ifreport_info.name==report_name:
report_id=report_info.id# Retrieve rows from Reportsheet=smartsheet_client.Reports.get_report(report_id, page_size=None, page=None, level=2)
I tried setting page_size=None only, both page_size=None and page=None (as shown in code snippet above), and omitting page_size entirely, but none of those combinations were able to return my full report (181 rows). Only when I explicitly set page_size=200 then did my result return as expected (all 181 rows).