> ## Documentation Index
> Fetch the complete documentation index at: https://chatobserver.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# How do I read and write data with an authorised spreadsheet client?

> Access document-bound client sessions, queries, schedules, bindings and write claims.

Access document-bound client sessions, queries, schedules, bindings and write claims.

Read [authentication](/docs/developers/authentication), [pagination and filters](/docs/developers/pagination-and-filters), and [safe writes and retries](/docs/developers/safe-writes) before integrating. Each endpoint below includes its request parameters, response schema, and code examples.

## Endpoints

* [List spreadsheet bindings](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-bindings) — `GET /api/v2/metrics/client/bindings`
* [Create a spreadsheet binding](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-bindings) — `POST /api/v2/metrics/client/bindings`
* [List source catalogues](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-catalogues) — `GET /api/v2/metrics/client/catalogues`
* [List data connections](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-connections) — `GET /api/v2/metrics/client/connections`
* [List data connectors](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-connectors) — `GET /api/v2/metrics/client/connectors`
* [List workspace members](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-members) — `GET /api/v2/metrics/client/members`
* [List operations](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-operations) — `GET /api/v2/metrics/client/operations`
* [Create an operation](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-operations) — `POST /api/v2/metrics/client/operations`
* [List saved queries](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-queries) — `GET /api/v2/metrics/client/queries`
* [Create a query](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-queries) — `POST /api/v2/metrics/client/queries`
* [List refresh schedules](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-schedules) — `GET /api/v2/metrics/client/schedules`
* [Create a refresh schedule](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-schedules) — `POST /api/v2/metrics/client/schedules`
* [Inspect the spreadsheet session](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-session) — `GET /api/v2/metrics/client/session`
* [Revoke the spreadsheet session](/docs/api-reference/spreadsheet-clients/delete-v2-metrics-client-session) — `DELETE /api/v2/metrics/client/session`
* [List query templates](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-templates) — `GET /api/v2/metrics/client/templates`
* [Create a spreadsheet write claim](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-writes) — `POST /api/v2/metrics/client/writes`
* [Delete a spreadsheet binding](/docs/api-reference/spreadsheet-clients/delete-v2-metrics-client-bindings-binding-id) — `DELETE /api/v2/metrics/client/bindings/{bindingId}`
* [Get an operation](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-operations-operation-id) — `GET /api/v2/metrics/client/operations/{operationId}`
* [Delete a spreadsheet write claim](/docs/api-reference/spreadsheet-clients/delete-v2-metrics-client-writes-write-claim-id) — `DELETE /api/v2/metrics/client/writes/{writeClaimId}`
* [Transfer spreadsheet resource ownership](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-bindings-binding-id-ownership) — `POST /api/v2/metrics/client/bindings/{bindingId}/ownership`
* [Create a version of a spreadsheet binding](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-bindings-binding-id-versions) — `POST /api/v2/metrics/client/bindings/{bindingId}/versions`
* [Cancel an operation](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-operations-operation-id-cancel) — `POST /api/v2/metrics/client/operations/{operationId}/cancel`
* [Read operation results](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-operations-operation-id-results) — `GET /api/v2/metrics/client/operations/{operationId}/results`
* [Read query insights](/docs/api-reference/spreadsheet-clients/get-v2-metrics-client-queries-query-id-insights) — `GET /api/v2/metrics/client/queries/{queryId}/insights`
* [Create a version of a query](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-queries-query-id-versions) — `POST /api/v2/metrics/client/queries/{queryId}/versions`
* [Transfer spreadsheet resource ownership](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-schedules-schedule-id-ownership) — `POST /api/v2/metrics/client/schedules/{scheduleId}/ownership`
* [Update the status of a refresh schedule](/docs/api-reference/spreadsheet-clients/put-v2-metrics-client-schedules-schedule-id-status) — `PUT /api/v2/metrics/client/schedules/{scheduleId}/status`
* [Create a version of a refresh schedule](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-schedules-schedule-id-versions) — `POST /api/v2/metrics/client/schedules/{scheduleId}/versions`
* [Record a spreadsheet write checkpoint](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-writes-write-claim-id-checkpoints) — `POST /api/v2/metrics/client/writes/{writeClaimId}/checkpoints`
* [Commit a spreadsheet write](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-writes-write-claim-id-commit) — `POST /api/v2/metrics/client/writes/{writeClaimId}/commit`
* [Publish a version of a spreadsheet binding](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-bindings-binding-id-versions-version-id-publish) — `POST /api/v2/metrics/client/bindings/{bindingId}/versions/{versionId}/publish`
* [Publish a version of a query](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-queries-query-id-versions-version-id-publish) — `POST /api/v2/metrics/client/queries/{queryId}/versions/{versionId}/publish`
* [Publish a version of a refresh schedule](/docs/api-reference/spreadsheet-clients/post-v2-metrics-client-schedules-schedule-id-versions-version-id-publish) — `POST /api/v2/metrics/client/schedules/{scheduleId}/versions/{versionId}/publish`

[Download the complete OpenAPI specification](/docs/openapi.json) for client generation and schema validation.