Google Sheets API
  1. Schemas
Google Sheets API
  • spreadsheets
    • /v4/spreadsheets
    • /v4/spreadsheets/{spreadsheetId}
    • /v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}
    • /v4/spreadsheets/{spreadsheetId}/developerMetadata:search
    • /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo
    • /v4/spreadsheets/{spreadsheetId}/values/{range}
    • /v4/spreadsheets/{spreadsheetId}/values/{range}
    • /v4/spreadsheets/{spreadsheetId}/values/{range}:append
    • /v4/spreadsheets/{spreadsheetId}/values/{range}:clear
    • /v4/spreadsheets/{spreadsheetId}/values:batchClear
    • /v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter
    • /v4/spreadsheets/{spreadsheetId}/values:batchGet
    • /v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter
    • /v4/spreadsheets/{spreadsheetId}/values:batchUpdate
    • /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter
    • /v4/spreadsheets/{spreadsheetId}:batchUpdate
    • /v4/spreadsheets/{spreadsheetId}:getByDataFilter
  • Schemas
    • Schemas
      • AddBandingRequest
      • AddBandingResponse
      • AddChartRequest
      • AddChartResponse
      • AddConditionalFormatRuleRequest
      • AddDataSourceRequest
      • AddDataSourceResponse
      • AddDimensionGroupRequest
      • AddDimensionGroupResponse
      • AddFilterViewRequest
      • AddFilterViewResponse
      • AddNamedRangeRequest
      • AddNamedRangeResponse
      • AddProtectedRangeRequest
      • AddProtectedRangeResponse
      • AddSheetRequest
      • AddSheetResponse
      • AddSlicerRequest
      • AddSlicerResponse
      • AppendCellsRequest
      • AppendDimensionRequest
      • AppendValuesResponse
      • AutoFillRequest
      • AutoResizeDimensionsRequest
      • BandedRange
      • BandingProperties
      • BaselineValueFormat
      • BasicChartAxis
      • BasicChartDomain
      • BasicChartSeries
      • BasicChartSpec
      • BasicFilter
      • BasicSeriesDataPointStyleOverride
      • BatchClearValuesByDataFilterRequest
      • BatchClearValuesByDataFilterResponse
      • BatchClearValuesRequest
      • BatchClearValuesResponse
      • BatchGetValuesByDataFilterRequest
      • BatchGetValuesByDataFilterResponse
      • BatchGetValuesResponse
      • BatchUpdateSpreadsheetRequest
      • BatchUpdateSpreadsheetResponse
      • BatchUpdateValuesByDataFilterRequest
      • BatchUpdateValuesByDataFilterResponse
      • BatchUpdateValuesRequest
      • BatchUpdateValuesResponse
      • BigQueryDataSourceSpec
      • BigQueryQuerySpec
      • BigQueryTableSpec
      • BooleanCondition
      • BooleanRule
      • Border
      • Borders
      • BubbleChartSpec
      • CandlestickChartSpec
      • CandlestickData
      • CandlestickDomain
      • CandlestickSeries
      • CellData
      • CellFormat
      • ChartAxisViewWindowOptions
      • ChartCustomNumberFormatOptions
      • ChartData
      • ChartDateTimeRule
      • ChartGroupRule
      • ChartHistogramRule
      • ChartSourceRange
      • ChartSpec
      • ClearBasicFilterRequest
      • ClearValuesRequest
      • ClearValuesResponse
      • Color
      • ColorStyle
      • ConditionValue
      • ConditionalFormatRule
      • CopyPasteRequest
      • CopySheetToAnotherSpreadsheetRequest
      • CreateDeveloperMetadataRequest
      • CreateDeveloperMetadataResponse
      • CutPasteRequest
      • DataExecutionStatus
      • DataFilter
      • DataFilterValueRange
      • DataLabel
      • DataSource
      • DataSourceChartProperties
      • DataSourceColumn
      • DataSourceColumnReference
      • DataSourceFormula
      • DataSourceObjectReference
      • DataSourceObjectReferences
      • DataSourceParameter
      • DataSourceRefreshDailySchedule
      • DataSourceRefreshMonthlySchedule
      • DataSourceRefreshSchedule
      • DataSourceRefreshWeeklySchedule
      • DataSourceSheetDimensionRange
      • DataSourceSheetProperties
      • DataSourceSpec
      • DataSourceTable
      • DataValidationRule
      • DateTimeRule
      • DeleteBandingRequest
      • DeleteConditionalFormatRuleRequest
      • DeleteConditionalFormatRuleResponse
      • DeleteDataSourceRequest
      • DeleteDeveloperMetadataRequest
      • DeleteDeveloperMetadataResponse
      • DeleteDimensionGroupRequest
      • DeleteDimensionGroupResponse
      • DeleteDimensionRequest
      • DeleteDuplicatesRequest
      • DeleteDuplicatesResponse
      • DeleteEmbeddedObjectRequest
      • DeleteFilterViewRequest
      • DeleteNamedRangeRequest
      • DeleteProtectedRangeRequest
      • DeleteRangeRequest
      • DeleteSheetRequest
      • DeveloperMetadata
      • DeveloperMetadataLocation
      • DeveloperMetadataLookup
      • DimensionGroup
      • DimensionProperties
      • DimensionRange
      • DuplicateFilterViewRequest
      • DuplicateFilterViewResponse
      • DuplicateSheetRequest
      • DuplicateSheetResponse
      • Editors
      • EmbeddedChart
      • EmbeddedObjectBorder
      • EmbeddedObjectPosition
      • ErrorValue
      • ExtendedValue
      • FilterCriteria
      • FilterSpec
      • FilterView
      • FindReplaceRequest
      • FindReplaceResponse
      • GetSpreadsheetByDataFilterRequest
      • GradientRule
      • GridCoordinate
      • GridData
      • GridProperties
      • GridRange
      • HistogramChartSpec
      • HistogramRule
      • HistogramSeries
      • InsertDimensionRequest
      • InsertRangeRequest
      • InterpolationPoint
      • Interval
      • IterativeCalculationSettings
      • KeyValueFormat
      • LineStyle
      • Link
      • ManualRule
      • ManualRuleGroup
      • MatchedDeveloperMetadata
      • MatchedValueRange
      • MergeCellsRequest
      • MoveDimensionRequest
      • NamedRange
      • NumberFormat
      • OrgChartSpec
      • OverlayPosition
      • Padding
      • PasteDataRequest
      • PieChartSpec
      • PivotFilterCriteria
      • PivotFilterSpec
      • PivotGroup
      • PivotGroupLimit
      • PivotGroupRule
      • PivotGroupSortValueBucket
      • PivotGroupValueMetadata
      • PivotTable
      • PivotValue
      • PointStyle
      • ProtectedRange
      • RandomizeRangeRequest
      • RefreshDataSourceObjectExecutionStatus
      • RefreshDataSourceRequest
      • RefreshDataSourceResponse
      • RepeatCellRequest
      • Request
      • Response
      • RowData
      • ScorecardChartSpec
      • SearchDeveloperMetadataRequest
      • SearchDeveloperMetadataResponse
      • SetBasicFilterRequest
      • SetDataValidationRequest
      • Sheet
      • SheetProperties
      • Slicer
      • SlicerSpec
      • SortRangeRequest
      • SortSpec
      • SourceAndDestination
      • Spreadsheet
      • SpreadsheetProperties
      • SpreadsheetTheme
      • TextFormat
      • TextFormatRun
      • TextPosition
      • TextRotation
      • TextToColumnsRequest
      • ThemeColorPair
      • TimeOfDay
      • TreemapChartColorScale
      • TreemapChartSpec
      • TrimWhitespaceRequest
      • TrimWhitespaceResponse
      • UnmergeCellsRequest
      • UpdateBandingRequest
      • UpdateBordersRequest
      • UpdateCellsRequest
      • UpdateChartSpecRequest
      • UpdateConditionalFormatRuleRequest
      • UpdateConditionalFormatRuleResponse
      • UpdateDataSourceRequest
      • UpdateDataSourceResponse
      • UpdateDeveloperMetadataRequest
      • UpdateDeveloperMetadataResponse
      • UpdateDimensionGroupRequest
      • UpdateDimensionPropertiesRequest
      • UpdateEmbeddedObjectBorderRequest
      • UpdateEmbeddedObjectPositionRequest
      • UpdateEmbeddedObjectPositionResponse
      • UpdateFilterViewRequest
      • UpdateNamedRangeRequest
      • UpdateProtectedRangeRequest
      • UpdateSheetPropertiesRequest
      • UpdateSlicerSpecRequest
      • UpdateSpreadsheetPropertiesRequest
      • UpdateValuesByDataFilterResponse
      • UpdateValuesResponse
      • ValueRange
      • WaterfallChartColumnStyle
      • WaterfallChartCustomSubtotal
      • WaterfallChartDomain
      • WaterfallChartSeries
      • WaterfallChartSpec
  1. Schemas

DateTimeRule

Allows you to organize the date-time values in a source data column into buckets based on selected parts of their date or time values. For example, consider a pivot table showing sales transactions by date: +----------+--------------+ | Date | SUM of Sales | +----------+--------------+ | 1/1/2017 | 621.14∣∣2/3/2017∣708.84 | | 5/8/2017 | $326.84 | ... +----------+--------------+ Applying a date-time group rule with a DateTimeRuleType of YEAR_MONTH results in the following pivot table. +---

{
    "type": "DATE_TIME_RULE_TYPE_UNSPECIFIED"
}
Built with