1:创建令牌
在设置里面创建
2:根据项目和用户名发送curl命令测试:
curl --header “PRIVATE-TOKEN: glpat-R_N9x4ssboy5_ti7RyjC” “http://192.168.50.182:5006/api/v4/projects/Guxinhua%2Fwst_t41/issues”
会返回一大堆数据,
3:用Python简化:
import requests
import json
url = "http://192.168.50.182:5006/api/v4/projects/Guxinhua%2Fwst_t41/issues"
private_token = "glpat-R_N9x4ssboy5_ti7RyjC"
headers = {"PRIVATE-TOKEN": private_token}
response = requests.get(url, headers=headers)
data = json.loads(response.content.decode())
formatted_data = json.dumps(data, sort_keys=True, indent=4, separators=(',', ': '))
print(formatted_data)
这样好看一点,然后写入xls的程序:
import requests
import json
import xlwt
url = "http://192.168.50.182:5006/api/v4/projects/Guxinhua%2Fwst_t41/issues"
private_token = "glpat-R_N9x4ssboy5_ti7RyjC"
headers = {"PRIVATE-TOKEN": private_token}
response = requests.get(url, headers=headers)
data = json.loads(response.content.decode())
workbook = xlwt.Workbook(encoding="utf-8")
worksheet = workbook.add_sheet("Issues")
headings = ["ID", "Title", "Description"]
for index, heading in enumerate(headings):
worksheet.write(0, index, heading)
for index, issue in enumerate(data):
row = worksheet.row(index+1)
row.write(0, issue["iid"])
row.write(1, issue["title"])
row.write(2, issue["description"])
workbook.save("issues.xls")
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)