Jira
Features | Details |
Release Status | Beta |
Source API Version | v3 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Jira account login email Jira account password |
Replication Type | Full Replication |
Replication Key | NA |
Suggested Replication Frequency: 24 hrs
Tables/APIs Supported | ​ |
Projects | ProjectCategory |
ProjectType | Resolution |
ProjectRoles | Issues |
Signin to Daton
Select Jira from Integrations page
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
You will be redirected to Jira login for authorizing Daton to extract data periodically
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
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
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
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​
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 |