Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT operations with Zuora.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Zuora, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Zuora Stored Procedures
| Name | Description |
| CreateSchema | Creates a schema definition of a table in Zuora. |
| DownloadExport | Execute a query in Zuora Export and download the exported file in CSV format. |
| DownloadFile | Retrieve files such as export results, invoices, and accounting period reports. |
| GetOAuthAccessToken | Gets an authentication token from Zuora. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Zuora. |
| UploadFileForInvoice | Uploads an invoice PDF file (Maximum: 4MB) for an invoice that is in Draft or Posted status. |