Table Users

Parameters

Supported Operations

Examples

SSIS

Use Jira Connector in API Source component to read data or in API Destination component to read/write data:

Read from Users table using API Source

Jira

Users

Read/write to Users table using API Destination

Jira

Users

Select

ODBC application

Use these SQL queries in your ODBC application data source:

List users

Lists all available users

SELECT * FROM Users

INSERT User

Inserts a single user

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

DELETE User

Deletes a single user

DELETE FROM Users
WITH (OUTPUT=1, accountId = '547059:136095a0-XXXX-XXXX-XXXX-3e4c66f26551', ContinueOn404Error=0)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

List users

Lists all available users

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Users';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_JIRA_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 [LINKED_SERVER_TO_JIRA_IN_DATA_GATEWAY];

DELETE User

Deletes a single user

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Users
WITH (OUTPUT=1, accountId = ''547059:136095a0-XXXX-XXXX-XXXX-3e4c66f26551'', ContinueOn404Error=0)';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_JIRA_IN_DATA_GATEWAY];