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