# Jira

### Snapshot

| Features                   | Details                                                  |
| -------------------------- | -------------------------------------------------------- |
| Release Status             | Beta                                                     |
| Source API Version         | v3                                                       |
| Table Selection            | Yes                                                      |
| Column Selection           | Yes                                                      |
| Edit Integration           | Yes                                                      |
| Replication Type Selection | No                                                       |
| Authentication Parameters  | <p>Jira account login email<br>Jira account password</p> |
| Replication Type           | Full Replication                                         |
| Replication Key            | NA                                                       |

Suggested Replication Frequency: 24 hrs

| Tables/APIs Supported |                 |
| --------------------- | --------------- |
| Projects              | ProjectCategory |
| ProjectType           | Resolution      |
| ProjectRoles          | Issues          |

### Integrate Jira with Daton

1. Signin to Daton&#x20;
2. Select Jira from Integrations page
3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later&#x20;
4. You will be redirected to Jira login for authorizing Daton to extract data periodically
5. Post successful authentication, you will be prompted to choose from the list of available tables
6. Then select all required fields for each table
7. Submit the integration

### Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
2. Users would be able to edit/pause/re-activate/delete integration anytime
3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

### Jira Data

**Projects**

Purpose: Returns projects visible to the user.

Source API Documentation  <https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-project-search-get>

Replication: Full Replication

Replication Key: NA

**Fields**

| Name           | Target Datatype |
| -------------- | --------------- |
| self           | STRING          |
| id             | STRING          |
| key            | STRING          |
| name           | STRING          |
| projectTypeKey | STRING          |
| simplified     | BOOLEAN         |
| style          | STRING          |
| isPrivate      | BOOLEAN         |

**ProjectCategory**

Purpose: Returns all project categories.

Source API Documentation  <https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-projectCategory-get>

Replication: Full Replication

Replication Key: NA

**Fields**

| Name        | Target Datatype |
| ----------- | --------------- |
| self        | STRING          |
| id          | STRING          |
| name        | STRING          |
| description | STRING          |

**ProjectType**

Purpose: Returns all project categories.

Source API Documentation  <https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-project-type-get>

Replication: Full Replication

Replication Key: NA

**Fields**

| Name               | Target Datatype |
| ------------------ | --------------- |
| key                | STRING          |
| formattedKey       | STRING          |
| descriptionI18nKey | STRING          |
| color              | STRING          |

**Resolution**

Purpose: Returns a list of all issue resolution values.

Source API Documentation  <https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-resolution-get>

Replication: Full Replication

Replication Key: NA

**Fields**

| Name        | Target Datatype |
| ----------- | --------------- |
| self        | STRING          |
| id          | STRING          |
| description | STRING          |
| name        | STRING          |

**ProjectRoles**

Purpose: Project roles are a flexible way to to associate users and groups with projects. Jira Cloud, the list of project roles is shared globally with all projects, but each project can have a different set of actors associated with it. Returns all project roles and the details for each role. Note that the list of project roles is common to all projects.

Source API Documentation  [https://developers.Jira.com/Jira-api-reference/reference#list-companies](https://developers.jira.com/Jira-api-reference/reference#list-companies)

Replication: Full Replication

Replication Key: NA

**Fields**

| Name        | Target Datatype |
| ----------- | --------------- |
| self        | STRING          |
| name        | STRING          |
| id          | INTEGER         |
| description | STRING          |

**Issues**

Purpose: Returns a list of all issues.

Source API Documentation  <https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-search-get>

Replication: Full Replication

Replication Key: NA

**Fields**

| Name   | Target Datatype |
| ------ | --------------- |
| id     | STRING          |
| key    | STRING          |
| fields | RECORD          |