#假设以下为导出文件接口,与列表查询参数
urls = "https://www.hahapi.com/fuck/nima/jiade/export/list?"
params = {
"currentPage": 1,
"pageSize": 30,
"beginAffDate": "2022-03-01 00:00:00",
"endAffDate": "2022-03-02 23:59:59",
}
print("数据类型为:%s" % type(params))
def test_export_list_data(): #
result = requests.get(urls, params, headers=heard)
#先将响应结果的编码格式设置为“utf-8";
result.encoding="utf-8"
#再用with open的方式打开并新建一个excel表格,并写入response返回的数据流
#'D:/xx/files/export_data.xlsx文件路劲
with open('D:/xx/files/export_data.xlsx', 'wb') as f:
#利用Respose对象的iter_content()方法循环;
#并调用write()将每次遍历取回的内容写入该文件
for chunk in result.iter_content():
f.write(chunk)
#print(result)
至此,通过文件导出接口下载成功;