Reference

Endpoint Read Issue (By Id)

Name

get_issue

Description

No description available

Related Tables

Issues

Parameters

Parameter Required Options
Name: Key

Label: Issue Key(s) or Id(s) (e.g. 10004 -OR- PRJA-1)

Use ID or Key for Issues. For multiple Keys/Ids use comma to separate them 		YES
Name: Fields

Label: Fields
Option Value
Default
Only Keys id,key
All fields *all
Name: MetaDetectionOrder

Label: Metadata Mode (Change if columns missing) **SLOW**

Only change if expected columns are missing (e.g. SLA or nested custom fields). Default uses predefined columns (fast). MergeStaticDynamic scans sample data to infer types and merge with static metadata—slower but exposes nested/document columns; use META='@OverrideMode:1' in SQL to add specific dynamic fields.
Option Value
Default Default
Static Static
MergeStaticDynamic MergeStaticDynamic

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_I8 bigint
Key DT_WSTR nvarchar(50) 50
ProjectKey DT_WSTR nvarchar(50) 50
ProjectName DT_WSTR nvarchar(500) 500
StatusName DT_WSTR nvarchar(500) 500
Summary DT_WSTR nvarchar(2000) 2000
Created DT_DBTIMESTAMP datetime
Updated DT_DBTIMESTAMP datetime
Description DT_NTEXT nvarchar(MAX) Join formatted text blocks using space separator (new lines will be lost)
DescriptionFormatted DT_NTEXT nvarchar(MAX)
CreatorAccountId DT_WSTR nvarchar(100) 100
CreatorEmailAddress DT_WSTR nvarchar(100) 100
ReporterAccountId DT_WSTR nvarchar(100) 100
ReporterEmailAddress DT_WSTR nvarchar(100) 100
AssigneeAccountId DT_WSTR nvarchar(100) 100
AssigneeEmailAddress DT_WSTR nvarchar(100) 100
ResolutionId DT_I8 bigint
ResolutionDescription DT_WSTR nvarchar(4000) 4000
ResolutionName DT_WSTR nvarchar(500) 500
Resolution DT_NTEXT nvarchar(MAX)
TimespentInSeconds DT_I8 bigint
DueDate DT_DBDATE date
Expand DT_WSTR nvarchar(150) 150
StatusCategoryChangeDate DT_DBTIMESTAMP datetime
Self DT_WSTR nvarchar(150) 150
IssueTypeSelf DT_WSTR nvarchar(150) 150
IssueTypeId DT_I8 bigint
IssueTypeDescription DT_NTEXT nvarchar(MAX)
IssueTypeIconUrl DT_WSTR nvarchar(500) 500
IssueTypeName DT_WSTR nvarchar(100) 100
IssueTypeSubtask DT_BOOL bit
IssueTypeAvatarId DT_I4 int
IssueTypeEntityId DT_GUID uniqueidentifier
IssueTypeHierarchyLevel DT_I4 int
ProjectSelf DT_WSTR nvarchar(150) 150
ProjectId DT_I8 bigint
ProjectTypeKey DT_WSTR nvarchar(100) 100
ProjectSimplified DT_BOOL bit
ProjectAvatarUrls48x48 DT_WSTR nvarchar(500) 500
ProjectAvatarUrls24x24 DT_WSTR nvarchar(500) 500
ProjectAvatarUrls16x16 DT_WSTR nvarchar(500) 500
ProjectAvatarUrls32x32 DT_WSTR nvarchar(500) 500
FixVersions DT_NTEXT nvarchar(MAX)
AggregateTimespentInSeconds DT_I8 bigint
ResolutionDate DT_DBTIMESTAMP datetime
WorkRatio DT_WSTR nvarchar(100) 100
WatchesSelf DT_WSTR nvarchar(150) 150
WatchesWatchCount DT_I4 int
WatchesIsWatching DT_BOOL bit
LastViewed DT_DBTIMESTAMP datetime
PrioritySelf DT_WSTR nvarchar(150) 150
PriorityIconUrl DT_WSTR nvarchar(500) 500
PriorityName DT_WSTR nvarchar(100) 100
PriorityId DT_I4 int
Labels DT_NTEXT nvarchar(MAX)
AggregateTimeOriginalEstimate DT_WSTR nvarchar(50) 50
TimeEstimate DT_WSTR nvarchar(50) 50
Versions DT_NTEXT nvarchar(MAX)
IssueLinks DT_NTEXT nvarchar(MAX)
AssigneeSelf DT_WSTR nvarchar(150) 150
AssigneeAvatarUrls48x48 DT_WSTR nvarchar(500) 500
AssigneeAvatarUrls24x24 DT_WSTR nvarchar(500) 500
AssigneeAvatarUrls16x16 DT_WSTR nvarchar(500) 500
AssigneeAvatarUrls32x32 DT_WSTR nvarchar(500) 500
AssigneeDisplayName DT_WSTR nvarchar(500) 500
AssigneeActive DT_BOOL bit 32
AssigneeTimeZone DT_WSTR nvarchar(100) 100
AssigneeAccountType DT_WSTR nvarchar(100) 100
StatusSelf DT_WSTR nvarchar(150) 150
StatusDescription DT_NTEXT nvarchar(MAX)
StatusIconUrl DT_WSTR nvarchar(500) 500
StatusId DT_I4 int
StatusCategorySelf DT_WSTR nvarchar(150) 150
StatusCategoryId DT_I4 int
StatusCategoryKey DT_WSTR nvarchar(100) 100
StatusCategoryColorName DT_WSTR nvarchar(100) 100
StatusCategoryName DT_WSTR nvarchar(100) 100
Components DT_NTEXT nvarchar(MAX)
TimeOriginalEstimate DT_WSTR nvarchar(50) 50
DescriptionVersion DT_I4 int
DescriptionType DT_WSTR nvarchar(50) 50
Security DT_WSTR nvarchar(150) 150
AggregateTimeEstimate DT_I8 bigint
CreatorSelf DT_WSTR nvarchar(150) 150
CreatorAvatarUrls48x48 DT_WSTR nvarchar(500) 500
CreatorAvatarUrls24x24 DT_WSTR nvarchar(500) 500
CreatorAvatarUrls16x16 DT_WSTR nvarchar(500) 500
CreatorAvatarUrls32x32 DT_WSTR nvarchar(500) 500
CreatorDisplayName DT_WSTR nvarchar(200) 200
CreatorActive DT_BOOL bit
CreatorTimeZone DT_WSTR nvarchar(100) 100
CreatorAccountType DT_WSTR nvarchar(100) 100
Subtasks DT_NTEXT nvarchar(MAX)
ReporterSelf DT_WSTR nvarchar(150) 150
ReporterAvatarUrls48x48 DT_WSTR nvarchar(500) 500
ReporterAvatarUrls24x24 DT_WSTR nvarchar(500) 500
ReporterAvatarUrls16x16 DT_WSTR nvarchar(500) 500
ReporterAvatarUrls32x32 DT_WSTR nvarchar(500) 500
ReporterDisplayName DT_WSTR nvarchar(100) 100
ReporterActive DT_BOOL bit
ReporterTimeZone DT_WSTR nvarchar(100) 100
ReporterAccountType DT_WSTR nvarchar(100) 100
AggregateProgressPercent DT_I4 int
AggregateProgressInSeconds DT_I8 bigint
AggregateProgressTotalInSeconds DT_I8 bigint
Environment DT_NTEXT nvarchar(MAX) Join formatted text blocks using space separator (new lines will be lost)
EnvironmentFormatted DT_NTEXT nvarchar(MAX)
ProgressInSeconds DT_I8 bigint
ProgressTotalInSeconds DT_I8 bigint
VotesSelf DT_WSTR nvarchar(150) 150
Votes DT_I4 int
HasVoted DT_BOOL bit
ParentId DT_I4 int
ParentKey DT_WSTR nvarchar(50) 50
ParentSelf DT_WSTR nvarchar(150) 150
ParentSummary DT_WSTR nvarchar(2000) 2000
ParentStatusSelf DT_WSTR nvarchar(150) 150
ParentStatusDescription DT_WSTR nvarchar(2000) 2000
ParentStatusIconUrl DT_WSTR nvarchar(500) 500
ParentStatusName DT_WSTR nvarchar(100) 100
ParentStatusId DT_I8 bigint
ParentStatusCategorySelf DT_WSTR nvarchar(150) 150
ParentStatusCategoryId DT_I4 int
ParentStatusCategoryKey DT_WSTR nvarchar(50) 50
ParentStatusCategoryColorName DT_WSTR nvarchar(50) 50
ParentStatusCategoryName DT_WSTR nvarchar(50) 50
ParentprioritySelf DT_WSTR nvarchar(150) 150
ParentpriorityIconUrl DT_WSTR nvarchar(500) 500
ParentpriorityName DT_WSTR nvarchar(50) 50
ParentpriorityId DT_I4 int
ParentIssueTypeSelf DT_WSTR nvarchar(150) 150
ParentIssueTypeId DT_I8 bigint
ParentIssueTypeDescription DT_WSTR nvarchar(2000) 2000
ParentIssueTypeIconUrl DT_WSTR nvarchar(500) 500
ParentIssueTypeName DT_WSTR nvarchar(50) 50
ParentIssueTypeSubtask DT_BOOL bit
ParentIssueTypeAvatarId DT_I4 int
ParentIssueTypeEntityId DT_GUID uniqueidentifier
ParentIssueTypeHierarchyLevel DT_I4 int
Assignee DT_WSTR nvarchar(150) 150
ResolutionSelf DT_WSTR nvarchar(150) 150
[$parent.key$] DT_WSTR nvarchar(2000) 2000 [Dynamic Column]
[$parent.key$]_value DT_WSTR nvarchar(2000) 2000 [Dynamic Column]_value
[$parent.key$]_id DT_WSTR nvarchar(20) 20 [Dynamic Column]_id
[$parent.key$]_child_value DT_WSTR nvarchar(2000) 2000 [Dynamic Column]_child_value
[$parent.key$]_child_id DT_WSTR nvarchar(20) 20 [Dynamic Column]_child_id
[$parent.key$]_values DT_WSTR nvarchar(2000) 2000 [Dynamic Column]_values
[$parent.key$]_text DT_NTEXT nvarchar(MAX) [Dynamic Column]_text Join formatted text blocks using space separator (new lines will be lost)
[$parent.key$]_accountId DT_WSTR nvarchar(100) 100 [Dynamic Column]_accountId
[$parent.key$]_email DT_WSTR nvarchar(300) 300 [Dynamic Column]_email
[$parent.key$]_name DT_WSTR nvarchar(300) 300 [Dynamic Column]_name
If the column you are looking for is missing, consider customizing Jira Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length 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 or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Issues table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Jira
Read and write Jira data effortlessly. Track, manage, and automate issues, projects, worklogs, and comments — almost no coding required.
Jira
Issues
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Issues table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to read issue:

API Destination - Jira
Read and write Jira data effortlessly. Track, manage, and automate issues, projects, worklogs, and comments — almost no coding required.
Jira
Issues
Lookup
There are no parameters to configure.
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read issue 

SELECT * FROM Issues

get_issue endpoint belongs to Issues 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 

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

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

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