Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Linear.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Linear, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Linear Stored Procedures
| Name | Description |
| CreateSchema | Creates a schema file for the specified table or view. |
| GetOAuthAccessToken | Exchanges a Linear authorization code for an OAuth 2.0 access token (and refresh token). Used with the authorization code flow (AuthScheme=OAuth). |
| GetOAuthAuthorizationURL | Builds the URL to open in a browser so a Linear user can grant the application access. Used with the OAuth 2.0 authorization code flow (AuthScheme=OAuth). |
| RefreshOAuthAccessToken | Obtains a new Linear OAuth 2.0 access token from a refresh token, when the cached token has expired. Used with the authorization code flow (AuthScheme=OAuth). |