Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Jira.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Jira, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Jira Stored Procedures
| Name | Description |
| CreateIssueSchema | Generates a schema file for the Issues table, including the custom fields configured in your Jira instance. |
| CreateSchema | [DEPRECATED] Use CreateIssueSchema instead. Generates a schema file for a specified table or view, useful for integration or development purposes. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Jira. |
| GetOAuthAuthorizationURL | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Jira service. |