SSIS Components for Jira

Build 26.0.9770

Roles

Lists all roles configured in Jira, such as 'Service Desk Team' or 'Project Manager'.

Table-Specific Information

SELECT

The component uses the Jira API to process filters based on the Id column. The component processes all other filters client-side.

For example, the following queries are processed server-side:

SELECT * FROM Roles WHERE Id = '10002';

INSERT

Insert a role by specifying the Name column.
INSERT INTO Roles(Name, Description) VALUES ('Custom Role 1', 'My custom role 1.')

UPDATE

Update a role by specifying the Id column and the columns to update.
UPDATE Roles SET Description = 'test_updated', Name = 'test_updated' WHERE Id = 10002

DELETE

Delete a role by specifying the Id.
DELETE FROM Roles WHERE Id = '10002'

Columns

Name Type ReadOnly References SupportedOperators Platform Description
Id [KEY] Long False = Common

The unique identifier of the role within the Jira instance.

Name String False Common

The name of the project role, such as 'Developers', 'Administrators', or 'Users'.

Description String False Common

A textual explanation of the purpose or responsibilities associated with the role.

Actors String False Common

A list of users and groups assigned to this role, either by default or per project.

Scope String False Cloud

Defines the scope at which the role is applicable, such as global or project-specific.

IsAdmin Boolean False Cloud

Indicates whether this role is designated as the administrator role for the associated project.

IsDefault Boolean False Cloud

Indicates whether this role is automatically assigned to users by default for new projects.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770