Reference

Endpoint Create User

Name

create_user

Description

No description available

Related Tables

Users

Parameters

Parameter	Required	Options
There are no parameters

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length
DisplayName	`DT_WSTR`	`nvarchar(200)`	200
EmailAddress	`DT_WSTR`	`nvarchar(200)`	200
AccountId	`DT_WSTR`	`nvarchar(150)`	150
AccountType	`DT_WSTR`	`nvarchar(50)`	50
Active	`DT_BOOL`	`bit`
Locale	`DT_WSTR`	`nvarchar(50)`	50
Self	`DT_WSTR`	`nvarchar(150)`	150
AvatarUrls48x48	`DT_WSTR`	`nvarchar(500)`	500
AvatarUrls24x24	`DT_WSTR`	`nvarchar(500)`	500
AvatarUrls16x16	`DT_WSTR`	`nvarchar(500)`	500
AvatarUrls32x32	`DT_WSTR`	`nvarchar(500)`	500

If the column you are looking for is missing, consider customizing Jira Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Description
Password	`DT_WSTR`	`nvarchar(50)`	50	If password is not supplied, random one is generated
EmailAddress	`DT_WSTR`	`nvarchar(200)`	200
DisplayName	`DT_WSTR`	`nvarchar(200)`	200

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 Users table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to create user:

API Destination - Jira

Jira connector can be used to read, write, delete Issues, Users, Worklogs, Comments, Projects, Custom fileds and many other details

Jira

Users

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 User

Inserts a single user

INSERT INTO Users(EmailAddress, DisplayName, Name, Password)
VALUES ('my@user.com', 'John Doe', 'John', 'xhedkspstdadaothoua')
WITH (OUTPUT=1)

create_user endpoint belongs to Users 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 User

Inserts a single user

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Users(EmailAddress, DisplayName, Name, Password)
VALUES (''my@user.com'', ''John Doe'', ''John'', ''xhedkspstdadaothoua'')
WITH (OUTPUT=1)';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

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