ImportSources
This view returns a list of importsources for a certain schema.
Select
The connector uses the Jira Assets API to process the request. The rest of the filter is executed client-side within the connector.The following filters are processed server-side, and are required:
- SchemaId supports the following operators: =, IN
SELECT * FROM ImportSources WHERE SchemaId = 123
SELECT * FROM ImportSources WHERE SchemaId IN (123, 456)
Columns
| Name | Type | Description |
| SchemaId [KEY] | String | The SchemaId filter of the ImportSources. |
| WorkspaceId | String | The WorkspaceId of the ImportSources. |
| GlobalId | String | The GlobalId of the ImportSources. |
| Id [KEY] | String | The Id of the ImportSources. |
| CollectionId | String | The CollectionId of the ImportSources. |
| Name | String | The Name of the ImportSources. |
| Created | Datetime | The Created of the ImportSources. |
| Updated | Datetime | The Updated of the ImportSources. |
| Description | String | The Description of the ImportSources. |
| ObjectSchemaId | String | The ObjectSchemaId of the ImportSources. |
| ImportSourceModuleKey | String | The ImportSourceModuleKey of the ImportSources. |
| DefaultConcatenator | String | The DefaultConcatenator of the ImportSources. |
| DefaultHandleEmptyValues | String | The DefaultHandleEmptyValues of the ImportSources. |
| DefaultHandleUnknownValues | String | The DefaultHandleUnknownValues of the ImportSources. |
| DateFormat | String | The DateFormat of the ImportSources. |
| DateTimeFormat | String | The DateTimeFormat of the ImportSources. |
| ImportSpecificConfiguration | String | The ImportSpecificConfiguration of the ImportSources. |
| ImportSourceOTEntries | String | The ImportSourceOTEntries of the ImportSources. |
| TokenGenerated | Bool | The TokenGenerated of the ImportSources. |
| ConfigurationStatusType | String | The ConfigurationStatusType of the ImportSources. |
| ValidationStatusType | String | The ValidationStatusType of the ImportSources. |
| ImportSourcesStatusname | String | The ImportSourcesStatusname of the ImportSources. |
| ConfigurationAuiLozenge | String | The ConfigurationAuiLozenge of the ImportSources. |
| ValidationAuiLozenge | String | The ValidationAuiLozenge of the ImportSources. |
| Validation | String | The Validation of the ImportSources. |