API Reference

Retrieve a list of spreadsheets

Description

Returns a paginated list of spreadsheets.

GET /spreadsheets

🚧

Required OAuth Scopes:

file:read

Parameters

ParameterInTypeRequiredDescription
$filterquerystringfalseThe properties to filter the results by.
$orderByquerystringfalseOne or more comma-separated expressions to indicate the order in which to sort the results.
$maxpagesizequeryintegerfalseThe maximum number of results to retrieve
$nextquerystringfalsePagination cursor for next set of results.

Filter Options

Available logical operators: and

NamePredicates Supported
namecontains
templateeq

Sorting Options

NameOrders Supported
modified.dateTimeasc, desc
nameasc, desc

Code Samples

curl -X GET https://api.app.wdesk.com/platform/v1/spreadsheets  \ 
-H 'Accept: application/json' \ 
-H 'Authorization: Bearer {access-token}'
http GET https://api.app.wdesk.com/platform/v1/spreadsheets  \ 
Accept:application/json \ 
Authorization:"Bearer {access-token}"
wget --method=GET "https://api.app.wdesk.com/platform/v1/spreadsheets" \
 --output-document -  \ 
 --header 'Accept: application/json' \ 
 --header 'Authorization: Bearer {access-token}'
import requests
headers = {
  'Accept': 'application/json',
  'Authorization': 'Bearer {access-token}'
}

r = requests.get('https://api.app.wdesk.com/platform/v1/spreadsheets', headers = headers)

print(r.json())

Returns

200 - OK

Returns a JSON object with data and @nextLink properties. data contains a list of Spreadsheet objects, and @nextLink provides the URL to the next set of results. If there are no additional results, @nextLink doesn't appear. If the request returns no results at all, data contains an empty array.

Example Responses


{
  "data": [
    {
      "created": {
        "dateTime": "2018-10-21T15:03:27Z"
      },
      "name": "Year-end review",
      "id": "124efa2a142f472ba1ceab34ed18915f",
      "modified": {
        "dateTime": "2018-10-21T15:03:27Z"
      },
      "template": false
    },
    {
      "created": {
        "dateTime": "2020-02-20T15:03:27Z"
      },
      "name": "Q1 Review",
      "id": "164cfb2b132c4623a2cfaa31ef13925a",
      "modified": {
        "dateTime": "2020-03-29T13:15:27Z"
      },
      "template": false
    }
  ],
  "@nextLink": "{opaqueUrl}"
}