Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the provider beyond simple SELECT/INSERT/UPDATE/DELETE operations with Smartsheet.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Smartsheet, along with an indication of whether the procedure succeeded or failed.
CData ADO.NET Provider for Smartsheet Stored Procedures
| Name | Description |
| CopyRowsToAnotherSheet | Copy rows from one Smartsheet to another, streamlining data reorganization. |
| CopySheet | Duplicate an existing sheet and relocate it to a specified folder, home directory, or workspace. |
| CreateSchema | Generate schema files for specified tables or views for documentation or integration purposes. |
| CreateSheet | Create a new sheet in Smartsheet for data organization and tracking. |
| DeleteAttachment | Remove a specified attachment from Smartsheet to maintain data integrity. |
| DeleteSheet | Delete a specific sheet from Smartsheet to manage space and relevance. |
| DownloadAttachment | Download attachments directly from Smartsheet for offline access. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Smartsheet. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| ImportFile | Import CSV or XLSX files into Smartsheet, specifying the target folder or workspace. |
| MoveRowsToAnotherSheet | Move rows between Smartsheets for efficient data organization and management. |
| MoveSheet | Relocate a sheet to a new folder, home directory, or workspace for better accessibility. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to Smartsheet resources without requiring reauthorization from the user. |