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 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_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 add-in to use more memory when executing queries and risks triggering a timeout.