API Reference
Public spreadsheet JSON API — read, write, and calculate.
Interactive reference for the public data API (/v1/:apiId). Generated from the OpenAPI schema.
| Operation | Method | Path |
|---|---|---|
| Read | GET | /v1/:apiId |
| Create | POST | /v1/:apiId |
| Replace | PUT | /v1/:apiId/:rowNumber |
| Update | PATCH | /v1/:apiId/:rowNumber |
| Delete | DELETE | /v1/:apiId/:rowNumber |
| Calculate | POST | /v1/:apiId/calculate |
For filter query syntax on reads, see Filtering.
Filtering
Filter expressions for GET requests on public data APIs.
Calculate spreadsheet outputs POST
Temporarily applies input values to A1 cell references and returns a flat alias-to-value map for requested output cells. Use `$sheet` to select a worksheet tab (defaults to the first sheet). Requires `calculate`; protected APIs accept `X-API-Key` or bearer auth. Supply `cf-turnstile-response` or `captchaToken` when calculate CAPTCHA is enabled. Example request: `{ "inputs": { "B2": 1000000 }, "outputs": { "B8": "emi" } }`; response: `{ "emi": 8678.03 }`.