AppendCellsRequest
{
"fields": "string",
"rows": [
{
"values": [
{
"dataSourceFormula": {
"dataExecutionStatus": {},
"dataSourceId": "string"
},
"dataSourceTable": {
"columnSelectionType": "DATA_SOURCE_TABLE_COLUMN_SELECTION_TYPE_UNSPECIFIED",
"columns": [
{
"name": "string"
}
],
"dataExecutionStatus": {},
"dataSourceId": "string",
"filterSpecs": [
{
"columnIndex": 0,
"dataSourceColumnReference": {
"name": "string"
},
"filterCriteria": {
"condition": {
"type": "CONDITION_TYPE_UNSPECIFIED",
"values": [
{
"relativeDate": "RELATIVE_DATE_UNSPECIFIED",
"userEnteredValue": "string"
}
]
},
"hiddenValues": [
"string"
],
"visibleBackgroundColor": {},
"visibleBackgroundColorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"visibleForegroundColor": {},
"visibleForegroundColorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
}
}
}
],
"rowLimit": 0,
"sortSpecs": [
{
"backgroundColor": {},
"backgroundColorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"dataSourceColumnReference": {
"name": "string"
},
"dimensionIndex": 0,
"foregroundColor": {},
"foregroundColorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"sortOrder": "SORT_ORDER_UNSPECIFIED"
}
]
},
"dataValidation": {
"condition": {
"type": "CONDITION_TYPE_UNSPECIFIED",
"values": [
{
"relativeDate": "RELATIVE_DATE_UNSPECIFIED",
"userEnteredValue": "string"
}
]
},
"inputMessage": "string",
"showCustomUi": true,
"strict": true
},
"effectiveFormat": {
"backgroundColor": {},
"backgroundColorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"borders": {
"bottom": {
"color": {},
"colorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"style": "STYLE_UNSPECIFIED",
"width": 0
},
"left": {
"color": {},
"colorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"style": "STYLE_UNSPECIFIED",
"width": 0
},
"right": {
"color": {},
"colorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"style": "STYLE_UNSPECIFIED",
"width": 0
},
"top": {
"color": {},
"colorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"style": "STYLE_UNSPECIFIED",
"width": 0
}
},
"horizontalAlignment": "HORIZONTAL_ALIGN_UNSPECIFIED",
"hyperlinkDisplayType": "HYPERLINK_DISPLAY_TYPE_UNSPECIFIED",
"numberFormat": {
"pattern": "string",
"type": "NUMBER_FORMAT_TYPE_UNSPECIFIED"
},
"padding": {
"bottom": 0,
"left": 0,
"right": 0,
"top": 0
},
"textDirection": "TEXT_DIRECTION_UNSPECIFIED",
"textFormat": {
"bold": true,
"fontFamily": "string",
"fontSize": 0,
"foregroundColor": {},
"foregroundColorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"italic": true,
"link": {
"uri": "string"
},
"strikethrough": true,
"underline": true
},
"textRotation": {
"angle": 0,
"vertical": true
},
"verticalAlignment": "VERTICAL_ALIGN_UNSPECIFIED",
"wrapStrategy": "WRAP_STRATEGY_UNSPECIFIED"
},
"effectiveValue": {
"boolValue": true,
"errorValue": {
"message": "string",
"type": "ERROR_TYPE_UNSPECIFIED"
},
"formulaValue": "string",
"numberValue": 0,
"stringValue": "string"
},
"formattedValue": "string",
"hyperlink": "string",
"note": "string",
"pivotTable": {
"columns": [
{
"dataSourceColumnReference": {
"name": "string"
},
"groupLimit": {
"applyOrder": 0,
"countLimit": 0
},
"groupRule": {
"dateTimeRule": {},
"histogramRule": {},
"manualRule": {}
},
"label": "string",
"repeatHeadings": true,
"showTotals": true,
"sortOrder": "SORT_ORDER_UNSPECIFIED",
"sourceColumnOffset": 0,
"valueBucket": {
"buckets": [
{
"boolValue": true,
"errorValue": {
"message": "string",
"type": "ERROR_TYPE_UNSPECIFIED"
},
"formulaValue": "string",
"numberValue": 0,
"stringValue": "string"
}
],
"valuesIndex": 0
},
"valueMetadata": [
{
"collapsed": true,
"value": {
"boolValue": true,
"errorValue": {
"message": "string",
"type": "ERROR_TYPE_UNSPECIFIED"
},
"formulaValue": "string",
"numberValue": 0,
"stringValue": "string"
}
}
]
}
],
"criteria": {
"property1": {
"condition": {
"type": "CONDITION_TYPE_UNSPECIFIED",
"values": [
{
"relativeDate": "RELATIVE_DATE_UNSPECIFIED",
"userEnteredValue": "string"
}
]
},
"visibleByDefault": true,
"visibleValues": [
"string"
]
},
"property2": {
"condition": {
"type": "CONDITION_TYPE_UNSPECIFIED",
"values": [
{
"relativeDate": "RELATIVE_DATE_UNSPECIFIED",
"userEnteredValue": "string"
}
]
},
"visibleByDefault": true,
"visibleValues": [
"string"
]
}
},
"dataExecutionStatus": {},
"dataSourceId": "string",
"filterSpecs": [
{
"columnOffsetIndex": 0,
"dataSourceColumnReference": {
"name": "string"
},
"filterCriteria": {
"condition": {
"type": "CONDITION_TYPE_UNSPECIFIED",
"values": [
{
"relativeDate": "RELATIVE_DATE_UNSPECIFIED",
"userEnteredValue": "string"
}
]
},
"visibleByDefault": true,
"visibleValues": [
"string"
]
}
}
],
"rows": [
{
"dataSourceColumnReference": {
"name": "string"
},
"groupLimit": {
"applyOrder": 0,
"countLimit": 0
},
"groupRule": {
"dateTimeRule": {},
"histogramRule": {},
"manualRule": {}
},
"label": "string",
"repeatHeadings": true,
"showTotals": true,
"sortOrder": "SORT_ORDER_UNSPECIFIED",
"sourceColumnOffset": 0,
"valueBucket": {
"buckets": [
{
"boolValue": true,
"errorValue": {
"message": "string",
"type": "ERROR_TYPE_UNSPECIFIED"
},
"formulaValue": "string",
"numberValue": 0,
"stringValue": "string"
}
],
"valuesIndex": 0
},
"valueMetadata": [
{
"collapsed": true,
"value": {
"boolValue": true,
"errorValue": {
"message": "string",
"type": "ERROR_TYPE_UNSPECIFIED"
},
"formulaValue": "string",
"numberValue": 0,
"stringValue": "string"
}
}
]
}
],
"source": {},
"valueLayout": "HORIZONTAL",
"values": [
{
"calculatedDisplayType": "PIVOT_VALUE_CALCULATED_DISPLAY_TYPE_UNSPECIFIED",
"dataSourceColumnReference": {
"name": "string"
},
"formula": "string",
"name": "string",
"sourceColumnOffset": 0,
"summarizeFunction": "PIVOT_STANDARD_VALUE_FUNCTION_UNSPECIFIED"
}
]
},
"textFormatRuns": [
{
"format": {
"bold": true,
"fontFamily": "string",
"fontSize": 0,
"foregroundColor": {},
"foregroundColorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"italic": true,
"link": {
"uri": "string"
},
"strikethrough": true,
"underline": true
},
"startIndex": 0
}
],
"userEnteredFormat": {
"backgroundColor": {},
"backgroundColorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"borders": {
"bottom": {
"color": {},
"colorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"style": "STYLE_UNSPECIFIED",
"width": 0
},
"left": {
"color": {},
"colorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"style": "STYLE_UNSPECIFIED",
"width": 0
},
"right": {
"color": {},
"colorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"style": "STYLE_UNSPECIFIED",
"width": 0
},
"top": {
"color": {},
"colorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"style": "STYLE_UNSPECIFIED",
"width": 0
}
},
"horizontalAlignment": "HORIZONTAL_ALIGN_UNSPECIFIED",
"hyperlinkDisplayType": "HYPERLINK_DISPLAY_TYPE_UNSPECIFIED",
"numberFormat": {
"pattern": "string",
"type": "NUMBER_FORMAT_TYPE_UNSPECIFIED"
},
"padding": {
"bottom": 0,
"left": 0,
"right": 0,
"top": 0
},
"textDirection": "TEXT_DIRECTION_UNSPECIFIED",
"textFormat": {
"bold": true,
"fontFamily": "string",
"fontSize": 0,
"foregroundColor": {},
"foregroundColorStyle": {
"rgbColor": {},
"themeColor": "THEME_COLOR_TYPE_UNSPECIFIED"
},
"italic": true,
"link": {
"uri": "string"
},
"strikethrough": true,
"underline": true
},
"textRotation": {
"angle": 0,
"vertical": true
},
"verticalAlignment": "VERTICAL_ALIGN_UNSPECIFIED",
"wrapStrategy": "WRAP_STRATEGY_UNSPECIFIED"
},
"userEnteredValue": {
"boolValue": true,
"errorValue": {
"message": "string",
"type": "ERROR_TYPE_UNSPECIFIED"
},
"formulaValue": "string",
"numberValue": 0,
"stringValue": "string"
}
}
]
}
],
"sheetId": 0
}