Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Elasticsearch.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Elasticsearch, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Elasticsearch Stored Procedures
| Name | Description |
| CreateIndex | Submits a request to create an index with specified settings. |
| CreateSchema | Creates a schema file for the collection. |
| GetOAuthAccessToken | Gets an authentication token from AzureAD. |
| GetOAuthAuthorizationUrl | Gets an authorization URL from the data source. The authorization URL can be used to generate a verifier required to obtain the OAuth token. |
| ModifyIndexAliases | Submits an alias request to modify index aliases. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token. |
| UpdateIndexSettings | Procedure for updating index settings. Note that some settings may only be updated on a closed index. |