Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
  • Community
  • Q&A
  • Jira
  • Questions
  • how to pull two columns 'summary' and 'support description' from JIRA issues into my sql database ?

how to pull two columns 'summary' and 'support description' from JIRA issues into my sql database ?

Praveen Kumar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 29, 2018

Hi Frnds,

I"m trying to pull two columns "summary" and "Support description" from JIRA issues into my sql database by using JQL- project = SW and resolution is empty and priority in (Blocker, Critical, Major). but i'm new to this python and JIRA. 

Could you please provide suggestion how to achieve that

 

Thanks

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
November 30, 2018

Use the REST API to read the issues with that JQL, and limit the response to the two fields you need.

Have a look at https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/ and check out the bits about "jql" and "&fields="

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events