27 lines
688 B
Python
27 lines
688 B
Python
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")
|
|
|
|
|