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"
        }
    ]
}