Bulk upsert of datasets

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#

Asynchronously upserts an array of datasets to a spreadsheet, given their properties. Each sheet can have only one dataset, and its range will always start with A1.

Bulk upsertion creates or updates datasets in sheets and performs any calculations after it completes. When complete, the dataset’s range is locked through both the UI and endpoints that write values to a sheet. To change the values in a dataset, either upsert new values using this endpoint again, or delete the dataset.

If any dataset fails to upsert, no datasets upsert, and no changes commit.

Each dataset in the array requires sheet and values. Partial upserts are not supported.

Values may be strings, numbers, integers, or booleans. To indicate an empty cell, provide an empty string.

POST /platform/v1/spreadsheets/{spreadsheetId}/datasets/bulkUpsert

Required OAuth Scopes

file:write

Parameters#

Parameter	In	Type	Required	Description
X-Version	header	string	false	Version of the API (2022-01-01)
spreadsheetId	path	string	true	The unique identifier of the spreadsheet
body	body	Datasets	true	An array of datasets

Body parameter example#

[
  {
    "sheet": "27f1b61c04ae4b0991bc73c631914e1d",
    "values": [
      [
        1,
        4
      ],
      [
        2,
        ""
      ]
    ]
  }
]

Code Samples#

curl

curl -X POST https://api.app.wdesk.com/platform/v1/spreadsheets/{spreadsheetId}/datasets/bulkUpsert \
    -H 'Content-Type: application/json' \
    -H 'Accept: application/json' \
    -H 'Authorization: Bearer {access-token}' \
    -H 'X-Version: 2022-01-01'

httpie

http POST https://api.app.wdesk.com/platform/v1/spreadsheets/{spreadsheetId}/datasets/bulkUpsert \
    X-Version:2022-01-01 \
    Content-Type:application/json \
    Accept:application/json \
    Authorization:"Bearer {access-token}"

wget

wget --method=POST "https://api.app.wdesk.com/platform/v1/spreadsheets/{spreadsheetId}/datasets/bulkUpsert" \
    --output-document -  \ 
    --header 'Content-Type: application/json' \ 
    --header 'Accept: application/json' \ 
    --header 'Authorization: Bearer {access-token}' \
    --header 'X-Version: 2022-01-01'

python

import requests

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

r = requests.post('https://api.app.wdesk.com/platform/v1/spreadsheets/{spreadsheetId}/datasets/bulkUpsert', headers = headers)

print(r.headers['Location'])