Responses

{

  // Union field kind can be only one of the following:
  "addNamedRange": {
    object (AddNamedRangeResponse)
  },
  "addSheet": {
    object (AddSheetResponse)
  },
  "addFilterView": {
    object (AddFilterViewResponse)
  },
  "duplicateFilterView": {
    object (DuplicateFilterViewResponse)
  },
  "duplicateSheet": {
    object (DuplicateSheetResponse)
  },
  "findReplace": {
    object (FindReplaceResponse)
  },
  "updateEmbeddedObjectPosition": {
    object (UpdateEmbeddedObjectPositionResponse)
  },
  "updateConditionalFormatRule": {
    object (UpdateConditionalFormatRuleResponse)
  },
  "deleteConditionalFormatRule": {
    object (DeleteConditionalFormatRuleResponse)
  },
  "addProtectedRange": {
    object (AddProtectedRangeResponse)
  },
  "addChart": {
    object (AddChartResponse)
  },
  "addBanding": {
    object (AddBandingResponse)
  },
  "createDeveloperMetadata": {
    object (CreateDeveloperMetadataResponse)
  },
  "updateDeveloperMetadata": {
    object (UpdateDeveloperMetadataResponse)
  },
  "deleteDeveloperMetadata": {
    object (DeleteDeveloperMetadataResponse)
  },
  "addDimensionGroup": {
    object (AddDimensionGroupResponse)
  },
  "deleteDimensionGroup": {
    object (DeleteDimensionGroupResponse)
  },
  "trimWhitespace": {
    object (TrimWhitespaceResponse)
  },
  "deleteDuplicates": {
    object (DeleteDuplicatesResponse)
  },
  "addSlicer": {
    object (AddSlicerResponse)
  },
  "addDataSource": {
    object (AddDataSourceResponse)
  },
  "updateDataSource": {
    object (UpdateDataSourceResponse)
  },
  "refreshDataSource": {
    object (RefreshDataSourceResponse)
  },
  "cancelDataSourceRefresh": {
    object (CancelDataSourceRefreshResponse)
  }
  // End of list of possible types for union field kind.
}

object (AddNamedRangeResponse)

A reply from adding a named range.

object (AddSheetResponse)

A reply from adding a sheet.

object (AddFilterViewResponse)

A reply from adding a filter view.

object (DuplicateFilterViewResponse)

A reply from duplicating a filter view.

object (DuplicateSheetResponse)

A reply from duplicating a sheet.

object (FindReplaceResponse)

A reply from doing a find/replace.

object (UpdateEmbeddedObjectPositionResponse)

A reply from updating an embedded object's position.

object (UpdateConditionalFormatRuleResponse)

A reply from updating a conditional format rule.

object (DeleteConditionalFormatRuleResponse)

A reply from deleting a conditional format rule.

object (AddProtectedRangeResponse)

A reply from adding a protected range.

object (AddChartResponse)

A reply from adding a chart.

object (AddBandingResponse)

A reply from adding a banded range.

object (CreateDeveloperMetadataResponse)

A reply from creating a developer metadata entry.

object (UpdateDeveloperMetadataResponse)

A reply from updating a developer metadata entry.

object (DeleteDeveloperMetadataResponse)

A reply from deleting a developer metadata entry.

object (AddDimensionGroupResponse)

A reply from adding a dimension group.

object (DeleteDimensionGroupResponse)

A reply from deleting a dimension group.

object (TrimWhitespaceResponse)

A reply from trimming whitespace.

object (DeleteDuplicatesResponse)

A reply from removing rows containing duplicate values.

object (AddSlicerResponse)

A reply from adding a slicer.

object (AddDataSourceResponse)

A reply from adding a data source.

object (UpdateDataSourceResponse)

A reply from updating a data source.

object (RefreshDataSourceResponse)

A reply from refreshing data source objects.

object (CancelDataSourceRefreshResponse)

A reply from cancelling data source object refreshes.

{

  // Union field value can be only one of the following:
  "sheetId": string,
  "chartId": integer,
  "dataSourceTableAnchorCell": {
    object (GridCoordinate)
  },
  "dataSourcePivotTableAnchorCell": {
    object (GridCoordinate)
  },
  "dataSourceFormulaCell": {
    object (GridCoordinate)
  }
  // End of list of possible types for union field value.
}

string

References to a DATA_SOURCE sheet.

integer

References to a data source chart.

object (GridCoordinate)

References to a DataSourceTable anchored at the cell.

object (GridCoordinate)

References to a data source PivotTable anchored at the cell.

object (GridCoordinate)

References to a cell containing DataSourceFormula.

{
  "namedRange": {
    object (NamedRange)
  }
}

object (NamedRange)

The named range to add.

{
  "properties": {
    object (SheetProperties)
  }
}

object (SheetProperties)

The properties of the newly added sheet.

{
  "filter": {
    object (FilterView)
  }
}

object (FilterView)

The newly added filter view.

{
  "filter": {
    object (FilterView)
  }
}

object (FilterView)

The newly created filter.

{
  "properties": {
    object (SheetProperties)
  }
}

object (SheetProperties)

The properties of the duplicate sheet.

{
  "valuesChanged": integer,
  "formulasChanged": integer,
  "rowsChanged": integer,
  "sheetsChanged": integer,
  "occurrencesChanged": integer
}

integer

The number of non-formula cells changed.

integer

The number of formula cells changed.

integer

The number of rows changed.

integer

The number of sheets changed.

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".

{
  "position": {
    object (EmbeddedObjectPosition)
  }
}

object (EmbeddedObjectPosition)

The new position of the embedded object.

{
  "newRule": {
    object (ConditionalFormatRule)
  },
  "newIndex": integer,

  // Union field old_info can be only one of the following:
  "oldRule": {
    object (ConditionalFormatRule)
  },
  "oldIndex": integer
  // End of list of possible types for union field old_info.
}

object (ConditionalFormatRule)

The new rule that replaced the old rule (if replacing), or the rule that was moved (if moved)

integer

The index of the new rule.

object (ConditionalFormatRule)

The old (deleted) rule. Not set if a rule was moved (because it is the same as newRule).

integer

The old index of the rule. Not set if a rule was replaced (because it is the same as newIndex).

{
  "rule": {
    object (ConditionalFormatRule)
  }
}

object (ConditionalFormatRule)

The rule that was deleted.

{
  "protectedRange": {
    object (ProtectedRange)
  }
}

object (ProtectedRange)

The newly added protected range.

{
  "chart": {
    object (EmbeddedChart)
  }
}

object (EmbeddedChart)

The newly added chart.

{
  "bandedRange": {
    object (BandedRange)
  }
}

object (BandedRange)

The banded range that was added.

{
  "developerMetadata": {
    object (DeveloperMetadata)
  }
}

object (DeveloperMetadata)

The developer metadata that was created.

{
  "developerMetadata": [
    {
      object (DeveloperMetadata)
    }
  ]
}

object (DeveloperMetadata)

The updated developer metadata.

{
  "deletedDeveloperMetadata": [
    {
      object (DeveloperMetadata)
    }
  ]
}

object (DeveloperMetadata)

The metadata that was deleted.

{
  "dimensionGroups": [
    {
      object (DimensionGroup)
    }
  ]
}

object (DimensionGroup)

All groups of a dimension after adding a group to that dimension.

{
  "dimensionGroups": [
    {
      object (DimensionGroup)
    }
  ]
}

object (DimensionGroup)

All groups of a dimension after deleting a group from that dimension.

{
  "cellsChangedCount": integer
}

integer

The number of cells that were trimmed of whitespace.

{
  "duplicatesRemovedCount": integer
}

integer

The number of duplicate rows removed.

{
  "slicer": {
    object (Slicer)
  }
}

object (Slicer)

The newly added slicer.

{
  "dataSource": {
    object (DataSource)
  },
  "dataExecutionStatus": {
    object (DataExecutionStatus)
  }
}

object (DataSource)

The data source that was created.

object (DataExecutionStatus)

The data execution status.

{
  "dataSource": {
    object (DataSource)
  },
  "dataExecutionStatus": {
    object (DataExecutionStatus)
  }
}

object (DataSource)

The updated data source.

object (DataExecutionStatus)

The data execution status.

{
  "statuses": [
    {
      object (RefreshDataSourceObjectExecutionStatus)
    }
  ]
}

object (RefreshDataSourceObjectExecutionStatus)

All the refresh status for the data source object references specified in the request. If isAll is specified, the field contains only those in failure status.

{
  "reference": {
    object (DataSourceObjectReference)
  },
  "dataExecutionStatus": {
    object (DataExecutionStatus)
  }
}

object (DataSourceObjectReference)

Reference to a data source object being refreshed.

object (DataExecutionStatus)

The data execution status.

{
  "statuses": [
    {
      object (CancelDataSourceRefreshStatus)
    }
  ]
}

object (CancelDataSourceRefreshStatus)

The cancellation statuses of refreshes of all data source objects specified in the request. If isAll 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.

{
  "reference": {
    object (DataSourceObjectReference)
  },
  "refreshCancellationStatus": {
    object (RefreshCancellationStatus)
  }
}

object (DataSourceObjectReference)

Reference to the data source object whose refresh is being cancelled.

object (RefreshCancellationStatus)

The cancellation status.

{
  "state": enum (RefreshCancellationState),
  "errorCode": enum (RefreshCancellationErrorCode)
}

enum (RefreshCancellationState)

The state of a call to cancel a refresh in Sheets.

enum (RefreshCancellationErrorCode)

The error code.