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 |
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 |
|---|---|---|---|---|---|
| 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
