Need help with your APIs? I offer API discovery, governance & evangelism services. Explore services →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Quadratic Cells API

Read and write cell values, code, formulas, formats, borders, and merges.

Quadratic Cells API is one of 14 APIs that Quadratic publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include Cells. The published artifact set on APIs.io includes an OpenAPI specification and authentication docs.

This API exposes 16 operations across 11 paths, and defines 12 schemas. It is described by OpenAPI 3.1.0, at version 0.26.9.

Requests are made against the base URL https://developer-api.quadratichq.com.

16 operations 11 paths 12 schemas 2 DELETE5 GET3 POST6 PUT

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.1.0
API Version
0.26.9
Base URL
https://developer-api.quadratichq.com
Authentication
HTTP Bearer
Contact
Quadratic
License
Apache-2.0
Resource Areas
1

Authentication & Security 1

Quadratic Cells API declares 1 security scheme for authenticating requests. It accepts HTTP bearer tokens (API token (qdx_live_… or qdx_test_…)) (bearer_auth).

  • bearer_auth — API tokens are minted from the Quadratic UI under Team Settings → API Tokens. Send as Authorization: Bearer .

Paths & Operations 16

Across 11 paths, the API surfaces 16 operations — 2 DELETE, 5 GET, 3 POST, 6 PUT. Each is listed below with its method, path, parameters, and response codes.

Cells 16

Read and write cell values, code, formulas, formats, borders, and merges.

GET
/v1/files/{file_id}/cells
Reads cell values for a selection. Read-only; dispatches via /mcp/query.
getCells 4 params → 200401502
PUT
/v1/files/{file_id}/cells
Writes a 2D block of values starting at topleftposition.
setCellValues 1 param body → 200400401502
DELETE
/v1/files/{file_id}/cells
Deletes the contents of every cell in the selection.
deleteCells 1 param body → 200400401502
PUT
/v1/files/{file_id}/cells/borders
Applies cell borders in batch.
setBorders 1 param body → 200400401502
GET
/v1/files/{file_id}/cells/code
Fetches the source and computed value of a single code cell.
getCodeCell 3 params → 200401404502
PUT
/v1/files/{file_id}/cells/code
Creates or updates a Python / JavaScript / Formula code cell.
setCodeCell 1 param body → 200400401502
POST
/v1/files/{file_id}/cells/code/rerun
Triggers re-execution of code cells in the file (or selection).
rerunCode 1 param body → 200401502
GET
/v1/files/{file_id}/cells/dependencies
Lists the formula / code-cell dependencies that flow into or out of the given position.
getDependencies 4 params → 200401502
GET
/v1/files/{file_id}/cells/formats
Reads cell formatting (font, color, alignment, etc.) for a selection.
getFormats 4 params → 200401502
PUT
/v1/files/{file_id}/cells/formats
Applies formatting to one or more cells in a single batch.
setFormats 1 param body → 200400401502
PUT
/v1/files/{file_id}/cells/formula
Writes one or more formula cells in a single batch.
setFormulaCells 1 param body → 200400401502
GET
/v1/files/{file_id}/cells/has-data
Returns whether any cell in the selection contains data.
hasCellData 3 params → 200401502
POST
/v1/files/{file_id}/cells/merge
Merges every cell in the selection into a single visual cell.
mergeCells 1 param body → 200400401502
DELETE
/v1/files/{file_id}/cells/merge
Splits previously-merged cells back into individual cells.
unmergeCells 1 param body → 200400401502
POST
/v1/files/{file_id}/cells/move
Moves a rectangular block of cells to a new location.
moveCells 1 param body → 200400401502
PUT
/v1/files/{file_id}/cells/sql
Creates or updates a SQL code cell backed by a registered connection.
setSqlCell 1 param body → 200400401502

Schemas 12

The contract defines 12 schemas that model the data the API accepts and returns. The most detailed are SetSqlCellRequest (6 properties), SetCodeCellRequest (5 properties), ErrorDetail (3 properties), SetCellValuesRequest (3 properties). Each schema is shown below with its type and property counts.

MergeCellsRequest
object
2 properties 1 required
ErrorDetail
object
3 properties 2 required
SetSqlCellRequest
object
6 properties 5 required
MoveCellsRequest
object
3 properties 2 required
SetCodeCellRequest
object
5 properties 4 required
SetFormulaCellsRequest
object
1 property 1 required
ErrorBody
object
Canonical error envelope returned by every non-2xx response.
1 property 1 required
DeleteCellsRequest
object
2 properties 1 required
RerunCodeRequest
object
2 properties
SetCellValuesRequest
object
3 properties 2 required
SetFormatsRequest
object
1 property 1 required
SetBordersRequest
object
1 property 1 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

quadratic-cells-api-openapi.yml Raw ↑

Other APIs Quadratic publishes across the network.

Quadratic Agent Connections API
Quadratic Auth API
Quadratic Columns and rows API
Quadratic Conditional formats API
Quadratic Connections API
Quadratic Context, outline, search API
Quadratic Documentation API
Quadratic Files API
Quadratic Health API
Quadratic History API
Quadratic Sheets API
Quadratic Tables API