I am unable to get link of JIRA issue using python

Question

#Provide your login credentials
jira = JIRA(options, basic_auth=(login, pwd))

issue = jira.issue('ABC-1234')

print (issue.id) #1162223 is returned (which is correct)

Approach 1:

print (jira.issue_link(issue.id)) # I get error id does not exists

Approach 2:

print (issue.fields.issuelinks) # here I get [] as the output. How do I proceed further if I have to take this path

Purpose: I am generating report for a JIRA project from python. Instead of getting key as text for JIRA issues, I want link such that when I click on the JIRA issue it takes me to the JIRA ticket in the project.

Please help!

Jeelben Manojbhai Bhuptani · Answer

Hi @Tushar Mishra ,

I am trying the same thing in python , I found the solution -

url = "https://jira.mycompany.com/jira/browse/"

issue_link = f'=HYPERLINK("{url}","issue.key")'

df = pd.DataFrame(issue_link)
df.to_excel('QA_OpenIssues.xlsx', index=False)

Payne · Answer

In that case, use the hyperlink function in Excel. Try outputting your data like this:

url = "=hyperlink(\"https://jira.mycompany.com/browse/" + i.key + "\",\"" + i.key + "\")"

Tushar Mishra_mlnx43 · Answer

Code as suggested: url = "" + i.key + "" sheet.write(rowCount,0,url) Output in excel ABC-1234 and not ABC-1234 What am I missing? I am writing into excel where it should appear as hyperlink.