## Response


A single response from an update.

| JSON representation |
|---|
| ``` { "addNamedRange": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddNamedRangeResponse`) }, "addSheet": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddSheetResponse`) }, "addFilterView": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddFilterViewResponse`) }, "duplicateFilterView": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DuplicateFilterViewResponse`) }, "duplicateSheet": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DuplicateSheetResponse`) }, "findReplace": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#FindReplaceResponse`) }, "updateEmbeddedObjectPosition": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#UpdateEmbeddedObjectPositionResponse`) }, "updateConditionalFormatRule": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#UpdateConditionalFormatRuleResponse`) }, "deleteConditionalFormatRule": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DeleteConditionalFormatRuleResponse`) }, "addProtectedRange": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddProtectedRangeResponse`) }, "addChart": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddChartResponse`) }, "addBanding": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddBandingResponse`) }, "createDeveloperMetadata": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#CreateDeveloperMetadataResponse`) }, "updateDeveloperMetadata": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#UpdateDeveloperMetadataResponse`) }, "deleteDeveloperMetadata": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DeleteDeveloperMetadataResponse`) }, "addDimensionGroup": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddDimensionGroupResponse`) }, "deleteDimensionGroup": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DeleteDimensionGroupResponse`) }, "trimWhitespace": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#TrimWhitespaceResponse`) }, "deleteDuplicates": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DeleteDuplicatesResponse`) }, "addSlicer": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddSlicerResponse`) }, "addDataSource": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddDataSourceResponse`) }, "updateDataSource": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#UpdateDataSourceResponse`) }, "refreshDataSource": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#RefreshDataSourceResponse`) }, "cancelDataSourceRefresh": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#CancelDataSourceRefreshResponse`) }, "addTable": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddTableResponse`) }, "insertComment": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#InsertCommentResponse`) }, "addCommentReply": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddCommentReplyResponse`) } } ``` |

| Fields ||
|---|---|
| The kind of reply. May have no fields set if the request had no response. The following is a list of mutually exclusive fields. At most one of the fields will be set in a response: ||
| `addNamedRange` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddNamedRangeResponse`)`` A reply from adding a named range. |
| `addSheet` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddSheetResponse`)`` A reply from adding a sheet. |
| `addFilterView` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddFilterViewResponse`)`` A reply from adding a filter view. |
| `duplicateFilterView` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DuplicateFilterViewResponse`)`` A reply from duplicating a filter view. |
| `duplicateSheet` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DuplicateSheetResponse`)`` A reply from duplicating a sheet. |
| `findReplace` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#FindReplaceResponse`)`` A reply from doing a find/replace. |
| `updateEmbeddedObjectPosition` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#UpdateEmbeddedObjectPositionResponse`)`` A reply from updating an embedded object's position. |
| `updateConditionalFormatRule` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#UpdateConditionalFormatRuleResponse`)`` A reply from updating a conditional format rule. |
| `deleteConditionalFormatRule` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DeleteConditionalFormatRuleResponse`)`` A reply from deleting a conditional format rule. |
| `addProtectedRange` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddProtectedRangeResponse`)`` A reply from adding a protected range. |
| `addChart` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddChartResponse`)`` A reply from adding a chart. |
| `addBanding` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddBandingResponse`)`` A reply from adding a banded range. |
| `createDeveloperMetadata` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#CreateDeveloperMetadataResponse`)`` A reply from creating a developer metadata entry. |
| `updateDeveloperMetadata` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#UpdateDeveloperMetadataResponse`)`` A reply from updating a developer metadata entry. |
| `deleteDeveloperMetadata` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DeleteDeveloperMetadataResponse`)`` A reply from deleting a developer metadata entry. |
| `addDimensionGroup` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddDimensionGroupResponse`)`` A reply from adding a dimension group. |
| `deleteDimensionGroup` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DeleteDimensionGroupResponse`)`` A reply from deleting a dimension group. |
| `trimWhitespace` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#TrimWhitespaceResponse`)`` A reply from trimming whitespace. |
| `deleteDuplicates` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DeleteDuplicatesResponse`)`` A reply from removing rows containing duplicate values. |
| `addSlicer` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddSlicerResponse`)`` A reply from adding a slicer. |
| `addDataSource` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddDataSourceResponse`)`` A reply from adding a data source. |
| `updateDataSource` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#UpdateDataSourceResponse`)`` A reply from updating a data source. |
| `refreshDataSource` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#RefreshDataSourceResponse`)`` A reply from refreshing data source objects. |
| `cancelDataSourceRefresh` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#CancelDataSourceRefreshResponse`)`` A reply from cancelling data source object refreshes. |
| `addTable` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddTableResponse`)`` A reply from adding a table. |
| `insertComment` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#InsertCommentResponse`)`` The result of creating a comment. |
| `addCommentReply` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#AddCommentReplyResponse`)`` The result of creating a reply. |
| End of mutually exclusive fields. ||

## DataSourceObjectReference


Reference to a data source object.

| JSON representation |
|---|
| ``` { "sheetId": string, "chartId": integer, "dataSourceTableAnchorCell": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#GridCoordinate`) }, "dataSourcePivotTableAnchorCell": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#GridCoordinate`) }, "dataSourceFormulaCell": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#GridCoordinate`) } } ``` |

| Fields ||
|---|---|
| The reference type. The following is a list of mutually exclusive fields. At most one of the fields will be set in a response: ||
| `sheetId` | `string` References to a `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#SheetType` sheet. |
| `chartId` | `integer` References to a data source chart. |
| `dataSourceTableAnchorCell` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#GridCoordinate`)`` References to a `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/cells#DataSourceTable` anchored at the cell. |
| `dataSourcePivotTableAnchorCell` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#GridCoordinate`)`` References to a data source `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/pivot-tables#PivotTable` anchored at the cell. |
| `dataSourceFormulaCell` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#GridCoordinate`)`` References to a cell containing `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/cells#DataSourceFormula`. |
| End of mutually exclusive fields. ||

## AddNamedRangeResponse


The result of adding a named range.

| JSON representation |
|---|
| ``` { "namedRange": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#NamedRange`) } } ``` |

| Fields ||
|---|---|
| `namedRange` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#NamedRange`)`` The named range to add. |

## AddSheetResponse


The result of adding a sheet.

| JSON representation |
|---|
| ``` { "properties": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#SheetProperties`) } } ``` |

| Fields ||
|---|---|
| `properties` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#SheetProperties`)`` The properties of the newly added sheet. |

## AddFilterViewResponse


The result of adding a filter view.

| JSON representation |
|---|
| ``` { "filter": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#FilterView`) } } ``` |

| Fields ||
|---|---|
| `filter` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#FilterView`)`` The newly added filter view. |

## DuplicateFilterViewResponse


The result of a filter view being duplicated.

| JSON representation |
|---|
| ``` { "filter": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#FilterView`) } } ``` |

| Fields ||
|---|---|
| `filter` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#FilterView`)`` The newly created filter. |

## DuplicateSheetResponse


The result of duplicating a sheet.

| JSON representation |
|---|
| ``` { "properties": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#SheetProperties`) } } ``` |

| Fields ||
|---|---|
| `properties` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#SheetProperties`)`` The properties of the duplicate sheet. |

## FindReplaceResponse


The result of the find/replace.

| JSON representation |
|---|
| ``` { "valuesChanged": integer, "formulasChanged": integer, "rowsChanged": integer, "sheetsChanged": integer, "occurrencesChanged": integer } ``` |

| Fields ||
|---|---|
| `valuesChanged` | `integer` The number of non-formula cells changed. |
| `formulasChanged` | `integer` The number of formula cells changed. |
| `rowsChanged` | `integer` The number of rows changed. |
| `sheetsChanged` | `integer` The number of sheets changed. |
| `occurrencesChanged` | `integer` The number of occurrences (possibly multiple within a cell) changed. For example, if replacing `"e"` with `"o"` in `"Google Sheets"`, this would be `"3"` because `"Google Sheets"` -\> `"Googlo Shoots"`. |

## UpdateEmbeddedObjectPositionResponse


The result of updating an embedded object's position.

| JSON representation |
|---|
| ``` { "position": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#EmbeddedObjectPosition`) } } ``` |

| Fields ||
|---|---|
| `position` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#EmbeddedObjectPosition`)`` The new position of the embedded object. |

## UpdateConditionalFormatRuleResponse


The result of updating a conditional format rule.

| JSON representation |
|---|
| ``` { "newRule": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#ConditionalFormatRule`) }, "newIndex": integer, "oldRule": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#ConditionalFormatRule`) }, "oldIndex": integer } ``` |

| Fields ||
|---|---|
| `newRule` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#ConditionalFormatRule`)`` The new rule that replaced the old rule (if replacing), or the rule that was moved (if moved) |
| `newIndex` | `integer` The index of the new rule. |
| Information about the prior rule. The following is a list of mutually exclusive fields. At most one of the fields will be set in a response: ||
| `oldRule` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#ConditionalFormatRule`)`` The old (deleted) rule. Not set if a rule was moved (because it is the same as `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#UpdateConditionalFormatRuleResponse.FIELDS.new_rule`). |
| `oldIndex` | `integer` The old index of the rule. Not set if a rule was replaced (because it is the same as `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#UpdateConditionalFormatRuleResponse.FIELDS.new_index`). |
| End of mutually exclusive fields. ||

## DeleteConditionalFormatRuleResponse


The result of deleting a conditional format rule.

| JSON representation |
|---|
| ``` { "rule": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#ConditionalFormatRule`) } } ``` |

| Fields ||
|---|---|
| `rule` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#ConditionalFormatRule`)`` The rule that was deleted. |

## AddProtectedRangeResponse


The result of adding a new protected range.

| JSON representation |
|---|
| ``` { "protectedRange": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#ProtectedRange`) } } ``` |

| Fields ||
|---|---|
| `protectedRange` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#ProtectedRange`)`` The newly added protected range. |

## AddChartResponse


The result of adding a chart to a spreadsheet.

| JSON representation |
|---|
| ``` { "chart": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/charts#EmbeddedChart`) } } ``` |

| Fields ||
|---|---|
| `chart` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/charts#EmbeddedChart`)`` The newly added chart. |

## AddBandingResponse


The result of adding a banded range.

| JSON representation |
|---|
| ``` { "bandedRange": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#BandedRange`) } } ``` |

| Fields ||
|---|---|
| `bandedRange` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#BandedRange`)`` The banded range that was added. |

## CreateDeveloperMetadataResponse


The response from creating developer metadata.

| JSON representation |
|---|
| ``` { "developerMetadata": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.developerMetadata#DeveloperMetadata`) } } ``` |

| Fields ||
|---|---|
| `developerMetadata` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.developerMetadata#DeveloperMetadata`)`` The developer metadata that was created. |

## UpdateDeveloperMetadataResponse


The response from updating developer metadata.

| JSON representation |
|---|
| ``` { "developerMetadata": [ { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.developerMetadata#DeveloperMetadata`) } ] } ``` |

| Fields ||
|---|---|
| `developerMetadata[]` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.developerMetadata#DeveloperMetadata`)`` The updated developer metadata. |

## DeleteDeveloperMetadataResponse


The response from deleting developer metadata.

| JSON representation |
|---|
| ``` { "deletedDeveloperMetadata": [ { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.developerMetadata#DeveloperMetadata`) } ] } ``` |

| Fields ||
|---|---|
| `deletedDeveloperMetadata[]` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.developerMetadata#DeveloperMetadata`)`` The metadata that was deleted. |

## AddDimensionGroupResponse


The result of adding a group.

| JSON representation |
|---|
| ``` { "dimensionGroups": [ { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#DimensionGroup`) } ] } ``` |

| Fields ||
|---|---|
| `dimensionGroups[]` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#DimensionGroup`)`` All groups of a dimension after adding a group to that dimension. |

## DeleteDimensionGroupResponse


The result of deleting a group.

| JSON representation |
|---|
| ``` { "dimensionGroups": [ { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#DimensionGroup`) } ] } ``` |

| Fields ||
|---|---|
| `dimensionGroups[]` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#DimensionGroup`)`` All groups of a dimension after deleting a group from that dimension. |

## TrimWhitespaceResponse


The result of trimming whitespace in cells.

| JSON representation |
|---|
| ``` { "cellsChangedCount": integer } ``` |

| Fields ||
|---|---|
| `cellsChangedCount` | `integer` The number of cells that were trimmed of whitespace. |

## DeleteDuplicatesResponse


The result of removing duplicates in a range.

| JSON representation |
|---|
| ``` { "duplicatesRemovedCount": integer } ``` |

| Fields ||
|---|---|
| `duplicatesRemovedCount` | `integer` The number of duplicate rows removed. |

## AddSlicerResponse


The result of adding a slicer to a spreadsheet.

| JSON representation |
|---|
| ``` { "slicer": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#Slicer`) } } ``` |

| Fields ||
|---|---|
| `slicer` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#Slicer`)`` The newly added slicer. |

## AddDataSourceResponse


The result of adding a data source.

| JSON representation |
|---|
| ``` { "dataSource": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#DataSource`) }, "dataExecutionStatus": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#DataExecutionStatus`) } } ``` |

| Fields ||
|---|---|
| `dataSource` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#DataSource`)`` The data source that was created. |
| `dataExecutionStatus` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#DataExecutionStatus`)`` The data execution status. |

## UpdateDataSourceResponse


The response from updating data source.

| JSON representation |
|---|
| ``` { "dataSource": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#DataSource`) }, "dataExecutionStatus": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#DataExecutionStatus`) } } ``` |

| Fields ||
|---|---|
| `dataSource` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#DataSource`)`` The updated data source. |
| `dataExecutionStatus` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#DataExecutionStatus`)`` The data execution status. |

## RefreshDataSourceResponse


The response from refreshing one or multiple data source objects.

| JSON representation |
|---|
| ``` { "statuses": [ { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#RefreshDataSourceObjectExecutionStatus`) } ] } ``` |

| Fields ||
|---|---|
| `statuses[]` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#RefreshDataSourceObjectExecutionStatus`)`` All the refresh status for the data source object references specified in the request. If `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/request#RefreshDataSourceRequest.FIELDS.is_all` is specified, the field contains only those in failure status. |

## RefreshDataSourceObjectExecutionStatus


The execution status of refreshing one data source object.

| JSON representation |
|---|
| ``` { "reference": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DataSourceObjectReference`) }, "dataExecutionStatus": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#DataExecutionStatus`) } } ``` |

| Fields ||
|---|---|
| `reference` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DataSourceObjectReference`)`` Reference to a data source object being refreshed. |
| `dataExecutionStatus` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#DataExecutionStatus`)`` The data execution status. |

## CancelDataSourceRefreshResponse


The response from cancelling one or multiple data source object refreshes.

| JSON representation |
|---|
| ``` { "statuses": [ { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#CancelDataSourceRefreshStatus`) } ] } ``` |

| Fields ||
|---|---|
| `statuses[]` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#CancelDataSourceRefreshStatus`)`` The cancellation statuses of refreshes of all data source objects specified in the request. If `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/request#CancelDataSourceRefreshRequest.FIELDS.is_all` is specified, the field contains only those in failure status. Refreshing and canceling refresh the same data source object is also not allowed in the same `batchUpdate`. |

## CancelDataSourceRefreshStatus


The status of cancelling a single data source object refresh.

| JSON representation |
|---|
| ``` { "reference": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DataSourceObjectReference`) }, "refreshCancellationStatus": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#RefreshCancellationStatus`) } } ``` |

| Fields ||
|---|---|
| `reference` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#DataSourceObjectReference`)`` Reference to the data source object whose refresh is being cancelled. |
| `refreshCancellationStatus` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#RefreshCancellationStatus`)`` The cancellation status. |

## RefreshCancellationStatus


The status of a refresh cancellation.


You can send a
`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/request#CancelDataSourceRefreshRequest`
to explicitly cancel one or multiple data source object refreshes.

| JSON representation |
|---|
| ``` { "state": enum (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#RefreshCancellationState`), "errorCode": enum (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#RefreshCancellationErrorCode`) } ``` |

| Fields ||
|---|---|
| `state` | ``enum (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#RefreshCancellationState`)`` The state of a call to cancel a refresh in Sheets. |
| `errorCode` | ``enum (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/response#RefreshCancellationErrorCode`)`` The error code. |

## RefreshCancellationState


An enumeration of refresh cancellation states.

| Enums ||
|---|---|
| `REFRESH_CANCELLATION_STATE_UNSPECIFIED` | Default value, do not use. |
| `CANCEL_SUCCEEDED` | The API call to Sheets to cancel a refresh has succeeded. This does not mean that the cancel happened successfully, but that the call has been made successfully. |
| `CANCEL_FAILED` | The API call to Sheets to cancel a refresh has failed. |

## RefreshCancellationErrorCode


An enumeration of the refresh cancellation error codes.

| Enums ||
|---|---|
| `REFRESH_CANCELLATION_ERROR_CODE_UNSPECIFIED` | Default value, do not use. |
| `EXECUTION_NOT_FOUND` | Execution to be cancelled not found in the query engine or in Sheets. |
| `CANCEL_PERMISSION_DENIED` | The user does not have permission to cancel the query. |
| `QUERY_EXECUTION_COMPLETED` | The query execution has already completed and thus could not be cancelled. |
| `CONCURRENT_CANCELLATION` | There is already another cancellation in process. |
| `CANCEL_OTHER_ERROR` | All other errors. |

## AddTableResponse


The result of adding a table.

| JSON representation |
|---|
| ``` { "table": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#Table`) } } ``` |

| Fields ||
|---|---|
| `table` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#Table`)`` Output only. The table that was added. |

## InsertCommentResponse


The result of creating a comment.

| JSON representation |
|---|
| ``` { "commentThread": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#CommentThread`) } } ``` |

| Fields ||
|---|---|
| `commentThread` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#CommentThread`)`` The newly-inserted comment thread. |

## AddCommentReplyResponse


The result of creating a reply.

| JSON representation |
|---|
| ``` { "post": { object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#Post`) } } ``` |

| Fields ||
|---|---|
| `post` | ``object (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#Post`)`` The newly-inserted reply `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets#Post`. |