Jira

Jira is an agile software development project management tool that supports methodologies such as Kanban and Scrum.

Through its boards, it is possible to plan, track and manage the progress of projects, visualizing those responsible for each task and the time/effort required to complete them.

With the data generated in Jira, it is possible to generate the most different analyses, among them the speed and burn down of the team (number of tasks remaining in the project X the time left to complete them), tracking the changes made to each task and how it is progressing in the kanban/board phases, the time taken to resolve issues, among many others.

Adding the data source

To build your Jira pipeline, start by adding the data source on the Kondado platform, following the steps below:

1) Access the link below to enter your Jira account administration page:

https://id.atlassian.com/manage/api-tokens

2) After logging in with an admin account, click the create API token button;

3) Give your token a name (e.g. “Kondado Integration”) and click “Create”;

4) After clicking create, a pop-up will appear with your new token. Write it down in a safe place;

5) On the Kondado platform, go to the add new sources page and select the Jira data source;

6) Fill in the new connector information as below:

Name: the name of your data source on the Kondado platform. For example, “Jira engineering”

User: email of the user who generated the token according to the previous steps

Token: the token generated according to the previous steps

Account ID: Your Jira subdomain. For example, if your Jira address is https://company.atlassian.net, your account ID will be “company”

7) Click Save to add your new data source!

Pipelines

Summary

Projects
Status
Issues
Changelog
Boards
Boards: columns settings
Boards: related issues
Issues Worklogs
Issues custom fields
Boards: sprints
Sprints: related issues

Relationship chart

Click here to see the relationship chart for this data source

Projects

Field	Type
id	int	[en] The key of the project
key	text	[en] The key of the project
description	text	[en] A brief description of the project
simplified	boolean	[en] Whether the project is simplified.
style	text	[en] The type of the project.
name	text	[en] The name of the project.
lead__displayname	text	[en] The display name of the project lead. Depending on the user’s privacy setting, this may return an alternative value.
lead__active	boolean	[en] Whether the project lead is active.
lead__accountid	text	[en] The account ID of the project lead, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5.
projecttypekey	text	[en] The project type of the project.
isprivate	boolean	[en] Whether the project is private.

Status

Field	Type
id	int	[en] The ID of the status
statuscategory__name	text	[en] The name of the status category
statuscategory__id	int	[en] The ID of the status category
statuscategory__key	text	[en] The key of the status category
description	text	[en] The description of the status
name	text	[en] The name of the status

Issues

Campo	Tipo
id	int	[en] The ID of the issue
key	text	[en] The key of the issue
fields__duedate	date	[en] The date by which this issue is scheduled to be completed
fields__labels	text	[en] Labels to which this issue relates
fields__progress__progress	float
fields__progress__total	float
fields__statuscategorychangedate	timestamp	[en] Reflects changes to the statuscategory
fields__resolution__description	text	[en] A description of the issue's resolution, if the issue has been resolved or closed
fields__resolution__id	int	[en] ID of the issue's resolution, if the issue has been resolved or closed
fields__resolution__name	text	[en] Name of the issue's resolution, if the issue has been resolved or closed
fields__status__id	int	[en] The Id of the status the issue is currently at in its lifecycle (workflow) Status > > id
fields__status__statuscategory__id	int
fields__status__statuscategory__key	text
fields__status__statuscategory__name	text
fields__status__description	text	[en] The description of the status the issue is currently at in its lifecycle (workflow)
fields__status__name	text	[en] The name of the status the issue is currently at in its lifecycle (workflow)
fields__updated	timestamp	[en] The time and date on which this issue was last edited.
fields__description	text	[en] A detailed description of the issue.
fields__creator__displayname	text
fields__creator__name	text
fields__creator__emailaddress	text
fields__creator__key	text
fields__creator__active	boolean
fields__creator__accountid	text
fields__assignee__accountid	text
fields__assignee__displayname	text
fields__assignee__emailaddress	text
fields__lastviewed	timestamp
fields__summary	text	[en] A brief one-line summary of the issue
fields__reporter__displayname	text
fields__reporter__name	text
fields__reporter__emailaddress	text
fields__reporter__key	text
fields__reporter__active	boolean
fields__reporter__accountid	text
fields__aggregatetimespent	float
fields__votes__hasvoted	boolean
fields__votes__votes	int	[en] The number shown indicates how many votes this issue has
fields__aggregatetimeoriginalestimate	text	[en] The Original Estimate of the total amount of time required to resolve the issue, as estimated when the issue was created
fields__created	timestamp	[en] The time and date on which this issue was entered into Jira
fields__resolutiondate	timestamp	[en] A record of the issue's resolution, if the issue has been resolved or closed.
fields__timeestimate	float	[en] A record of the issue's resolution, if the issue has been resolved or closed.
fields__project__projecttypekey	text
fields__project__id	int	Projetos > > id
fields__project__key	text
fields__project__name	text
fields__timespent	float
fields__issuetype__subtask	boolean
fields__issuetype__id	int
fields__issuetype__name	text
fields__issuetype__description	text
fields__workratio	float
fields__priority__name	text
fields__priority__id	int
parent_issue_id	int	[en] The ID of the parent issue
parent_issue_key	text	[en] The key of parent the issue

Changelog

Main object

Field	Type
id	text	[en] The ID of the changelog
created	text	[en] The date on which the change took place – formated as a text with timezone
idissue	text	[en] The ID of the issue Issues > > id
author__active	boolean	[en] Whether the author (The user who made the change) is active
author__displayname	text	[en] The display name of the author (The user who made the change). Depending on the user’s privacy settings, this may return an alternative value
author__emailaddress	text	[en] The email address of the author (The user who made the change). Depending on the user’s privacy settings, this may be returned as null
author__name	text

jira_changelog__items

Field	Type
changelog_id	text	[en] The ID of the changelog (kondado: inherited from main table)
items__from	text	[en] The details of the original value
items__to	text	[en] The details of the new value
items__fromstring	text	[en] The details of the original value as a string
items__tostring	text	[en] The details of the new value as a string
items__field	text	[en] The name of the field changed
items__fieldtype	text	[en] The type of the field changed
items__fieldid	text	[en] The ID of the field changed

Boards

Field	Type
id	text	[en] The ID of the board
self	text	[en] The URL of the board
location__displayname	text
location__name	text
location__projectid	text	Projects > > id
location__projecttypekey	text
location__projectname	text
location__projectkey	text
type	text	[en] The type the board
name	text	[en] The name of the board

Boards: columns settings

Main object

Field	Type
name	text	[en] Name of the board
board_id	text	[en] ID of the board Boards > > id

Field

Type

name

text

[en] Name of the board

board_id

text

[en] ID of the board

Boards > > id

jira_board_columns__statuses

Field	Type
board_id	text	[en] ID of the board (Kondado: inherited from top-level table)
column_name	text	[en] Name of the board (Kondado: inherited from top-level table)
statuses__self	text	[en] URL of the status
statuses__id	text	[en] ID of the status Status > > id

Boards: related issues

Field	Type
issue_id	text	[en] The ID of the issue Issues > > id
board_id	text	[en] The ID of the board that contains the issues Boards > > id
issue_key	text	[en] The key of the issue

Field

Type

issue_id

text

[en] The ID of the issue

Issues > > id

board_id

text

[en] The ID of the board that contains the issues

Boards > > id

issue_key

text

[en] The key of the issue

Issues Worklogs

Field	Type
issueid	float	[en] The ID of the issue this worklog is for Issues > > id
id	float	[en] The ID of the worklog record
comment	text	[en] A comment about the worklog in Atlassian Document Format
updateauthor__displayname	text	[en] The display name of the user who last updated the worklog. Depending on the user’s privacy settings, this may return an alternative value
updateauthor__name	text
updateauthor__accounttype	text	[en] The type of account represented by this user who last updated the worklog. This will be one of 'atlassian' (normal users), 'app' (application user) or 'customer' (Jira Service Desk customer user)
updateauthor__key	text
updateauthor__active	boolean	[en] Whether the user who last updated the worklog is active
updateauthor__timezone	text	[en] The time zone specified in the user who last updated the worklog's profile. Depending on the user’s privacy settings, this may be returned as null
updateauthor__accountid	text	[en] The account ID of the user who last updated the worklog, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5
timespent	text	[en] The time spent working on the issue as days (#d), hours (#h), or minutes (#m or #
author__displayname	text	[en] The display name of the user who created the worklog. Depending on the user’s privacy settings, this may return an alternative value
author__name	text
author__accounttype	text	[en] The type of account represented by this user who created the worklog. This will be one of 'atlassian' (normal users), 'app' (application user) or 'customer' (Jira Service Desk customer user)
author__key	text
author__active	boolean	[en] Whether the user who created the worklog is active
author__timezone	text	[en] The time zone specified in the user who created the worklog's profile. Depending on the user’s privacy settings, this may be returned as null
author__accountid	text	[en] The account ID of the user who created the worklog, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5
started	timestamp	[en] The datetime on which the worklog effort was started
created	timestamp	[en] The datetime on which the worklog was created
timespentseconds	float	[en] The time in seconds spent working on the issue
updated	timestamp	[en] The datetime on which the worklog was last updated

Issues custom fields

Field	Type
issue_id	int	[en] The ID of the issue Issues > > id
issue_key	text	[en] The Key of the issue
custom_field_key	text	[en] The ID or key of the custom field, for example customfield_10000
custom_field_value	text	[en] The value for the custom field (coerced to text by Kondado)

Boards: sprints

Field	Type
board_id	text	[en] The ID of the board that contains the requested sprints Boards > > id
originboardid	text	[en] The ID of the board that contains the requested sprints (returned when board_id is missing)
startdate	timestamp	[en] The start date of the sprint
state	text	[en] The state of the sprint (ie: active, closed, etc)
enddate	timestamp	[en] The end date of the sprint
name	text	[en] The name of the sprint
goal	text	[en] The goal of the sprint
self	text	[en] The URL of the sprint
id	text	[en] The ID of the sprint
completedate	timestamp	[en] The date the sprint was completed

Sprints: related issues

Field	Type
sprint_id	text	[en] The ID of the sprint Boards: sprints > > id
issue_id	text	[en] The ID of the issue Issues > > id

Field

Type

sprint_id

text

[en] The ID of the sprint

Boards: sprints > > id

issue_id

text

[en] The ID of the issue

Issues > > id