Pagesize Parameter (Connect-Smartsheet Cmdlet)
Specifies the maximum number of records per page the provider returns when requesting data from Smartsheet.
Syntax
Connect-Smartsheet -Pagesize int
Data Type
int
Default Value
500
Remarks
When processing a query, instead of requesting all of the queried data at once from Smartsheet, the cmdlet can request the queried data in pieces called pages.
This connection property determines the maximum number of results that the cmdlet 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 cmdlet to use more memory when executing queries and risks triggering a timeout.