Sign in

v1

latestOpenAPI 3.0.32026-08-061874701.5 MB
crossSheetReferences

Create cross-sheet references

Adds a cross-sheet reference between two sheets and defines the data range for formulas. Each distinct data range requires a new cross-sheet reference.

post/sheets/{sheetId}/crosssheetreferences

Headers

Content-Typestring

Required for POST and PUT requests. Defines the structure for the request body.

Request body

OR
OR

Response

Result object containing a CrossSheetReference object, corresponding to what was specified in the request.

message'PARTIAL_SUCCESS' | 'SUCCESS'

Message that indicates the outcome of the request. (One of SUCCESS or PARTIAL_SUCCESS.)

resultCode0 | 3
  • '0' Success
  • '3' Partial Success of Bulk Operation
versionnumber nullable

New version of the sheet. Applicable only for operations which update sheet data.

Example response

{
  "message": "SUCCESS"
}