v1

latestOpenAPI 3.0.32026-08-061874701.5 MB

sheets

List org sheets

Gets a summarized list of all sheets owned by the members of the organization account.

Who can use this operation?

Permissions: System Admin

You may use the query string parameter numericDates with a value of true to enable strict parsing of dates in numeric format. See Dates and Times for more information.

get/users/sheets

Query parameters

string date-time

number

When specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. If you need to keep track of frequent changes, it may be more useful to use Get Sheet Version.

Headers

Authorizationstring

API Access Token used to authenticate requests to Smartsheet APIs.

Response

IndexResultUnknownPages object containing an array of Sheet objects, limited to the following attributes:

id
name
owner: empty string
ownerId: (static "0")

pageNumbernumber

The current page in the full result set that the data array represents. NOTE when a page number greater than totalPages is requested, the last page is instead returned.

pageSizenumber nullable

The number of items in a page. Omitted if there is no limit to page size (and hence, all results are included). Unless otherwise specified, this defaults to 100 for most endpoints.

totalPagesnumber

If the data field value is not empty, returns a static value of -1. When you reach the first empty page after the end of the result set, then all four fields are set with a static value of “0”.

totalCountnumber

If the data field value is not empty, returns a static value of -1. When you reach the first empty page after the end of the result set, then all four fields are set with a static value of “0”.

Example response

{
  "pageNumber": 1,
  "pageSize": 50,
  "totalPages": -1,
  "totalCount": -1
}