Return sheet properties#

Deprecated

This endpoint is deprecated and may be removed in a future release.

This endpoint was deprecated on 2026-02-12.

It is scheduled for sunset on 2029-01-31.

Description#

GET /spreadsheets/v1/spreadsheets/{spreadsheetId}/sheets/{sheetId}

Required OAuth Scopes

data_tables|r

Parameters#

Parameter

In

Type

Required

Description

X-Version

header

string

false

Version of the API (2022-01-01)

revision

query

integer(int32)

false

The spreadsheet revision from which to select data. If no revision is provided, the latest revision will be selected.

spreadsheetId

path

string

true

The unique identifier of the spreadsheet

sheetId

path

string

true

The unique identifier of the sheet

Code Samples#

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

headers = {
  'X-Version': '2022-01-01',
  'Accept': 'application/json',
  'Authorization': 'Bearer {access-token}'
}

r = requests.get('https://api.app.wdesk.com/spreadsheets/v1/spreadsheets/{spreadsheetId}/sheets/{sheetId}', headers = headers)

print(r.json())

Returns#

200 - OK#

Returns a JSON object with data and revision properties. data contains a Sheet object with details about the requested sheet.

400 - Bad Request#

An ErrorResponse object containing a message and list of errors.

401 - Unauthorized#

An ErrorResponse object containing a message and list of errors.

403 - Forbidden#

An ErrorResponse object containing a message and list of errors.

404 - Not Found#

An ErrorResponse object containing a message and list of errors.

500 - Internal Server Error#

An ErrorResponse object containing a message and list of errors.

Example Responses#

{
  "data": {
    "child_ids": [
      "h65a604b74564afa86b5ba96755845652"
    ],
    "id": "k78a604b74564afa76b5ba96755123456",
    "index": 0,
    "input_mode": false,
    "locked": false,
    "name": "Data Sheet",
    "parent_id": "d10a604b74564afa86b5ba96755845652",
    "restricted": false
  },
  "request_id": "d6a6ce3f-f120-4104-9587-a5a2dc45626c",
  "revision": 0
}