BlazeSheets
API Reference

Replace a row

PUT
/v1/{apiId}/{rowNumber}

Fully replaces the record at the 1-based data row number (excluding header) when update is granted. Use $sheet to select a worksheet tab (defaults to the first sheet). API keys may use X-API-Key or bearer auth. Supply cf-turnstile-response or captchaToken when update CAPTCHA is enabled. Domain, CORS, and rate limits apply.

Authorization

X-API-Key<token>

BlazeSheets API key used to access a protected public API.

In: header

Path Parameters

apiId*string
Formatuuid
rowNumber*integer

1-based data row number, excluding the header row.

Range1 <= value

Query Parameters

$sheet?string

Worksheet tab name (case-sensitive). Defaults to the first sheet when omitted.

Length1 <= length

Header Parameters

cf-turnstile-response?string

Required when CAPTCHA is enabled for this operation.

Request Body

application/json

Response Body

application/json

application/json

application/json

application/json

application/json

application/json

curl -X PUT "https://example.com/v1/497f6eca-6276-4993-bfeb-53cbbbba6f08/1" \  -H "Content-Type: application/json" \  -d '{    "property1": "string",    "property2": "string"  }'
{  "updated": 0,  "data": {    "property1": "string",    "property2": "string"  }}

Read rows GET

Reads datasource rows when the API grants `read`. Supports pagination (`limit`/`offset`), sorting (`sortColumn`/`sortDirection`), filtering (`filter`), field selection (`columns`), output `format` (`rows`|`columns`|`matrix`), `castNumbers`, and worksheet selection (`$sheet`). If API-key authentication is configured, send the key in `X-API-Key` or `Authorization: Bearer`. Domain restrictions, CORS, and rate limits are enforced. Read operations do not require CAPTCHA.

Partially update a row PATCH

Merges the provided fields into the record at the 1-based data row number (excluding header) when `update` is granted. Use `$sheet` to select a worksheet tab (defaults to the first sheet). API keys may use `X-API-Key` or bearer auth. Supply `cf-turnstile-response` or `captchaToken` when update CAPTCHA is enabled.