JDBC Driver for Google Sheets

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462