Query parameters
Many API calls can be modified by including one or more of these common query strings:
| Query Parameter | Type | Description | More Info |
|---|---|---|---|
| accessApiLevel | Number | Allows COMMENTER access for inputs and return values. For backwards-compatibility, VIEWER is the default. For example, to see whether a user has COMMENTER access for a sheet, use accessApiLevel=1. | |
| allowPartialSuccess | Boolean | If true, allows bulk operations to process even if one or more operations are invalid for some reason, for example, allowPartialSuccess=true. | Bulk Operations |
| include or exclude | String | When applicable for a specific object, various include or exclude parameters are available, for example, include=format. | Object reference or cell formatting |
| includeAll | Boolean | If true, includes all results, for example, includeAll=true. | Paging |
| level | Number | Use for complex objects. | Working with Complex Objects |
| numericDates | Boolean | If true, allows you to input or receive dates in numeric format, for example, numericDates=true. | Dates and Times |
| page | String | Specifies which page to return, for example, page=4. | Paging |
| pageSize | Number | Specifies the maximum number of items to return per page, for example, pageSize=25. | Paging |
NOTE: Query strings are case sensitive. If you do not see the expected response, confirm that your query is formatted correctly.