Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Xero.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Xero, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Xero Stored Procedures
| 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. |