Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT operations with Anaplan.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Anaplan, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Anaplan Stored Procedures
| Name | Description |
| CancelExport | Cancels an ongoing export task. |
| DeleteFile | Deletes the content of a file from Anaplan. This only removes private content. Default content and the import data source model object remain. |
| DownloadFile | Downloads a file. |
| DownloadFileChunk | Downloads a specific chunk of a file. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made. |
| GetOAuthAuthorizationUrl | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to resources without requiring reauthorization from the user. |
| StartExport | Initiates an Export Task based on an existing Export Definition. Returns a Task ID to monitor. |