Jira Service Management

Jira Service Management is Atlassian’s service management solution for IT and service teams. It is built on Jira, it encompasses deeper service management practices across service request, incident, problem, change, knowledge, asset, and configuration management.

Data integration: Skyvia supports importing data to and from Jira Service Management, exporting data from Jira Service Management to CSV files and replicating data from Jira Service Management to relational databases.

Backup: Skyvia Backup does not support Jira Service Management.

Query: Skyvia Query supports Jira Service Management.

Establishing Connection

To create a connection to Jira Service Management, you need to enter site and log in to Jira Service Management via OAuth 2.0.

Creating Connection

To create a Jira Service Management connection, perform the following steps:

  1. Paste your Jira domain to the Site field, which you can find in your Jira account profile.

    Connection Editor window

  2. Click Sign In with Jira Service Management.

  3. In the opened window, enter your Atlassian credentials used when registering in Jira and click Log in.

    Signing in to Jira

  4. Select the Site that you need to access from Skyvia.

    Signing in to Jira

  5. Click Accept.

Connector Specifics

Object Peculiarities

RequestParticipants

The RequestParticipants object has the AccountIds field with the JsonArray type. This field is used for import only, and it does not return any data. It is a required field. When importing data to the AccountIds field, provide a value in the following format:

1
2
3
4
5
6
7
8
9

[

"qm:a713c8ea-1075-4e30-9d96-891a7d181739:5ad6d3581db05e2a66fa80b",

"qm:a713c8ea-1075-4e30-9d96-891a7d181739:5ad6d3a01db05e2a66fa80bd",

"qm:a713c8ea-1075-4e30-9d96-891a7d181739:5ad6d69abfa3980ce712caae"

]

Incremental Replication and Synchronization

The following objects support replication with incremental updates: RequestApprovals, RequestAttachments, RequestCommentAttachments, Requests, RequestComments, RequestInQueues. Note that all Jira Service Management objects don’t have the UpdatedDate field, and thus, only the new records are detected. Updated records are not detected.

Synchronization is not supported for Jira Service Management.

DML Operations Support

Operation Object
INSERT, DELETE Customers, Organizations, RequestFeedbacks
UPDATE, DELETE OrganizationProperties, RequestTypeProperties
INSERT RequestAttachments, RequestComments, RequestParticipants, Requests, RequestTransitions
UPDATE RequestApprovals

Stored Procedures

Skyvia represents part of the supported Jira Service Management features as stored procedures. You can call a stored procedure, for example, as a text of the command in the ExecuteCommand action in a Target component of a Data Flow or in Query.

AddUsersToOrganization

Use the following command to add records to the OrganizationUsers objects.

call AddUsersToOrganization(:organizationId, :accountIds)

PARAMETER NAME DESCRIPTION
OrganizationId Id of the organization to add users to
AccountIds A JSON array of account IDs to add to the organization

An example of calling the stored procedure:

call AddUsersToOrganization(1, '["qm:a713c8ea-1075-4e30-9d96-891a7d181739:5ad6d3581db05e2a66fa80b","qm:a713c8ea-1075-4e30-9d96-891a7d181739:5ad6d3a01db05e2a66fa80bd","qm:a713c8ea-1075-4e30-9d96-891a7d181739:5ad6d69abfa3980ce712caae"]')

SubscribeToRequestNotifications

Use the following command to subscribe to request notifications.

call SubscribeToRequestNotifications(:issueId)

UnsubscribeToRequestNotifications

Use the following command to unsubscribe to request notifications.

call UnsubscribeToRequestNotifications(:issueId)

RemoveRequestParticipants

Use the following command to remove records from the RequestParticipants object.

call RemoveRequestParticipants(:issueId, :accountIds)

PARAMETER NAME DESCRIPTION
issueId Id of the issue to remove participants for.
accountIds A JSON array of account IDs that are removed from the participant list. You can see an example value for this parameter above, in the description of the AddUsersToOrganization procedure.

PerformCustomerRequestTransition

Use the following command to perform the specified customer transition for the specified request (add a record to the RequestTransitions object).

call PerformCustomerRequestTransition(:issueId, :id)

PARAMETER NAME DESCRIPTION
issueId Id of the issue to perform a transition of.
id Id of the transition to perform.

RemoveCustomers

Use the following command to remove customers from the service desk. The service desk must have closed access. Specified customers not having access to the specified service desk are ignored by this procedure.

call RemoveCustomers(:serviceDeskId,:accountIds)

PARAMETER NAME DESCRIPTION
serviceDeskId Id of the service desk to remove customers from.
id A JSON array of customer IDs that are removed from the specified service desk.

Supported Actions

Skyvia supports all the common actions for Jira Service Management.

On This Page