Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver 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 JDBC Driver for Xero Stored Procedures
| Name | Description |
| DisconnectOAuthAccessToken | Disconnects the OAuth access token used for authentication with Xero API. |
| GetLimitInfo | Retrieves limit information, helping monitor API usage and limits for making calls against a specific 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. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with various Xero services. |
| RevokeTenant | Revokes the tenant connection, requiring the user to reauthorize next time they attempt to connect to that tenant. |