import pandas as pd
from yd_api import YDAPI
from tqdm import tqdm

yd_api_instance = YDAPI()

token = yd_api_instance.generateToken()

df = pd.read_excel(r"C:\Users\zy187\Desktop\流程续约服务数据合并情况总表.xlsx",sheet_name="总表")

all_data = []
for index,row in tqdm(df.iterrows(),total=len(df)):
    id = row["实例ID"]
    res = yd_api_instance.get_approval_records(token = token,processInstanceId = id)
    result_list = res["result"]
    for result in result_list:
        result["实例ID"] = id
        all_data.append(result)


df1 = pd.DataFrame(all_data)

df2 = pd.merge(df,df1,on="实例ID",how="left")
df2.to_excel(r"C:\Users\zy187\Desktop\结果.xlsx")