Reference

Endpoint Create Issues

Name

create_issues

Description

No description available

Related Tables

Issues

Parameters

Parameter Required Options
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
id DT_WSTR nvarchar(50) 50
key DT_WSTR nvarchar(50) 50
self DT_WSTR nvarchar(450) 450
If the column you are looking for is missing, consider customizing Jira Connector.

Input Columns

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

Examples

SSIS

Use Jira Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the Issues table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to create issues:

API Destination - Jira
Jira connector can be used to read, write, delete Issues, Users, Worklogs, Comments, Projects, Custom fileds and many other details
Jira
Issues
Insert
There are no parameters to configure.
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).