Pagesize
Specifies the maximum number of records per page the provider returns when requesting data from Smartsheet.
Data Type
int
Default Value
1000
Remarks
When processing a query, instead of requesting all of the queried data at once from Smartsheet, the add-in can request the queried data in pieces called pages.
This connection property determines the maximum number of results that the add-in requests per page.
Depending on what entity is queried, there are additional restrictions for this property:
| Entity | Restrictions |
| Info_Sheets Info_Attachments Info_AttachmentVersions Info_Columns Info_Discussions Info_Groups Info_Users Info_CellHistory Info_Contacts Info_Favorites Info_WorkspaceShares Info_SheetShares Info_ReportShares Info_DashboardShares | The value must be smaller than 10000 and larger than 100. |
| Info_Workspaces Info_Folders Info_Objects Info_Sheets (Hierarchy Navigation) Info_Reports (Hierarchy Navigation) Info_Dashboards (Hierarchy Navigation) Info_Templates (Hierarchy Navigation) | The value provided will not affect these entities. Pagesize is set to 1000 for these entities and cannot be changed. |
Note: Setting large page sizes may improve overall query execution time, but doing so causes the add-in to use more memory when executing queries and risks triggering a timeout.