RefreshDataSourceRequest

Refreshes one or multiple data source objects in the spreadsheet by the specified references. The request requires an additional bigquery.readonly OAuth scope. If there are multiple refresh requests referencing the same data source objects in one batch, only the last refresh request is processed, and all those requests will have the same response accordingly.

{
    "dataSourceId": "string",
    "force": true,
    "isAll": true,
    "references": {
        "references": [
            {
                "chartId": 0,
                "dataSourceFormulaCell": {
                    "columnIndex": 0,
                    "rowIndex": 0,
                    "sheetId": 0
                },
                "dataSourcePivotTableAnchorCell": {
                    "columnIndex": 0,
                    "rowIndex": 0,
                    "sheetId": 0
                },
                "dataSourceTableAnchorCell": {
                    "columnIndex": 0,
                    "rowIndex": 0,
                    "sheetId": 0
                },
                "sheetId": "string"
            }
        ]
    }
}