Experimente nossa plataforma

Jira

O Jira é uma ferramenta de gerenciamento ágil de projetos de desenvolvimento de software, que suporta metodologias como Kanban e Scrum.

Através dos seus boards, é possível planejar, rastrear e gerenciar o andamento de projetos, visualizando os responsáveis por cada tarefa e o tempo/esforço necessário para completá-las.

Com os dados gerados no Jira, é possível gerar as mais diferentes análises, dentre elas a velocidade e o burn down da equipe (quantidade de tarefas restantes no projeto X o tempo faltante para completá-las) , rastrear as modificações feitas em cada tarefa e como está o andamento dela nas fases do kanban/board, o tempo de resolução das issues, dentre várias outras.

Adicionando o conector

Para construir a sua integração do Jira, inicie adicionando o conector na plataforma da Kondado, seguindo os passos abaixo:

1) Acesse o link abaixo para entrar na página de administração da sua conta do Jira

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

2) Após fazer login com uma conta de administrador, clique no botão de criar token de API

3) Dê um nome para o seu token (por exemplo, “Integração Kondado” e clique em “Create”

4) Após clicar em criar, um pop-up irá aparecer com o seu novo token. Anote ele em um lugar seguro

5) Na plataforma da Kondado, vá para a seção de adicionar novos conectores e selecione o conector do Jira

6) Preencha as informações do novo conector conforme abaixo:

  • Nome: o nome do seu conector na plataforma da Kondado. Por exemplo “Jira engenharia”
  • Usuário: e-mail do usuário que gerou o token conforme os passos anteriores
  • Token: o token gerado conforme os passos anteriores
  • Subdomínio: o seu subdomínio do Jira. Por exemplo, se o seu endereço do jira é https://empresa.atlassian.net, o seu ID da conta será “empresa“

Clique em Salvar para adicionar o seu novo conector

Integrações

Índice

Gráfico de relacionamento

Clique para ampliar

Projetos

Campo Tipo

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

Campo Tipo

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

Objeto principal

Campo Tipo

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

Campo Tipo

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

Campo Tipo

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

    Projetos > > 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: configuração das colunas

Objeto principal

Campo Tipo

name

text

[en] Name of the board

board_id

text

[en] ID of the board

    Boards > > id

jira_board_columns__statuses

Campo Tipo

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: relacionamento com issues

Campo Tipo

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

Campo Tipo

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

Campo Tipo

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

Campo Tipo

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: relacionamento com issues

Campo Tipo

sprint_id

text

[en] The ID of the sprint

    Boards: sprints > > id

issue_id

text

[en] The ID of the issue

    Issues > > id