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

​

Endpoints

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