ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Smartsheet の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにSmartsheet から関連するレスポンスデータを返します。
CData Python Connector 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 | Remove a specified attachment from Smartsheet to maintain data integrity. |
| DeleteSheet | Delete a specific sheet from Smartsheet to manage space and relevance. |
| 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. |