【飞书_获取日程冲突的技术支持名单_使用查询日程视图接口】

飞书_获取日程冲突的技术支持名单_使用查询日程视图接口

importrequestsfromdatetimeimportdatetime#将 2026-03-05 09:00 转换成秒级时间戳defget_timestamp(time_str):dt=datetime.strptime(time_str,"%Y-%m-%d %H:%M")timestamp=int(dt.timestamp())returntimestampdefget_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_calendar_event_views(calendar_id,start_time,end_time):""" 查询指定日历下的日程视图（实例视图） """# 构建请求URLbase_url=f"https://open.feishu.cn/open-apis/calendar/v4/calendars/{calendar_id}/events/instance_view"# 设置请求头headers={"Authorization":f"Bearer{access_token}","Content-Type":"application/json; charset=utf-8"}# 设置查询参数params={"start_time":start_time,"end_time":end_time,"user_id_type":"user_id"}response=requests.get(base_url,headers=headers,params=params)result=response.json()ifresult.get("code")==0:# 提取指定字段，构建新的字典列表new_event_list=[]foreventinresult.get("data",{}).get("items",[]):# 构建单个事件的新字典new_event={'summary':event['summary'],'feishu_start_time_time_stamp':event['start_time']['timestamp'],# 保留原始的开始时间字典（包含timestamp和timezone）'feishu_end_time_time_stamp':event['end_time']['timestamp'],# 保留原始的结束时间字典'status':event['status'],'self_rsvp_status':event['self_rsvp_status'],'free_busy_status':event['free_busy_status']}new_event_list.append(new_event)returnnew_event_listelse:raiseException(f"查询失败:{result.get('msg')}")defget_schedule_conflicts(calendar_id_info_list,requested_start_time_str,requested_end_time_str):requested_start_time_str_timestamp=get_timestamp(requested_start_time_str)requested_end_time_str_timestamp=get_timestamp(requested_end_time_str)schedule_conflicts_rpa_coach_info_list=[]forcalendar_id_infoincalendar_id_info_list:feishu_event_list=query_calendar_event_views(calendar_id_info["calendar_id"],requested_start_time_str_timestamp,requested_end_time_str_timestamp)schedule_conflicts=[]iflen(feishu_event_list)>0:foreventinfeishu_event_list:#判断feishu_start_time_time_stamp是否在晚上18点之后，只判断当天的时间戳feishu_start_time_time_stamp_datetime=datetime.fromtimestamp(int(event['feishu_start_time_time_stamp']))isStartTimeAfter18=Falseiffeishu_start_time_time_stamp_datetime.hour>=18:print("日程开始时间在晚上18点之后")isStartTimeAfter18=True#排除掉晚上18点之后的日程，组织者取消的日程，自己设置为空闲的日程，以及自己已拒绝的日程ifisStartTimeAfter18orevent['status']=='cancelled'orevent['free_busy_status']=='free'orevent['self_rsvp_status']=='decline':continueelse:schedule_conflicts.append(event)iflen(schedule_conflicts)>0:#将时间戳转换成日期时间字符串，并且将feishu_end_time_time_stamp等字段删除foreventinschedule_conflicts:feishu_start_time_time_stamp_datetime=datetime.fromtimestamp(int(event['feishu_start_time_time_stamp']))feishu_start_time_str=feishu_start_time_time_stamp_datetime.strftime("%Y-%m-%d %H:%M")feishu_end_time_time_stamp_datetime=datetime.fromtimestamp(int(event['feishu_end_time_time_stamp']))feishu_end_time_str=feishu_end_time_time_stamp_datetime.strftime("%Y-%m-%d %H:%M")# 删除原始时间戳字段event.pop('feishu_start_time_time_stamp',None)event.pop('feishu_end_time_time_stamp',None)# 添加转换后的时间字符串字段event['feishu_start_time_str']=feishu_start_time_str event['feishu_end_time_str']=feishu_end_time_str schedule_conflicts_rpa_coach_info_list.append({"rpa_coach":calendar_id_info["rpa_coach"],"schedule_conflicts":schedule_conflicts})returnschedule_conflicts_rpa_coach_info_list# 飞书应用配置APP_ID="XXX"APP_SECRET="XXX"calendar_id_info_list=[{"rpa_coach":"小曼","calendar_id":"XXX"}]requested_start_time_str="2026-02-27 09:10"# 客户成功填的requested_end_time_str="2026-02-27 18:20"# 客户成功填的# 获取访问凭证access_token=get_tenant_access_token()print(access_token)# 查询日程冲突schedule_conflicts_rpa_coach_info_list=get_schedule_conflicts(calendar_id_info_list,requested_start_time_str,requested_end_time_str)print(schedule_conflicts_rpa_coach_info_list)