（中秋查询月饼物流情况）飞书api与影刀RPA，记录

调用了影刀模块，猪猪云接口，1块钱1万次查询，因为懒，所以就没写猪猪云的代码，直接用了rpa

代码部分

      

import xbot
from xbot import print, sleep
from .import package
from .package import variables as glv
#上方为影刀RPA自带部分
def main(args):
    pass

import xbot_visual
import json
import requests

def access_token():
    url = "https://open.feishu.cn/open-apis/auth/v3/tenant_access_token/internal"
    payload = json.dumps({
        "app_id": "保密",
        "app_secret": "保密"
    })

    headers = {
        'Content-Type': 'application/json'
    }

    response = requests.post(url, headers=headers, data=payload)
    
    if response.status_code == 200:
        res = json.loads(response.text).get('tenant_access_token')
        return res
        
    return None

#acc = access_token()

def Read_Table(access_token,app_token,table_id):
    url = f'https://open.feishu.cn/open-apis/bitable/v1/apps/{app_token}/tables/{table_id }/records?filter=CurrentValue.%5B%E7%AD%BE%E6%94%B6%5D%3D0&page_size=500'#超500人就是bug
    #url = f"https://open.feishu.cn/open-apis/bitable/v1/apps/{app_token}/tables/{table_id }/records?page_size=500"#超500人就是bug
    payload = ''

    headers = {
      'Authorization': f'Bearer {access_token}'
    }

    response = requests.request("GET", url, headers=headers, data=payload)
    return json.loads(response.text)

# print(r)

def 接口(快递单):
    接口 = xbot_visual.process.run(process="process2", package=__name__, inputs={"快递单": 快递单}, outputs=[], _block=())
    return 接口.res

def update_feishu(access_token,app_token,table_id,records_id,Express_delivery_information):

    url = f"https://open.feishu.cn/open-apis/bitable/v1/apps/{app_token}/tables/{table_id}/records/{records_id}"
    payload = json.dumps({"fields": Express_delivery_information})

    headers = {
    'Content-Type': 'application/json',
    'Authorization': f'Bearer {access_token}'
    }

    response = requests.request("PUT", url, headers=headers, data=payload)
    print(response.text)

def work():

    a_token = access_token()
    app_token = '保密'
    table_id = '保密'
    r = Read_Table(a_token,app_token,table_id)

    work_items = {}
    if r['code'] == 0:
        for i in r['data']['items']:
            work_items.update({i['record_id']:i['fields']['圆通物流']})#要别外运用要改，写死了
    Express_delivery_information = 接口(list(work_items.values()))
    print(f'EDI:{Express_delivery_information}')
    
    
    for k,v in work_items.items():
        
        for k2,v2 in Express_delivery_information.items():
            if v == k2:
                ziliao = v2
                if v2['wuliuzhuangtai'] == '已签收' or v2['wuliuzhuangtai'] == '代收':
                    ziliao.update({'签收':True})
                    
                
                update_feishu(a_token,app_token,table_id,k,ziliao)
        
work()

影刀RPA部分

                 

输出的数据：