Jira Connector
Documentation
Version: 11
Documentation
Endpoint

Read Issue Types


Name

get_types

Description

No description available

Related Tables

IssueTypes

Parameters

Parameter Label Required Options Description
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(50) 50 False
Description DT_WSTR nvarchar(1000) 1000 False
Name DT_WSTR nvarchar(200) 200 False
UntranslatedName DT_WSTR nvarchar(200) 200 False
Subtask DT_BOOL bit False
AvatarId DT_I8 bigint False
HierarchyLevel DT_I8 bigint False
ScopeType DT_WSTR nvarchar(50) 50 False
ScopeProjectId DT_WSTR nvarchar(50) 50 False
IconUrl DT_WSTR nvarchar(500) 500 False
Self DT_WSTR nvarchar(150) 150 False
If the column you are looking for is missing, consider customizing Jira Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Jira Connector in API Source component to read data or in API Destination component to read/write data:

Read from IssueTypes table using API Destination

This Endpoint belongs to IssueTypes table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Jira
IssueTypes
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read issue types

SELECT * FROM get_types

get_types endpoint belongs to IssueTypes table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Read issue types

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_types';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

get_types endpoint belongs to IssueTypes table(s), and can therefore be used via those table(s).