addedInput schema / properties / request_body
Added value: +{
+ "description": "Request body of type BatchUpdateSpreadsheetRequest: pass it via `params` (merged into the built body) or whole via `body_file`.",
+ "properties": {
+ "commentsViewMode": {
+ "enum": [
+ "COMMENTS_VIEW_MODE_UNSPECIFIED",
+ "COMMENTS_VIEW_MODE_DEFAULT_FOR_CURRENT_ACCESS",
+ "COMMENTS_VIEW_MODE_OMITTED",
+ "COMMENTS_VIEW_MODE_INCLUDED"
+ ],
+ "type": "string"
+ },
+ "includeSpreadsheetInResponse": {
+ "type": "boolean"
+ },
+ "requests": {
+ "items": {
+ "properties": {
+ "addBanding": {
+ "properties": {
+ "bandedRange": {
+ "properties": {
+ "bandedRangeId": {
+ "type": "integer"
+ },
+ "bandedRangeReference": {
+ "type": "string"
+ },
+ "columnProperties": {
+ "type": "object"
+ },
+ "range": {
+ "type": "object"
+ },
+ "rowProperties": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addChart": {
+ "properties": {
+ "chart": {
+ "properties": {
+ "border": {
+ "type": "object"
+ },
+ "chartId": {
+ "type": "integer"
+ },
+ "position": {
+ "type": "object"
+ },
+ "spec": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addCommentReply": {
+ "properties": {
+ "commentId": {
+ "type": "string"
+ },
+ "post": {
+ "properties": {
+ "assigneeEmail": {
+ "type": "string"
+ },
+ "author": {
+ "type": "object"
+ },
+ "commentAction": {
+ "enum": [
+ "COMMENT_ACTION_TYPE_UNSPECIFIED",
+ "NO_COMMENT_ACTION_CHANGE",
+ "RESOLVE",
+ "REOPEN"
+ ],
+ "type": "string"
+ },
+ "content": {
+ "type": "string"
+ },
+ "contentHtml": {
+ "type": "string"
+ },
+ "createTime": {
+ "type": "string"
+ },
+ "deleted": {
+ "type": "boolean"
+ },
+ "fromCopiedSpreadsheet": {
+ "type": "boolean"
+ },
+ "fromImportedSpreadsheet": {
+ "type": "boolean"
+ },
+ "postId": {
+ "type": "string"
+ },
+ "updateTime": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addConditionalFormatRule": {
+ "properties": {
+ "index": {
+ "type": "integer"
+ },
+ "rule": {
+ "properties": {
+ "booleanRule": {
+ "type": "object"
+ },
+ "gradientRule": {
+ "type": "object"
+ },
+ "ranges": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addDataSource": {
+ "properties": {
+ "dataSource": {
+ "properties": {
+ "calculatedColumns": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "dataSourceId": {
+ "type": "string"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "spec": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addDimensionGroup": {
+ "properties": {
+ "range": {
+ "properties": {
+ "dimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ },
+ "endIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addFilterView": {
+ "properties": {
+ "filter": {
+ "properties": {
+ "criteria": {
+ "type": "object"
+ },
+ "filterSpecs": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "filterViewId": {
+ "type": "integer"
+ },
+ "namedRangeId": {
+ "type": "string"
+ },
+ "range": {
+ "type": "object"
+ },
+ "sortSpecs": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "tableId": {
+ "type": "string"
+ },
+ "title": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addNamedRange": {
+ "properties": {
+ "namedRange": {
+ "properties": {
+ "name": {
+ "type": "string"
+ },
+ "namedRangeId": {
+ "type": "string"
+ },
+ "range": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addProtectedRange": {
+ "properties": {
+ "protectedRange": {
+ "properties": {
+ "description": {
+ "type": "string"
+ },
+ "editors": {
+ "type": "object"
+ },
+ "namedRangeId": {
+ "type": "string"
+ },
+ "protectedRangeId": {
+ "type": "integer"
+ },
+ "range": {
+ "type": "object"
+ },
+ "requestingUserCanEdit": {
+ "type": "boolean"
+ },
+ "tableId": {
+ "type": "string"
+ },
+ "unprotectedRanges": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "warningOnly": {
+ "type": "boolean"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addSheet": {
+ "properties": {
+ "properties": {
+ "properties": {
+ "dataSourceSheetProperties": {
+ "type": "object"
+ },
+ "gridProperties": {
+ "type": "object"
+ },
+ "hidden": {
+ "type": "boolean"
+ },
+ "index": {
+ "type": "integer"
+ },
+ "rightToLeft": {
+ "type": "boolean"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "sheetType": {
+ "enum": [
+ "SHEET_TYPE_UNSPECIFIED",
+ "GRID",
+ "OBJECT",
+ "DATA_SOURCE"
+ ],
+ "type": "string"
+ },
+ "tabColor": {
+ "type": "object"
+ },
+ "tabColorStyle": {
+ "type": "object"
+ },
+ "title": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addSlicer": {
+ "properties": {
+ "slicer": {
+ "properties": {
+ "position": {
+ "type": "object"
+ },
+ "slicerId": {
+ "type": "integer"
+ },
+ "spec": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "addTable": {
+ "properties": {
+ "table": {
+ "properties": {
+ "columnProperties": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "name": {
+ "type": "string"
+ },
+ "range": {
+ "type": "object"
+ },
+ "rowsProperties": {
+ "type": "object"
+ },
+ "tableId": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "appendCells": {
+ "properties": {
+ "fields": {
+ "type": "string"
+ },
+ "rows": {
+ "items": {
+ "properties": {
+ "values": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "tableId": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "appendDimension": {
+ "properties": {
+ "dimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ },
+ "length": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "autoFill": {
+ "properties": {
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "sourceAndDestination": {
+ "properties": {
+ "dimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ },
+ "fillLength": {
+ "type": "integer"
+ },
+ "source": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "useAlternateSeries": {
+ "type": "boolean"
+ }
+ },
+ "type": "object"
+ },
+ "autoResizeDimensions": {
+ "properties": {
+ "dataSourceSheetDimensions": {
+ "properties": {
+ "columnReferences": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "dimensions": {
+ "properties": {
+ "dimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ },
+ "endIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "cancelDataSourceRefresh": {
+ "properties": {
+ "dataSourceId": {
+ "type": "string"
+ },
+ "isAll": {
+ "type": "boolean"
+ },
+ "references": {
+ "properties": {
+ "references": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "clearBasicFilter": {
+ "properties": {
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "copyPaste": {
+ "properties": {
+ "destination": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "pasteOrientation": {
+ "enum": [
+ "NORMAL",
+ "TRANSPOSE"
+ ],
+ "type": "string"
+ },
+ "pasteType": {
+ "enum": [
+ "PASTE_NORMAL",
+ "PASTE_VALUES",
+ "PASTE_FORMAT",
+ "PASTE_NO_BORDERS",
+ "PASTE_FORMULA",
+ "PASTE_DATA_VALIDATION",
+ "PASTE_CONDITIONAL_FORMATTING"
+ ],
+ "type": "string"
+ },
+ "source": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "createDeveloperMetadata": {
+ "properties": {
+ "developerMetadata": {
+ "properties": {
+ "location": {
+ "type": "object"
+ },
+ "metadataId": {
+ "type": "integer"
+ },
+ "metadataKey": {
+ "type": "string"
+ },
+ "metadataValue": {
+ "type": "string"
+ },
+ "visibility": {
+ "enum": [
+ "DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED",
+ "DOCUMENT",
+ "PROJECT"
+ ],
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "cutPaste": {
+ "properties": {
+ "destination": {
+ "properties": {
+ "columnIndex": {
+ "type": "integer"
+ },
+ "rowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "pasteType": {
+ "enum": [
+ "PASTE_NORMAL",
+ "PASTE_VALUES",
+ "PASTE_FORMAT",
+ "PASTE_NO_BORDERS",
+ "PASTE_FORMULA",
+ "PASTE_DATA_VALIDATION",
+ "PASTE_CONDITIONAL_FORMATTING"
+ ],
+ "type": "string"
+ },
+ "source": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "deleteBanding": {
+ "properties": {
+ "bandedRangeId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "deleteComment": {
+ "properties": {
+ "commentId": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "deleteCommentReply": {
+ "properties": {
+ "commentId": {
+ "type": "string"
+ },
+ "postId": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "deleteConditionalFormatRule": {
+ "properties": {
+ "index": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "deleteDataSource": {
+ "properties": {
+ "dataSourceId": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "deleteDeveloperMetadata": {
+ "properties": {
+ "dataFilter": {
+ "properties": {
+ "a1Range": {
+ "type": "string"
+ },
+ "developerMetadataLookup": {
+ "type": "object"
+ },
+ "gridRange": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "deleteDimension": {
+ "properties": {
+ "range": {
+ "properties": {
+ "dimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ },
+ "endIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "deleteDimensionGroup": {
+ "properties": {
+ "range": {
+ "properties": {
+ "dimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ },
+ "endIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "deleteDuplicates": {
+ "properties": {
+ "comparisonColumns": {
+ "items": {
+ "properties": {
+ "dimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ },
+ "endIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "deleteEmbeddedObject": {
+ "properties": {
+ "objectId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "deleteFilterView": {
+ "properties": {
+ "filterId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "deleteNamedRange": {
+ "properties": {
+ "namedRangeId": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "deleteProtectedRange": {
+ "properties": {
+ "protectedRangeId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "deleteRange": {
+ "properties": {
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "shiftDimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "deleteSheet": {
+ "properties": {
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "deleteTable": {
+ "properties": {
+ "tableId": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "duplicateFilterView": {
+ "properties": {
+ "filterId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "duplicateSheet": {
+ "properties": {
+ "insertSheetIndex": {
+ "type": "integer"
+ },
+ "newSheetId": {
+ "type": "integer"
+ },
+ "newSheetName": {
+ "type": "string"
+ },
+ "sourceSheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "findReplace": {
+ "properties": {
+ "allSheets": {
+ "type": "boolean"
+ },
+ "find": {
+ "type": "string"
+ },
+ "includeFormulas": {
+ "type": "boolean"
+ },
+ "matchCase": {
+ "type": "boolean"
+ },
+ "matchEntireCell": {
+ "type": "boolean"
+ },
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "replacement": {
+ "type": "string"
+ },
+ "searchByRegex": {
+ "type": "boolean"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "insertComment": {
+ "properties": {
+ "assigneeEmailAddress": {
+ "type": "string"
+ },
+ "content": {
+ "type": "string"
+ },
+ "coordinate": {
+ "properties": {
+ "columnIndex": {
+ "type": "integer"
+ },
+ "rowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "insertDimension": {
+ "properties": {
+ "inheritFromBefore": {
+ "type": "boolean"
+ },
+ "range": {
+ "properties": {
+ "dimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ },
+ "endIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "insertRange": {
+ "properties": {
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "shiftDimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "mergeCells": {
+ "properties": {
+ "mergeType": {
+ "enum": [
+ "MERGE_ALL",
+ "MERGE_COLUMNS",
+ "MERGE_ROWS"
+ ],
+ "type": "string"
+ },
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "moveDimension": {
+ "properties": {
+ "destinationIndex": {
+ "type": "integer"
+ },
+ "source": {
+ "properties": {
+ "dimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ },
+ "endIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "pasteData": {
+ "properties": {
+ "coordinate": {
+ "properties": {
+ "columnIndex": {
+ "type": "integer"
+ },
+ "rowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "data": {
+ "type": "string"
+ },
+ "delimiter": {
+ "type": "string"
+ },
+ "html": {
+ "type": "boolean"
+ },
+ "type": {
+ "enum": [
+ "PASTE_NORMAL",
+ "PASTE_VALUES",
+ "PASTE_FORMAT",
+ "PASTE_NO_BORDERS",
+ "PASTE_FORMULA",
+ "PASTE_DATA_VALIDATION",
+ "PASTE_CONDITIONAL_FORMATTING"
+ ],
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "randomizeRange": {
+ "properties": {
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "refreshDataSource": {
+ "properties": {
+ "dataSourceId": {
+ "type": "string"
+ },
+ "force": {
+ "type": "boolean"
+ },
+ "isAll": {
+ "type": "boolean"
+ },
+ "references": {
+ "properties": {
+ "references": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "repeatCell": {
+ "properties": {
+ "cell": {
+ "properties": {
+ "chipRuns": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "dataSourceFormula": {
+ "type": "object"
+ },
+ "dataSourceTable": {
+ "type": "object"
+ },
+ "dataValidation": {
+ "type": "object"
+ },
+ "effectiveFormat": {
+ "type": "object"
+ },
+ "effectiveValue": {
+ "type": "object"
+ },
+ "formattedValue": {
+ "type": "string"
+ },
+ "hyperlink": {
+ "type": "string"
+ },
+ "note": {
+ "type": "string"
+ },
+ "pivotTable": {
+ "type": "object"
+ },
+ "textFormatRuns": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "userEnteredFormat": {
+ "type": "object"
+ },
+ "userEnteredValue": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "fields": {
+ "type": "string"
+ },
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "setBasicFilter": {
+ "properties": {
+ "filter": {
+ "properties": {
+ "criteria": {
+ "type": "object"
+ },
+ "filterSpecs": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "range": {
+ "type": "object"
+ },
+ "sortSpecs": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "tableId": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "setDataValidation": {
+ "properties": {
+ "filteredRowsIncluded": {
+ "type": "boolean"
+ },
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "rule": {
+ "properties": {
+ "condition": {
+ "type": "object"
+ },
+ "inputMessage": {
+ "type": "string"
+ },
+ "showCustomUi": {
+ "type": "boolean"
+ },
+ "strict": {
+ "type": "boolean"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "sortRange": {
+ "properties": {
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "sortSpecs": {
+ "items": {
+ "properties": {
+ "backgroundColor": {
+ "type": "object"
+ },
+ "backgroundColorStyle": {
+ "type": "object"
+ },
+ "dataSourceColumnReference": {
+ "type": "object"
+ },
+ "dimensionIndex": {
+ "type": "integer"
+ },
+ "foregroundColor": {
+ "type": "object"
+ },
+ "foregroundColorStyle": {
+ "type": "object"
+ },
+ "sortOrder": {
+ "enum": [
+ "SORT_ORDER_UNSPECIFIED",
+ "ASCENDING",
+ "DESCENDING"
+ ],
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "textToColumns": {
+ "properties": {
+ "delimiter": {
+ "type": "string"
+ },
+ "delimiterType": {
+ "enum": [
+ "DELIMITER_TYPE_UNSPECIFIED",
+ "COMMA",
+ "SEMICOLON",
+ "PERIOD",
+ "SPACE",
+ "CUSTOM",
+ "AUTODETECT"
+ ],
+ "type": "string"
+ },
+ "source": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "trimWhitespace": {
+ "properties": {
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "unmergeCells": {
+ "properties": {
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateBanding": {
+ "properties": {
+ "bandedRange": {
+ "properties": {
+ "bandedRangeId": {
+ "type": "integer"
+ },
+ "bandedRangeReference": {
+ "type": "string"
+ },
+ "columnProperties": {
+ "type": "object"
+ },
+ "range": {
+ "type": "object"
+ },
+ "rowProperties": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "fields": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "updateBorders": {
+ "properties": {
+ "bottom": {
+ "properties": {
+ "color": {
+ "type": "object"
+ },
+ "colorStyle": {
+ "type": "object"
+ },
+ "style": {
+ "enum": [
+ "STYLE_UNSPECIFIED",
+ "DOTTED",
+ "DASHED",
+ "SOLID",
+ "SOLID_MEDIUM",
+ "SOLID_THICK",
+ "NONE",
+ "DOUBLE"
+ ],
+ "type": "string"
+ },
+ "width": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "innerHorizontal": {
+ "properties": {
+ "color": {
+ "type": "object"
+ },
+ "colorStyle": {
+ "type": "object"
+ },
+ "style": {
+ "enum": [
+ "STYLE_UNSPECIFIED",
+ "DOTTED",
+ "DASHED",
+ "SOLID",
+ "SOLID_MEDIUM",
+ "SOLID_THICK",
+ "NONE",
+ "DOUBLE"
+ ],
+ "type": "string"
+ },
+ "width": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "innerVertical": {
+ "properties": {
+ "color": {
+ "type": "object"
+ },
+ "colorStyle": {
+ "type": "object"
+ },
+ "style": {
+ "enum": [
+ "STYLE_UNSPECIFIED",
+ "DOTTED",
+ "DASHED",
+ "SOLID",
+ "SOLID_MEDIUM",
+ "SOLID_THICK",
+ "NONE",
+ "DOUBLE"
+ ],
+ "type": "string"
+ },
+ "width": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "left": {
+ "properties": {
+ "color": {
+ "type": "object"
+ },
+ "colorStyle": {
+ "type": "object"
+ },
+ "style": {
+ "enum": [
+ "STYLE_UNSPECIFIED",
+ "DOTTED",
+ "DASHED",
+ "SOLID",
+ "SOLID_MEDIUM",
+ "SOLID_THICK",
+ "NONE",
+ "DOUBLE"
+ ],
+ "type": "string"
+ },
+ "width": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "right": {
+ "properties": {
+ "color": {
+ "type": "object"
+ },
+ "colorStyle": {
+ "type": "object"
+ },
+ "style": {
+ "enum": [
+ "STYLE_UNSPECIFIED",
+ "DOTTED",
+ "DASHED",
+ "SOLID",
+ "SOLID_MEDIUM",
+ "SOLID_THICK",
+ "NONE",
+ "DOUBLE"
+ ],
+ "type": "string"
+ },
+ "width": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "top": {
+ "properties": {
+ "color": {
+ "type": "object"
+ },
+ "colorStyle": {
+ "type": "object"
+ },
+ "style": {
+ "enum": [
+ "STYLE_UNSPECIFIED",
+ "DOTTED",
+ "DASHED",
+ "SOLID",
+ "SOLID_MEDIUM",
+ "SOLID_THICK",
+ "NONE",
+ "DOUBLE"
+ ],
+ "type": "string"
+ },
+ "width": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateCells": {
+ "properties": {
+ "fields": {
+ "type": "string"
+ },
+ "range": {
+ "properties": {
+ "endColumnIndex": {
+ "type": "integer"
+ },
+ "endRowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startColumnIndex": {
+ "type": "integer"
+ },
+ "startRowIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "rows": {
+ "items": {
+ "properties": {
+ "values": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "start": {
+ "properties": {
+ "columnIndex": {
+ "type": "integer"
+ },
+ "rowIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateChartSpec": {
+ "properties": {
+ "chartId": {
+ "type": "integer"
+ },
+ "spec": {
+ "properties": {
+ "altText": {
+ "type": "string"
+ },
+ "backgroundColor": {
+ "type": "object"
+ },
+ "backgroundColorStyle": {
+ "type": "object"
+ },
+ "basicChart": {
+ "type": "object"
+ },
+ "bubbleChart": {
+ "type": "object"
+ },
+ "candlestickChart": {
+ "type": "object"
+ },
+ "dataSourceChartProperties": {
+ "type": "object"
+ },
+ "filterSpecs": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "fontName": {
+ "type": "string"
+ },
+ "hiddenDimensionStrategy": {
+ "enum": [
+ "CHART_HIDDEN_DIMENSION_STRATEGY_UNSPECIFIED",
+ "SKIP_HIDDEN_ROWS_AND_COLUMNS",
+ "SKIP_HIDDEN_ROWS",
+ "SKIP_HIDDEN_COLUMNS",
+ "SHOW_ALL"
+ ],
+ "type": "string"
+ },
+ "histogramChart": {
+ "type": "object"
+ },
+ "maximized": {
+ "type": "boolean"
+ },
+ "orgChart": {
+ "type": "object"
+ },
+ "pieChart": {
+ "type": "object"
+ },
+ "scorecardChart": {
+ "type": "object"
+ },
+ "sortSpecs": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "subtitle": {
+ "type": "string"
+ },
+ "subtitleTextFormat": {
+ "type": "object"
+ },
+ "subtitleTextPosition": {
+ "type": "object"
+ },
+ "title": {
+ "type": "string"
+ },
+ "titleTextFormat": {
+ "type": "object"
+ },
+ "titleTextPosition": {
+ "type": "object"
+ },
+ "treemapChart": {
+ "type": "object"
+ },
+ "waterfallChart": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateCommentPost": {
+ "properties": {
+ "commentId": {
+ "type": "string"
+ },
+ "content": {
+ "type": "string"
+ },
+ "postId": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "updateConditionalFormatRule": {
+ "properties": {
+ "index": {
+ "type": "integer"
+ },
+ "newIndex": {
+ "type": "integer"
+ },
+ "rule": {
+ "properties": {
+ "booleanRule": {
+ "type": "object"
+ },
+ "gradientRule": {
+ "type": "object"
+ },
+ "ranges": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "updateDataSource": {
+ "properties": {
+ "dataSource": {
+ "properties": {
+ "calculatedColumns": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "dataSourceId": {
+ "type": "string"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "spec": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "fields": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "updateDeveloperMetadata": {
+ "properties": {
+ "dataFilters": {
+ "items": {
+ "properties": {
+ "a1Range": {
+ "type": "string"
+ },
+ "developerMetadataLookup": {
+ "type": "object"
+ },
+ "gridRange": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "developerMetadata": {
+ "properties": {
+ "location": {
+ "type": "object"
+ },
+ "metadataId": {
+ "type": "integer"
+ },
+ "metadataKey": {
+ "type": "string"
+ },
+ "metadataValue": {
+ "type": "string"
+ },
+ "visibility": {
+ "enum": [
+ "DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED",
+ "DOCUMENT",
+ "PROJECT"
+ ],
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "fields": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "updateDimensionGroup": {
+ "properties": {
+ "dimensionGroup": {
+ "properties": {
+ "collapsed": {
+ "type": "boolean"
+ },
+ "depth": {
+ "type": "integer"
+ },
+ "range": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "fields": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "updateDimensionProperties": {
+ "properties": {
+ "dataSourceSheetRange": {
+ "properties": {
+ "columnReferences": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "fields": {
+ "type": "string"
+ },
+ "properties": {
+ "properties": {
+ "dataSourceColumnReference": {
+ "type": "object"
+ },
+ "developerMetadata": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "hiddenByFilter": {
+ "type": "boolean"
+ },
+ "hiddenByUser": {
+ "type": "boolean"
+ },
+ "pixelSize": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "range": {
+ "properties": {
+ "dimension": {
+ "enum": [
+ "DIMENSION_UNSPECIFIED",
+ "ROWS",
+ "COLUMNS"
+ ],
+ "type": "string"
+ },
+ "endIndex": {
+ "type": "integer"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "startIndex": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateEmbeddedObjectBorder": {
+ "properties": {
+ "border": {
+ "properties": {
+ "color": {
+ "type": "object"
+ },
+ "colorStyle": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "fields": {
+ "type": "string"
+ },
+ "objectId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "updateEmbeddedObjectPosition": {
+ "properties": {
+ "fields": {
+ "type": "string"
+ },
+ "newPosition": {
+ "properties": {
+ "newSheet": {
+ "type": "boolean"
+ },
+ "overlayPosition": {
+ "type": "object"
+ },
+ "sheetId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "objectId": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ },
+ "updateFilterView": {
+ "properties": {
+ "fields": {
+ "type": "string"
+ },
+ "filter": {
+ "properties": {
+ "criteria": {
+ "type": "object"
+ },
+ "filterSpecs": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "filterViewId": {
+ "type": "integer"
+ },
+ "namedRangeId": {
+ "type": "string"
+ },
+ "range": {
+ "type": "object"
+ },
+ "sortSpecs": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "tableId": {
+ "type": "string"
+ },
+ "title": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateNamedRange": {
+ "properties": {
+ "fields": {
+ "type": "string"
+ },
+ "namedRange": {
+ "properties": {
+ "name": {
+ "type": "string"
+ },
+ "namedRangeId": {
+ "type": "string"
+ },
+ "range": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateProtectedRange": {
+ "properties": {
+ "fields": {
+ "type": "string"
+ },
+ "protectedRange": {
+ "properties": {
+ "description": {
+ "type": "string"
+ },
+ "editors": {
+ "type": "object"
+ },
+ "namedRangeId": {
+ "type": "string"
+ },
+ "protectedRangeId": {
+ "type": "integer"
+ },
+ "range": {
+ "type": "object"
+ },
+ "requestingUserCanEdit": {
+ "type": "boolean"
+ },
+ "tableId": {
+ "type": "string"
+ },
+ "unprotectedRanges": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "warningOnly": {
+ "type": "boolean"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateSheetProperties": {
+ "properties": {
+ "fields": {
+ "type": "string"
+ },
+ "properties": {
+ "properties": {
+ "dataSourceSheetProperties": {
+ "type": "object"
+ },
+ "gridProperties": {
+ "type": "object"
+ },
+ "hidden": {
+ "type": "boolean"
+ },
+ "index": {
+ "type": "integer"
+ },
+ "rightToLeft": {
+ "type": "boolean"
+ },
+ "sheetId": {
+ "type": "integer"
+ },
+ "sheetType": {
+ "enum": [
+ "SHEET_TYPE_UNSPECIFIED",
+ "GRID",
+ "OBJECT",
+ "DATA_SOURCE"
+ ],
+ "type": "string"
+ },
+ "tabColor": {
+ "type": "object"
+ },
+ "tabColorStyle": {
+ "type": "object"
+ },
+ "title": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateSlicerSpec": {
+ "properties": {
+ "fields": {
+ "type": "string"
+ },
+ "slicerId": {
+ "type": "integer"
+ },
+ "spec": {
+ "properties": {
+ "applyToPivotTables": {
+ "type": "boolean"
+ },
+ "backgroundColor": {
+ "type": "object"
+ },
+ "backgroundColorStyle": {
+ "type": "object"
+ },
+ "columnIndex": {
+ "type": "integer"
+ },
+ "dataRange": {
+ "type": "object"
+ },
+ "filterCriteria": {
+ "type": "object"
+ },
+ "horizontalAlignment": {
+ "enum": [
+ "HORIZONTAL_ALIGN_UNSPECIFIED",
+ "LEFT",
+ "CENTER",
+ "RIGHT"
+ ],
+ "type": "string"
+ },
+ "textFormat": {
+ "type": "object"
+ },
+ "title": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateSpreadsheetProperties": {
+ "properties": {
+ "fields": {
+ "type": "string"
+ },
+ "properties": {
+ "properties": {
+ "autoRecalc": {
+ "enum": [
+ "RECALCULATION_INTERVAL_UNSPECIFIED",
+ "ON_CHANGE",
+ "MINUTE",
+ "HOUR"
+ ],
+ "type": "string"
+ },
+ "defaultFormat": {
+ "type": "object"
+ },
+ "importFunctionsExternalUrlAccessAllowed": {
+ "type": "boolean"
+ },
+ "iterativeCalculationSettings": {
+ "type": "object"
+ },
+ "locale": {
+ "type": "string"
+ },
+ "spreadsheetTheme": {
+ "type": "object"
+ },
+ "timeZone": {
+ "type": "string"
+ },
+ "title": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "updateTable": {
+ "properties": {
+ "fields": {
+ "type": "string"
+ },
+ "table": {
+ "properties": {
+ "columnProperties": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "name": {
+ "type": "string"
+ },
+ "range": {
+ "type": "object"
+ },
+ "rowsProperties": {
+ "type": "object"
+ },
+ "tableId": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "responseIncludeGridData": {
+ "type": "boolean"
+ },
+ "responseRanges": {
+ "items": {
+ "type": "string"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+}
