Create Issues
Name
create_issues
Description
Related Tables
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 |
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:

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