Power BI Connector for Google Sheets

Build 20.0.7587

Stored Procedures

Stored procedures are available to complement the data available from the Using Spreadsheets as Tables. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.

CData Power BI Connector for Google Sheets Stored Procedures

Name Description
AddSheet Add a worksheet to an existing Google spreadsheet.
CopySheet Copies a sheet from a spreadsheet to another spreadsheet.
CreateSchema Creates a schema file for the specified table or view.
CreateSpreadsheet Creates a spreadsheet in the user's Google Drive.
DeleteSheet Deletes a worksheet in an existing Google spreadsheet.
DeleteSpreadsheet Deletes a spreadsheet.
DownloadDocument Downloads a file from the user's Google Drive.
FormatRange Format cells in a specific range
GetOAuthAccessToken Obtains the OAuth access token to be used for authentication with various Google services.
GetOAuthAuthorizationURL Obtains the OAuth authorization URL for authentication with various Google services.
RefreshOAuthAccessToken Obtains the OAuth access token to be used for authentication with various Google services.
UpdateSheet Add a worksheet to an existing Google spreadsheet.
UploadDocument Uploads a file to the user's Google Drive.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587