Is there any way to execute jira JQL query from python script.

[Urmimala Biswal]

Is it possible to execute JQL query from python script and get the result in a xml or character delimited format.

Regards,

Urmimala

(NagraVision)

[Jonathan Sambrook]

Use the jira-python library:

https://jira.readthedocs.io/en/master/examples.html#searching

[noamdah]

Yes, you can call jira's rest api it will return a JSON response.

In python you can use the os.system() function to use curl and get the jql required.

Check out this and this example.

[Mariana_Pryshliak_Saasjet]

Hello @Urmimala Biswal 

Can you clarify for which purposes you need a JQL function in Python?

I'll try to help you when I get to know it.

Best regards, Mariana

[Dougal Stephen]

from jira import JIRA

USER = 'you@yourdomain.com'
API_TOKEN ='<api token>'

options = {"server": "https://yourdomain.atlassian.net"}
jira = JIRA(options, basic_auth=(USER, API_TOKEN))

query = """

project = "MVP"
AND status = "Development done"
AND issuetype = Subtask
ORDER BY lastViewed DESC

"""

my_jql = jira.search_issues(query)

for issue in my_jql:
print (issue.key)
print (issue.fields.customfield_10233)

##############################
#projects = jira.projects()

#for project in projects:
# print (project.key)

# All fields on a ticket
#ticket = 'TICKET-653'
#issue = jira.issue(ticket)

#for field_name in issue.raw['fields']:
# print ("Field:", field_name, "Value:", issue.raw['fields'][field_name])

#summary = issue.fields.summary

#print('ticket: ', ticket, summary)

##############################

[Petar Petrov (Appfire)]

Yes - use the search REST API. Also, requests is a good client library which you can use in Python to execute the REST call.