Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the server 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 Code Assist MCP 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. |