Jira Connector
Documentation
Version: 11
Documentation

EndPoint Update Issue


Name

update_issue

Description

No description available

Parameters

Parameter Label Required Options Description
IssueIdOrKey IssueIdOrKey NO Enter Issue ID or Key
NotifyUsers NotifyUsers NO
Option Value
true true
false false
Whether a notification email about the issue update is sent to all watchers. Possible values: true, false
OverrideScreenSecurity OverrideScreenSecurity NO
Option Value
true true
false false
Whether screen security should be overridden to enable hidden fields to be edited. Possible values: true, false
OverrideEditableFlag OverrideEditableFlag NO
Option Value
true true
false false
Whether screen security should be overridden to enable uneditable fields to be edited. Possible values: true, false

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
body DT_WSTR nvarchar(4000) 4000 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
Id DT_STR varchar(50) 50 False Issue Id or Key
ProjectId DT_WSTR nvarchar(50) 50 False Project in which to create an issue. Must use this field or ProjectKey
ProjectKey DT_WSTR nvarchar(50) 50 False Project in which to create an issue. Must use this field or ProjectId
Summary DT_WSTR nvarchar(150) 150 False Issue title
Description DT_NTEXT nvarchar(MAX) True
DescriptionFormatted DT_NTEXT nvarchar(MAX) True
Environment DT_NTEXT nvarchar(MAX) True
EnvironmentFormatted DT_NTEXT nvarchar(MAX) True
IssueTypeId DT_WSTR nvarchar(50) 50 False
IssueTypeName DT_WSTR nvarchar(50) 50 False
AssigneeUserId DT_WSTR nvarchar(50) 50 False User ID representing a user assigned to an issue
ReporterUserId DT_WSTR nvarchar(50) 50 False User ID representing a user who reported an issue
Labels DT_WSTR nvarchar(2000) 2000 True Labels, assigned to an issue in JSON string array format
DueDate DT_DBDATE date False A date refering to due date of an issue
[$parent.key$] DT_WSTR nvarchar(2000) 2000 False [Dynamic Column]
[$parent.key$]_value DT_WSTR nvarchar(2000) 2000 False Set [Dynamic Column] value by option text
[$parent.key$]_id DT_WSTR nvarchar(20) 20 False Set [Dynamic Column] value by option item id
[$parent.key$]_text DT_NTEXT nvarchar(MAX) True [Dynamic Column]_text
Required columns that you need to supply are bolded.

Examples

SSIS

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

Update rows in Issues table using API Destination

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

Jira
Issues
Update
SSIS API Destination - Access table operation