ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Smartsheet の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにSmartsheet から関連するレスポンスデータを返します。
CData Excel Add-In for Smartsheet ストアドプロシージャ
| 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. |