Get Report Data
smartsheet_get_reportRetrieve data from a Smartsheet report using its ID. Returns columns, rows, and cell values with pagination support for large reports.
Instructions
Retrieve data from a Smartsheet report by ID. Reports aggregate rows from multiple sheets. Returns columns, rows, and cell values just like a sheet, but the rows may originate from different source sheets. Supports pagination since reports can have very large row counts.
Args:
report_id (number): The numeric Smartsheet report ID
page_size (number, optional): Rows per page (default 100, max 500)
page (number, optional): Page number (default 1)
level (number, optional): Hierarchy level (0 = all, 1 = summary only)
Returns: Report metadata, columns, and rows with source sheet context.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| report_id | Yes | Smartsheet report ID | |
| page_size | No | ||
| page | No | ||
| level | No | Hierarchy depth (0=all rows, 1=summary rows only) |