Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT/INSERT/UPDATE/DELETE operations with Jira Assets.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Jira Assets, along with an indication of whether the procedure succeeded or failed.
CData Tableau Connector for Jira Assets Stored Procedures
| Name | Description |
| ChangeObjectTypePosition | Change position of this object type. |
| CreateSchema | Creates a schema file for the specified table or view. |
| CreateStructureFromTemplate | This is an experimental API. Creates a structure from a template. A structure refers to a schema that also contains object types, object attributes, reference types, status types etc. This stored procedure is only available when using APIToken authentication. |
| GenerateImportSourceBearerToken | Generate a Bearer token which can be used to authenticate against Assets /importsource/ APIs, to take actions against the specified import source. |
| GetImportConfigStatus | Get information about the configuration status of a specific import source. |
| GetImportSourceInfo | This is an experimental API. Creates a structure from a template. A structure refers to a schema that also contains object types, object attributes, reference types, status types etc. |
| GetOAuthAccessToken | Gets an authentication token from Jira. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the auth token from this URL. |
| ProvideExternalImportSchema | Provide object schema and mapping configuration for the external import. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Jira service. |
| StartConfiguredImport | Start configured imports. To see an ongoing import see the Progress resource. |
| UpdateExternalImportSchema | Update object schema and mapping configuration for the external import. |
| UpdateGeneralConfigForObjectSchema | Update general configuration for object schema. |