TDV Adapter for Smartsheet

Build 21.0.8137

Stored Procedures

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.

Smartsheet Adapter Stored Procedures

Name Description
CopyRowsToAnotherSheet Copy rows form to another sheet.
CopySheet Copy sheets form to another folder/home/workplace.
CreateSchema Creates a schema file for the specified table or view.
CreateSheet Create a sheet.
DeleteAttachment Deletes the attachment specified.
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.
ImportFile Import a CSV or XLSX file to the top-level 'sheets' folder. You can also import it to a specific folder or workspace by specifying their id. You should specify only one of them.
MoveRowsToAnotherSheet Move rows form to another sheet.
MoveSheet Moves the specified sheet to a new location..
RefreshOAuthAccessToken Refreshes the OAuth access token used for authentication with various Smartsheet services.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137