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