Is it possible to execute JQL query from python script and get the result in a xml or character delimited format.
Regards,
Urmimala
(NagraVision)
Yes - use the search REST API. Also, requests is a good client library which you can use in Python to execute the REST call.
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.
Use the jira-python library:https://jira.readthedocs.io/en/master/examples.html#searching
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 = SubtaskORDER 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)
##############################
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
It looks like you're new here. Sign in or register to get started.
