Get fields like Closing Reason, Root Cause, Environment from JIRA using Rest V2 API

[soumya awasthi]

Hi,

I am working on JIRA Bug Analysis. I am accessing JIRA using REST V2 APIs using JQL like 

issueType=Bug AND Status in (Done, Completed) AND project in(x, y, z). I am getting result back like summary and description but I also need information like Root cause, Closing reason. How can I have those.

I am using Python language. Can you help.

Thank you in advance.

[Trudy Claspill · Accepted solution]

Hello @soumya awasthi 

Welcome to the Atlassian community.

Which API endpoint are you calling, specifically?

[soumya awasthi]

Hi Trudy,

Below is my the endpoint and my request.

url = f"{base_url}/rest/api/2/issue"

response = requests.get(url, headers=headers, params=query)

I have tried query like - 

query = {

  'jql': 'project= project'

}

and 

query = {

'jql': 

"issueType=Bug AND Status in (Done, Completed) AND Project in('p1', 'p2', 'p3')

}

[Trudy Claspill]

I think you need to use this endpoint instead, and look at the fields parameter that are available for that API endpoint.

https://developer.atlassian.com/cloud/jira/platform/rest/v2/api-group-issue-search/#api-rest-api-2-search-get

[soumya awasthi]

I checked, but this fields parameter doesn't have all data like closing reason, root cause.

I want to access all the fields which we get when we Export-> Excel(all fields) option from the JIRA UI.

For predictive analysis of bug these features are crucial.

Thank you in advance.

[soumya awasthi]

Hi Trudy,

Thank you. I was able to identify the field. It was the custom field.

[Trudy Claspill]

You're welcome.

If my responses helped you solve your requirement, please consider clicking on the Accept Answer button to mark your Question as Solved.

[soumya awasthi]

Hi Trudy,

Below is my the endpoint and my request.

url = f"{base_url}/rest/api/2/issue"

response = requests.get(url, headers=headers, params=query)

I have tried query like - 

query = {

  'jql': 'project= project'

}

and 

query = {

'jql': 

"issueType=Bug AND Status in (Done, Completed) AND Project in('p1', 'p2', 'p3')

}