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 driver can request the queried data in pieces called pages.
This connection property determines the maximum number of results that the driver 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 driver to use more memory when executing queries and risks triggering a timeout.