EndPoint Read Issues

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_issues

Description

No description available

Parameters

Parameter

Label

Required

Options

Description

SearchBy

Search by

Option	Value
None
Project Key(s)	Project
JQL Expression	JQL
Issue Id(s) or Key(s)	Key

Project

Specify a project to search issues for

JQL

Option	Value
Search Ids (IN)	key IN(10001, 10002, 10003)
Search Keys (IN)	key IN(CS-1, CS-2, CS-3)
Search Projects (IN)	project IN(PROJ1, PROJ2, PROJ3)
Search Status (EQUAL)	status='Done'
Search Date (Expression 1)	created >=-5d
Search Date (Expression 2)	created >=startOfMonth() AND created <=now()
Search Date (Expression 3)	created >=startOfYear() AND created <=startOfDay()
Search Date (Static)	created >= "2008-12-31"
Search Date (Static with time)	created >= '2008/12/31 23:59'
Search Date (Issue Update Date)	updated >=-5d
Search Project and Status (AND + IN)	project=CS AND status NOT IN ('Done', 'Open', 'Closed')
Search Assignee and Created Date	assignee is NOT EMPTY and created < -1d
Search Text (Contains - Fuzzy)	Summary ~ 'some words' OR description ~ 'some words'
Search Text (Contains - Fuzzy Wildcard)	Summary ~ 'some' OR description ~ 'some'
Search Text (Contains - Exact)	Summary ~ '\"exact words\"' OR description ~ '\"exact words\"'
Search Text (Does Not Contain - Fuzzy)	Summary !~ 'some words' OR description !~ 'some words'
Search Empty OR Null	fixVersion is empty OR fixVersion is null
Search Is Not Empty OR Is Not Null	fixVersion is not empty OR fixVersion is not null
Search WAS Operator (previous value)	status WAS "Resolved" BY (jsmith,srogen) BEFORE "2019/02/02"
Search WAS IN Operator	status WAS IN ("Resolved", "In Progress")
Search WAS NOT IN Operator	status WAS NOT IN ("Resolved", "In Progress")
Search WAS + BY + DURING (date range)	status WAS "Resolved" BY (jsmith,srogen) DURING("2019/02/02", "2020/02/02")
Search CHANGED operator	assignee CHANGED
Search CHANGED operator (multiple)	status CHANGED FROM "In Progress" TO "Open"

Use JQL to use an advanced mode of searching. Few links are https://www.atlassian.com/blog/jira/jql-the-most-flexible-way-to-search-jira-14 and als check https://wac-cdn.atlassian.com/dam/jcr:241d9c9b-475f-411f-90a2-97ca344442b3/atlassian-jql-cheat-sheet-2.pdf?cdnVersion=2169 [API reference]

Key

Issue Key(s) or Ids - Comma Separated (PRJA-10,PRJA-13)

Use comma separated IDs or Keys for Issues. 1000 ids max or JIRA internal limit for Payload.

CustomColumnsRegex

Enter regular expression for custom columns which you like to output. Use Pipe to type multiple column names (must use key - internal names for columns e.g. customfield_10004). You can use Regex too (e.g. field_100\d+ ). This filter is only applied for those fields which has flag custom=true.

Output Columns

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

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.