# Jira

[Jira](https://www.atlassian.com/software/jira) is an issue tracking solution with bug tracking, issue tracking, and project management functions.

**Data integration**: Skyvia supports importing data to and from Jira, exporting Jira data to CSV files, replicating Jira data to relational databases, and synchronizing Jira data with other cloud apps and relational databases.

**Backup**: Skyvia Backup supports Jira backup.

**Query**: Skyvia Query supports Jira.

## Terminology

**Jira API versions**. Version 2 and version 3 offer the same collection of operations. However, version 3 provides support for the [Atlassian Document Format](https://developer.atlassian.com/cloud/jira/platform/apis/document/structure/) (ADF) in:
* ```body``` in comments, including where comments are used in issue, issue link, and transition resources.
* ```comment``` in worklogs.
* ```description``` and ```environment``` fields in issues.
* ```textarea``` type custom fields (multi-line text fields) in issues. Single line custom fields (textfield) accept a string and don't handle Atlassian Document Format content.

## Establishing Connection

Skyvia supports Jira Cloud and Jira Server connections. You may connect to Jira Cloud through API versions 2.0 and 3.0 with OAuth and Basic authentication. Jira server connection provides Basic authentication only.

### Getting Credentials

To connect to the Jira instance you need to fill out **Site** field, your Jira user name, and **API token**.

* **Site** is a public IP address of your Jira instance or its DNS analog. Copy its value from the address bar. It should look like https://yourcompanyname.atlassian.net.
* You can manage your Atlassian **API tokens** on the [Atlassian Token Management](https://id.atlassian.com/manage/api-tokens) page. Refer to [Atlassian API Tokens Documentation]() in case of any questions.

### Creating Connection

[Creating a connection](https://docs.skyvia.com/connections/#creating-connections) to Jira may slightly differ depending on whether you connect to Jira Server or Jira Cloud.

#### Jira Server Connection


1. Enter your **Site** address.
2. Select **Server** in the **Environment** dropdown.
3. Enter your user name and API token. You can manage your Atlassian API tokens [here](https://id.atlassian.com/manage/api-tokens).
4. Click **Create Connection**.

#### Jira Cloud Connection


1. Enter your **Site** address.
2. Select **Cloud** in the **Environment** dropdown.
3. Choose the preferred API version.
4. Choose the Authentication type. If you choose **Basic**, enter your Jira login and password. If you choose **OAuth**, login with your Jira account, your access token will be applied automatically.
5. Click **Create Connection**.

## Connector Specifics

### Object Peculiarities

Some of the Jira objects can be accessed only via their parent objects. For example, to query *ProjectComponents, ProjectStatuses, ProjectProperties* and *ProjectVersions* objects, Jira API requires the id of the corresponding project.

Skyvia does not require id of the parent object from the user. If you don’t specify the ids of the parent objects, Skyvia will query all parent objects and get their ids. Then, it will query child objects for parent object records. This allows querying child objects without knowing their parents. However, this method takes a lot of time and consumes many API calls. It uses at least one API call for every parent object even if this object does not have any child records.

It is strongly recommended to use filters on the parent object fields when querying data from child objects. This limits the number of parent object records, for which child object data must be queried.

### Incremental Replication and Synchronization

Incremental Replication requires the object to have either *CreateDate* or *UpdatedDate* field. Synchronization requires both fields.

### DML Operations

Skyvia supports the following DML operations for Jira objects:

| Operations | Objects |
| ---------- | ------- |
| **INSERT, UPDATE, DELETE** | *Filters*, *IssueComments*, *IssueLinkTypes*, *Issues*, *IssueTypes*, *IssueWorklogs*, *PermissionSchemes*,*ProjectCategories*, *ProjectComponents*, *ProjectRoles*, *Projects*, *ScreenTabs* |
| **INSERT, UPDATE** | *ProjectVersions* |
| **INSERT, DELETE** | *SharePermissions* |
| **INSERT** | *ApplicationProperties*, *Groups*, *IssueFields*, *IssueVotes*, *IssueWatchers*, *ScreenTabFields* |

## Supported Actions

Skyvia supports all the [common actions](https://docs.skyvia.com/data-integration/actions.html#common-actions) for Jira.