Pagesize
Specifies the maximum number of records per page the provider returns when requesting data from Smartsheet.
Data Type
int
Default Value
500
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_Workspaces | The value must be a multiple of 100 in the 100 - 1000 range (inclusive). |
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.