Jira Connector
Documentation
Version: 11
Documentation
Endpoint

Create Issues


Name

create_issues

Description

No description available

Related Tables

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
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

INSERT Issue

Inserts a single issue to a particular project

INSERT INTO Issues(ProjectKey, IssueTypeName, Summary, Description)
VALUES('SMP', 'Task', 'My ticket inserted through the API', 'A description about an issue')
WITH (Output=1)

INSERT Multiple Issues (BULK Load from External System like Microsoft SQL Server / ODBC)

Inserts multiple issues from an external source (e.g. Microsoft SQL Server or ODBC)

INSERT INTO Issues(ProjectKey, IssueTypeName, Summary, Description)
SOURCE('MSSQL' --OR ODBC
, 'Data Source=localhost;Initial Catalog=Northwind;Integrated Security=true'
--For ODBC
--, 'Dsn=MyOdbcDsn' 
--, 'Driver={My ODBC Driver Type}...' 
--Alias must match Supported Input Columns - Use Query Builder to find Input Column Names
,'select top 10 C_ProjKey as ProjectKey, C_Type as IssueTypeName, C_Summary as Summary, C_Desc as Description FROM Orders'

--Static value example
--,'select top 10 ''CS'' as ProjectKey, ''New Feature'' as IssueTypeName, ''Task created - <<FUN_SEQUENCE>>'' Summary, ''A description <<FUN_NOW>>'' Description FROM Orders'
)

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

INSERT Issue

Inserts a single issue to a particular project

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Issues(ProjectKey, IssueTypeName, Summary, Description)
VALUES(''SMP'', ''Task'', ''My ticket inserted through the API'', ''A description about an issue'')
WITH (Output=1)';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

INSERT Multiple Issues (BULK Load from External System like Microsoft SQL Server / ODBC)

Inserts multiple issues from an external source (e.g. Microsoft SQL Server or ODBC)

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Issues(ProjectKey, IssueTypeName, Summary, Description)
SOURCE(''MSSQL'' --OR ODBC
, ''Data Source=localhost;Initial Catalog=Northwind;Integrated Security=true''
--For ODBC
--, ''Dsn=MyOdbcDsn'' 
--, ''Driver={My ODBC Driver Type}...'' 
--Alias must match Supported Input Columns - Use Query Builder to find Input Column Names
,''select top 10 C_ProjKey as ProjectKey, C_Type as IssueTypeName, C_Summary as Summary, C_Desc as Description FROM Orders''

--Static value example
--,''select top 10 ''''CS'''' as ProjectKey, ''''New Feature'''' as IssueTypeName, ''''Task created - <<FUN_SEQUENCE>>'''' Summary, ''''A description <<FUN_NOW>>'''' Description FROM Orders''
)';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

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