python_查询并删除飞书多维表格中的记录

python_查询并删除飞书多维表格中的记录

importrequestsimportjson# 飞书应用配置APP_ID="XXX"APP_SECRET="XXX"# 表格配置FEISHU_CONFIG={"售前":{"app_token":"售前的app_token","table_id":"售前的table_id","view_id":"售前的view_id"},"售后":{"app_token":"XXX","table_id":"XXX","view_id":"XXX"}}startTriggerDict={"data":{"service_stage":"售后","rpa_coach":"火山","support_record_id_in_aw":"3"}}APP_TOKEN=FEISHU_CONFIG[startTriggerDict["data"]["service_stage"]]["app_token"]TABLE_ID=FEISHU_CONFIG[startTriggerDict["data"]["service_stage"]]["table_id"]VIEW_ID=FEISHU_CONFIG[startTriggerDict["data"]["service_stage"]]["view_id"]defget_tenant_access_token():"""获取 tenant_access_token"""url="https://open.feishu.cn/open-apis/auth/v3/tenant_access_token/internal"headers={"Content-Type":"application/json; charset=utf-8"}data={"app_id":APP_ID,"app_secret":APP_SECRET}response=requests.post(url,headers=headers,json=data)result=response.json()ifresult.get("code")==0:returnresult.get("tenant_access_token")else:raiseException(f"获取token失败:{result.get('msg')}")defquery_support_info_in_feishu_by_aw_record_id(token,support_record_id_in_aw):"""查询飞书多维表格里面AW中的支持记录对应ID所在行信息"""url=f"https://open.feishu.cn/open-apis/bitable/v1/apps/{APP_TOKEN}/tables/{TABLE_ID}/records/search"headers={"Authorization":f"Bearer{token}","Content-Type":"application/json; charset=utf-8"}data={"view_id":VIEW_ID,"field_names":["AW中的ID"],"filter":{"conjunction":"and","conditions":[{"field_name":"AW中的ID","operator":"is","value":[support_record_id_in_aw]}]}}response=requests.post(url,headers=headers,json=data)result=response.json()ifresult.get("code")==0:items=result.get("data",{}).get("items",[])iflen(items)>0:feishu_record_id=items[0]["record_id"]returnfeishu_record_idelse:raiseException("未找到对应的支持记录行信息")else:raiseException(f"查询记录失败:{result.get('msg')}")defdelete_support_info_by_feishu_record_id(token,feishu_record_id):"""删除飞书多维表格中的支持记录行信息"""url=f"https://open.feishu.cn/open-apis/bitable/v1/apps/{APP_TOKEN}/tables/{TABLE_ID}/records/{feishu_record_id}"headers={"Authorization":f"Bearer{token}","Content-Type":"application/json; charset=utf-8"}response=requests.delete(url,headers=headers)result=response.json()ifresult.get("code")==0:returnf"飞书多维表格中'AW中的ID'为：{startTriggerDict['data']['support_record_id_in_aw']}的行信息已删除"else:raiseException(f"删除记录失败:{result.get('msg')}")defmain():try:print("开始获取 tenant_access_token...")token=get_tenant_access_token()print(f"成功获取 token:{token[:20]}...")print(f"\n开始")feishu_record_id=query_support_info_in_feishu_by_aw_record_id(token,startTriggerDict['data']["support_record_id_in_aw"])print(f"查询结果:{feishu_record_id}")delete_result=delete_support_info_by_feishu_record_id(token,feishu_record_id)print(f"删除结果:{delete_result}")exceptExceptionase:print(f"\n❌ 错误:{e}")importtraceback traceback.print_exc()if__name__=="__main__":main()