Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with PostgreSQL.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from PostgreSQL, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for PostgreSQL Stored Procedures
| Name | Description |
| GetAdminConsentURL | Gets the admin consent URL that must be opened separately by an admin of a given domain to grant access to your application. Only needed when using custom OAuth credentials. |
| GetOAuthAccessToken | Gets an authentication token from Azure Active Directory. |
| 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. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Azure Active Directory. |