Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with OData.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from OData, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for OData Stored Procedures
| Name | Description |
| CreateAssociation | Creates an association between two entities based on a navigation property. |
| CreateSchema | Creates a schema file for the specified table or view. |
| GetOAuthAccessToken | Gets the auth token used to authenticate to the service. |
| 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. |
| GetSAPCSRFToken | Returns a CSRF token and cookie for authentication to SAP. |
| ListAssociations | Lists associations for a given table and navigation property. |
| ListNavigationProperties | Lists navigation properties for a given table and the tables they are associated with. Navigation properties are used by the Association stored procedures. |
| RefreshOAuthAccessToken | Obtains an updated OAuthAccessToken if passed a token to refresh. |
| RemoveAssociation | Removes an association between two entities based on a navigation property. |