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 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 Excel Add-In 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. |
| 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. |
| ProvideExternalImportSchema | Provide object schema and mapping configuration for the external import. |
| 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. |