Endpoint

Create User

Name

create_user

Description

No description available

Related Tables

Users

Parameters

Parameter	Label	Required	Options	Description
There are no parameters

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
DisplayName	`DT_WSTR`	`nvarchar(200)`	200	`False`
EmailAddress	`DT_WSTR`	`nvarchar(200)`	200	`False`
AccountId	`DT_WSTR`	`nvarchar(150)`	150	`False`
AccountType	`DT_WSTR`	`nvarchar(50)`	50	`False`
Active	`DT_BOOL`	`bit`		`False`
Locale	`DT_WSTR`	`nvarchar(50)`	50	`False`
Self	`DT_WSTR`	`nvarchar(150)`	150	`False`
AvatarUrls48x48	`DT_WSTR`	`nvarchar(500)`	500	`False`
AvatarUrls24x24	`DT_WSTR`	`nvarchar(500)`	500	`False`
AvatarUrls16x16	`DT_WSTR`	`nvarchar(500)`	500	`False`
AvatarUrls32x32	`DT_WSTR`	`nvarchar(500)`	500	`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
Password	`DT_WSTR`	`nvarchar(50)`	50	`False`	If password is not supplied, random one is generated
EmailAddress	`DT_WSTR`	`nvarchar(200)`	200	`False`
DisplayName	`DT_WSTR`	`nvarchar(200)`	200	`False`

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 Users table using API Destination

This Endpoint belongs to Users table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Jira

Users

Insert

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