SSIS Components for Jira

Build 25.0.9434

Roles

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

Select

The component will use the Jira API to process filters that refer to Id while the rest of the filter is executed client side within the component. The Jira APIs support filters using the equals (=) operator with Id.

For example, the following queries are processed server side:

Retrieve all the available Roles:

SELECT * FROM Roles

Retrieve a specific Role:

SELECT * FROM Roles WHERE Id = '10002'

Update

Update the role name and description by specifying the role Id

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

If the value is 'true', this role is designated as the administrator role for the associated project. If the value is 'false', it is not an admin role.

IsDefault Boolean False Cloud

If the value is 'true', this role is automatically assigned to users by default for new projects. If the value is 'false', it is not a default role.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434