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