The Jira REST API enables you to interact with Jira programmatically. Use this API
to build apps, script interactions with Jira, or develop any other type of
integration.
The URIs for resources have the following structure:
https:///rest/api/3/
There are so many libraries like JIRA,request to access the JIRA services.
In the below code snippet, i had used request library and to save the results used
Pandas library.
Pandas in the best library to save the results to Excel workbook.
Pandas library can be installed using either PIP/PIP3/easy-install. Make sure you
are having right SSL certificate's before install pandas in intranet.
pip install pandas
Sample Code Snippet:
import requests
from requests.auth import HTTPBasicAuth
import json
import pandas as pd
pd.set_option('display.max_columns', 500)
# url = "https://ABCD.atlassian.net/rest/api/3/issuetype"
url = "https://ABCD.atlassian.net/rest/api/3/search"
auth = HTTPBasicAuth("xxxxxxx", "yyyyyyyyyyyyyy")
headers = {
"Accept": "application/json"
}
query = {
'jql': 'project = ABCD'
}
response = requests.request(
"GET",
url,
headers=headers,
params=query,
auth=auth
)
resdata = json.dumps(json.loads(response.text))
# print(json.dumps(json.loads(response.text), sort_keys=True, indent=4,
separators=(",", ": ")))
if response.status_code != 200:
print('Status:', response.status_code, 'Headers:', response.headers,
'Error Response:', response.json())
exit()
else:
print('Server Connected.Please wait.....')
#for fetching all sprints data
df = json.loads(resdata)
maxresults = df['maxResult']
print(df['total'])
writer = pd.ExcelWriter('Jira_issues.xlsx', engine='xlsxwriter')
dk.to_excel(writer, sheet_name='Jira_Issues', index=False)
writer.save()
No comments:
Post a Comment