Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Cloudant.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Cloudant, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Cloudant Stored Procedures
| Name | Description |
| CreateSchema | Creates a schema definition of a table in Cloudant. Control column discovery with FlattenObjects, FlattenArrays, TypeDetectionScheme, and RowScanDepth. |
| GetDocumentOnRevision | Retrieves the full content of a Cloudant document as it existed in a specific revision. This enables you to view or work with the document’s state at a particular point in its revision history. |
| GetOAuthAccessToken | Gets an authentication token from IBM Cloud. The connection property ApiKey must be specified when calling this stored procedure. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with IBM Cloud. The connection property ApiKey must be specified when calling this stored procedure. |