from api import API
import pandas as pd
from tqdm import tqdm

api_instance = API()

df = pd.read_excel(r"C:\Users\hp_z66\Downloads\新签回访单_20260121154221.xlsx")
# 查询流程状态
for index, row in tqdm(df.iterrows(),total = len(df)):
    payload= {
        "data_id":row["data_id"],
    }

    res = api_instance.workflow_instance_get(payload)

    task = res.get("tasks")[-1]

    task_id = task.get("task_id")
    username = task.get("assignee").get("username")

    new_payload = {
        "username":username,
        "instance_id":row["data_id"],
        "task_id":task_id,
    }

    api_instance.workflow_task_approve(new_payload)