EndPoint Create Issues
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 |
|
key |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
self |
DT_WSTR
|
nvarchar(450)
|
450 | False |
Input Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
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 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:
Insert into 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
Insert
