AddDataSourceTable
Add a DataSource Table to a sheet. A Custom OAuth app with the scope bigquery.readonly is required to run this stored procedure.
Input
| Name | Type | Description |
| SpreadsheetId | String | The ID of the spreadsheet where the table will be created. |
| DataSourceId | String | The ID of the DataSource. |
| SheetId | String | The ID of the sheet where the table will be pulled to. If not specified 0 will be assumed
The default value is 0. |
| RowLimit | String | The limit of rows to return. If not set, a default limit is applied |
| Range | String | Range where the dataTable will be pulled to. Ex: A1:G10 |
| RefreshDatasourceMode | String | Refreshes the datasource table after creating it. DATASOURCEID - Refreshes all associated data source objects for the datasource. ISALL - Refreshes all existing data source objects in the spreadsheet. NONE - Do not refresh the datasource table
The allowed values are DATASOURCEID, ISALL, NONE. The default value is DATASOURCEID. |
Result Set Columns
| Name | Type | Description |
| Success | String | This value shows whether the operation was successful or not. |