Endpoint

Delete User

Name

delete_user

Description

No description available

Related Tables

Users

Parameters

Parameter	Label	Required	Options	Description
AccountId	AccountId	NO

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Response	`DT_NTEXT`	`nvarchar(MAX)`		`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
AccountId	`DT_WSTR`	`nvarchar(4000)`	4000	`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:

Delete rows from 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

Delete

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Delete user

SELECT * FROM delete_user

DELETE User

Deletes a single user

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

delete_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:

Delete user

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

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

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