Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components 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 | Delete an attachment located in one of your Smartsheet sheets. |
| DeleteDashboardShare | Delete a dashboard share in your Smartsheet account. |
| DeleteReportShare | Delete a report share in your Smartsheet account. |
| DeleteSheet | Delete a specific sheet from Smartsheet to manage space and relevance. |
| DeleteSheetShare | Delete a sheet share in your Smartsheet account. |
| DeleteUser | Delete a user in your Smartsheet account. |
| DeleteWorkspaceShare | Delete a workspace share in your Smartsheet account. |
| 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. |
| ShareDashboard | Share a dashboard with a user or group in your Smartsheet account. |
| ShareReport | Share a report with a user or group in your Smartsheet account. |
| ShareSheet | Share a sheet with a user or group in your Smartsheet account. |
| ShareWorkspace | Share a workspace with a user or group in your Smartsheet account. |
| UpdateDashboardShare | Update a dashboard share in your Smartsheet account. |
| UpdateReportShare | Update a report share in your Smartsheet account. |
| UpdateSheetShare | Update a sheet share in your Smartsheet account. |
| UpdateWorkspaceShare | Update a workspace share in your Smartsheet account. |
| UploadAttachment | Upload a file attachment in one of your Smartsheet sheets. |
| UploadAttachmentVersion | Upload a new attachment version to a file attachment in one of your Smartsheet sheets. |