背景
需求方提了一个需要下载微信支付的电子回单,下载【企业付款到零钱电子回单】的凭证。
原本调研看微信支付后台是否有批量下载电子回单的功能,找了一圈没找到。只找到了API接口。
微信支付接口文档
如何生成请求签名:https://pay.weixin.qq.com/docs/merchant/development/interface-rules/signature-generation.html
受理转账明细电子回单API:https://pay.weixin.qq.com/docs/merchant/apis/batch-transfer-to-balance/electronic-receipt-api/create-electronic-receipt.html
查询转账明细电子回单受理结果API:https://pay.weixin.qq.com/docs/merchant/apis/batch-transfer-to-balance/electronic-receipt-api/query-electronic-receipt.html
下载电子回单:https://pay.weixin.qq.com/docs/merchant/apis/batch-transfer-to-balance/download-receipt.html
实现思路
- 根据【商户单号】去调用【受理转账明细电子回单API】
- 基于【受理转账明细电子回单API】的结果得到【download_url】
- 基于【download_url】去请求得到【文件流】
代码
import datetime
import io
import random
import string
from urllib.parse import urlparse, quote, urlencode, urlunparse
from cryptography.hazmat.primitives import hashes
from cryptography.hazmat.primitives.asymmetric import padding, rsa
from cryptography.hazmat.primitives import serialization
import base64
import requests
import json
# 证书路径
pem_path = '/path/apiclient_key.pem'
# 商户号
mchid = '16xxxxx2'
# 证书序列号
serial_no = '3Dxxxxxxxxxxxxxxxxxxxx83'
# 请求路径
base_url = "https://api.mch.weixin.qq.com"
def get_canonical_url(url):
"""
获取绝对URL
:param url:
:return:
"""
parsed_url = urlparse(url)
# 获取路径并进行编码
canonical_url = quote(parsed_url.path)
# 如果有查询参数,添加到路径后面
if parsed_url.query:
canonical_url += "?" + parsed_url.query
return canonical_url
def append_dict_to_url(url, params):
"""
拼接URL和参数
:param url:
:param params:
:return:
"""
# 解析 URL
parsed_url = urlparse