GridData

{
    "columnMetadata": [
        {
            "dataSourceColumnReference": {
                "name": "string"
            },
            "developerMetadata": [
                {}
            ],
            "hiddenByFilter": true,
            "hiddenByUser": true,
            "pixelSize": 0
        }
    ],
    "rowData": [
        {
            "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"
                    }
                }
            ]
        }
    ],
    "rowMetadata": [
        {
            "dataSourceColumnReference": {
                "name": "string"
            },
            "developerMetadata": [
                {}
            ],
            "hiddenByFilter": true,
            "hiddenByUser": true,
            "pixelSize": 0
        }
    ],
    "startColumn": 0,
    "startRow": 0
}