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. |