Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in 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 Excel Add-In for Smartsheet Stored Procedures
| Name | Description |
| CopyRowsToAnotherSheet | Copies rows from one Smartsheet to another, streamlining data reorganization. |
| CopySheet | Duplicates an existing sheet and relocates it to a specified folder, home directory, or workspace. |
| CreateSchema | Generates schema files for specified tables or views for documentation or integration purposes. |
| CreateSheet | Creates a new sheet in Smartsheet for data organization and tracking. |
| DeleteAttachment | Deletes an attachment located in one of your Smartsheet sheets. |
| DeleteDashboardShare | Deletes a dashboard share in your Smartsheet account. |
| DeleteReportShare | Deletes a report share in your Smartsheet account. |
| DeleteSheet | Deletes a specific sheet from Smartsheet to manage space and relevance. |
| DeleteSheetShare | Deletes a sheet share in your Smartsheet account. |
| DeleteUser | Deletes a user in your Smartsheet account. |
| DeleteWorkspaceShare | Deletes a workspace share in your Smartsheet account. |
| DownloadAttachment | Downloads 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 | Imports CSV or XLSX files into Smartsheet, specifying the target folder or workspace. |
| MoveRowsToAnotherSheet | Moves rows between Smartsheets for efficient data organization and management. |
| MoveSheet | Relocates 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. |
| ShareDashboard | Shares a dashboard with a user or group in your Smartsheet account. |
| ShareReport | Shares a report with a user or group in your Smartsheet account. |
| ShareSheet | Shares a sheet with a user or group in your Smartsheet account. |
| ShareWorkspace | Shares a workspace with a user or group in your Smartsheet account. |
| UpdateDashboardShare | Updates a dashboard share in your Smartsheet account. |
| UpdateReportShare | Updates a report share in your Smartsheet account. |
| UpdateSheetShare | Updates a sheet share in your Smartsheet account. |
| UpdateWorkspaceShare | Updates a workspace share in your Smartsheet account. |
| UploadAttachment | Uploads a file attachment in one of your Smartsheet sheets. |
| UploadAttachmentVersion | Uploads a new attachment version to a file attachment in one of your Smartsheet sheets. |