ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Xero の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにXero から関連するレスポンスデータを返します。
CData SSIS Components for Xero ストアドプロシージャ
Name | Description |
AllocatetoInvoice | Allocates a document against an Invoice. |
CreateReportSchema | Saves a dynamic ProfitAndLoss report as a custom schema. |
DisconnectOAuthAccessToken | Disconnects the OAuth access token used for authentication with Xero API. |
DownloadAttachment | Obtains an attachment from a specified document in Xero. |
DownloadPDF | Downloads a specified document in PDF format from Xero. |
GetLimitInfo | Retrieves limit information. Use this stored procedure to monitor your API limits as you make calls against a tenant. |
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. |
ListAttachments | Retrieves a list of attachments that have been uploaded against a document in Xero. |
RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with various Xero services. |
RevokeTenant | Disconnects the tenant from this application. The user must reauthorize the next time they connect this application to that tenant. |
SendInvoiceEmail | Sends an email to the contacts of a sales invoice |
UploadAttachment | Obtains a list of attachments an item has in Xero. |