ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Xero の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにXero から関連するレスポンスデータを返します。
CData JDBC Driver for Xero ストアドプロシージャ
| Name | Description |
| DisconnectOAuthAccessToken | Disconnects the OAuth access token used for authentication with Xero API. |
| DownloadFile | Used to download a file from Xero's file storage service. |
| GetLimitInfo | Retrieves limit information related to the Xero API, helping to monitor how many API calls remain available for the current tenant within the allowed limits. |
| GetOAuthAccessToken | Obtains the OAuth access token to be used for authentication with Xero. |
| GetOAuthAuthorizationURL | Obtains the OAuth authorization URL for authentication with various Xero services. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with various Xero services. |
| RevokeTenant | Disconnects the specified tenant from the application. After this operation, the user must reauthorize their connection to the tenant the next time they interact with the app. |
| UploadFile | Used to upload a file to Xero's file storage service. It allows for attaching documents such as invoices, receipts, and contracts to records in Xero. |