CData JDBC Driver for Smartsheet 2019 - Online Help
Questions / Feedback?

Stored Procedures

CData JDBC Driver for Smartsheet 2019 - Build 19.0.7354

Stored procedures are available to complement the data available from the Data Model. 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 JDBC Driver for Smartsheet 2019 Stored Procedures

Name Description
CopyRowsToAnotherSheet Copy rows form to another sheet.
CreateSchema Creates a schema file for the specified table or view.
CreateSheet Create a sheet.
DeleteSheet Delete a specified sheet.
DownloadAttachment Download an attachment from a sheet.
GetOAuthAccessToken Gets the OAuth access token from Smartsheet.
GetOAuthAuthorizationURL Gets the Smartsheet authorization URL. Access the URL returned in the output in an Internet browser. This requests the access token that can be used as part of the connection string to Smartsheet.
RefreshOAuthAccessToken Refreshes the OAuth access token used for authentication with various Smartsheet services.

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