JIRA Step by Step

Last updated 12 days ago

Using LLodi with JIRA is so easy!

Create an Issue from your Qlik Script

Create your Qlik Sense Script

//Introduce your values
LET projectId = '10404';
LET issueType = '10000';
LET assignee = 'nacho.bibian';
LET reporter = 'juan.hortal';
LET priority = '1';
LET description = 'This is the description of this new Issue created by LLodi';
LET summary = 'The name of my new Issue';
//Some other configuration values
LET llodiAuth = 'Name';
LET yourJIRA = 'yourJIRA'; //as in https://yourJIRA.atlassian.net
LET agentURL = 'yourAgent.com'; //your server's URL
LET agentPort = '8089';
LET agentProtocol = 'https'; //http or https if you have added a certificate
LIB CONNECT TO 'LLodi Writer Connector';
[New Issue]:
LOAD *;
SELECT
WITH FIELDS (
{
"fields":
{
"project":
{
"id":"$(projectId)"
},
"issuetype":
{
"id":"$(issueType)"
},
"assignee":
{
"name":"$(assignee)"
},
"reporter":
{
"name":"$(reporter)"
},
"priority":
{
"id":"$(priority)"
},
"description":"$(description)",
"summary":"$(summary)"
}
}
)
WITH CONNECTION (
url "$(agentProtocol)://$(agentURL):$(agentPort)/proxy?https://$(yourJira).atlassian.net/rest/api/2/issue/",
method "POST",
httpheader "X-Atlassian-Token" "no-check",
httpheader "content-type" "application/json",
httpheader "llodi-auth" "$(llodiAuth)"
)
WITH CONFIG(directpayload "true")
;

Result Qlik Table

For more information on the LLodi Connector.

Create an Issue from your Qlik Dashboard

Create your form

Create a new custom Form, choose a name and add some tags.

Form Url

{your agent URL}/proxy?https://{JIRA-workspace}.atlassian.net/rest/api/2/issue/

Headers

Header

Value

Content-Type

application/json

X-Atlassian-Token

no-check

Authorization

Basic {Base64 encoded username:password}

Check here Basic Authorization details for JIRA

Form Fields

Field ID

Label

Type

LLodi Field

Action

Value

Require Condition

Reporter

Reporter

Select

LLodi 1

Split CSV List

assignee

Asignee

Select

LLodi 2

Split CSV List

title

Title

Text

LLodi 20

description

Description

Text Area

labels

Labels

Hidden

priority

Priority

Select

LLodi 3

Split CSV List

project

Project

Read Only

LLodi 4

issueType

Issue Type

Select

LLodi 5

Split CSV List

originalEstimate

Time Estimate

Hidden

Advanced JSON

Copy this JSON into the modal "Copy JSON".

{
"fields": {
"project": {
"id": ""
},
"issuetype": {
"id": ""
},
"assignee": {
"name": ""
},
"reporter": {
"name": ""
},
"priority": {
"id": ""
},
"description": "description",
"summary": ""
}
}

Field ID

Alias

project

id

issueType

id

assignee

name

reporter

name

priority

id

title

summary

LLodi Fields Values

LLodi Field

Value

LLodi 1

=concat({1} distinct Reporter&'|'&reporter_key,',')

LLodi 2

=concat({1} distinct [Assignee]&'|'&assignee_key,',')

LLodi 3

=concat({1} distinct [with Priority]&'|'&P_Value,',')

LLodi 4

=[Project ID]

LLodi 5

=concat({1} distinct [with Type]&'|'&Type_id,',')

LLodi 20

=true()

Comment an Issue from your Qlik Dashboard

Create your form

Create a new custom Form, choose a name and add some tags.

Form Url

{your agent URL}/proxy?https://{JIRA-workspace}.atlassian.net/rest/api/2/issue/{issueKey}/comment

Headers

Header

Value

Content-Type

application/json

X-Atlassian-Token

no-check

Authorization

Basic {Base64 encoded username:password}

Form Fields

Field ID

Label

Type

LLodi Field

Action

i

Issue Key

Read Only

LLodi 1

None

user

User

Select

LLodi 2

Split CSV List

body

Message

Text Area

None

None

Dynamic Request

Field ID

LLodi Field

issueKey

LLodi 1

This Dynamic Request Field is used in the Form URL, you can select it in the arrow in the right side of the field.

Advanced JSON

Copy this JSON into the modal "Copy JSON".

{
"author": {
"key": ""
},
"body": ""
}
Note that you have to add the alias "key" to the field user to match the API requirements.

LLodi Fields Values

LLodi Field

Value

LLodi 1

=if(count(distinct issueKEY)=1,issueKEY,'Select one Issue')

LLodi 2

=concat({1} distinct Reporter&'|'&reporter_key,',')