python调用金蝶api接口

Apex Predator

于 2025-05-16 14:28:43 发布

阅读量350

点赞数 4

分类专栏：金蝶云星空文章标签： python chrome 开发语言

本文链接：https://blog.csdn.net/ApexPredator/article/details/147989398

版权

金蝶云星空专栏收录该内容

2 篇文章

订阅专栏

金蝶接口

登录接口
https://xxx.xxx.com/k3cloud/Kingdee.BOS.WebApi.ServicesStub.AuthService.ValidateUser.common.kdsvc
查询单据接口
https://xxx.xxx.com/K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.ExecuteBillQuery.common.kdsvc
基础资料保存接口、单据保存接口无源单、单据保存接口有源单都使用以下接口
https://xxx.xxx.com/K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Save.common.kdsvc
批量保存表单数据接口
http://xxx.xxx.com/K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.BatchSave.common.kdsvc
查看接口
https://xxx.xxx.com/K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.View.common.kdsvc
提交接口
https://xxx.xxx.com/K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Submit.common.kdsvc
审核接口
https://xxx.xxx.com/K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Audit.common.kdsvc
反审核接口
http://xxx.xxx.com/K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.UnAudit.common.kdsvc
下推接口
https://xxx.xxx.com/K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Push.common.kdsvc
删除接口
https://xxx.xxx.com/K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.Delete.common.kdsvc

以上是基本需要使用的接口，使用时将域名更为自己的金蝶云星空域名

使用金蝶云星空接口的必要信息是，需要自行创建一个与administrator具有相同权限的用户，获取账套id

使用超级管理员登录金蝶云星空找到webapi并打开

随便选择一个表单功能然后点击在线测试webapi功能

在这里就能找到啊账套id

关于生成调用api需要的json数据可以参考以下文章

金蝶云星空webapi使用-CSDN博客

以下给出一个使用python调用查询单据的api接口去获取收款单数据的使用示例

#调用登录接口登录k3获取cookies
 def k3_login(): 
    login_url = "http://xxx.xxx.com/k3cloud/Kingdee.BOS.WebApi.ServicesStub.AuthService.ValidateUser.common.kdsvc"
    login_data = {"acctid": "账套id", "username": "k3用户名", "password": "k3密码", "lcid": 2052}
    response=requests.post(url=login_url, data=login_data)
    return response.cookies

#调用单据查询接口使用cookies查询单据，除登录接口不用使用cookies，其他接口都需要
def query_k3_data():
    query_url = "http://xxx.xxx.com/K3Cloud/Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.ExecuteBillQuery.common.kdsvc"
    post_data = {"data": json.dumps(
            {
                "FormId": "AR_RECEIVEBILL",         #表单id
                "FieldKeys": "FPAYORGID.FName,FRECBANKID,FPURPOSEID.FName,FRECAMOUNTFOR_E ,FPAYUNIT.FName,FRECAMOUNTFOR,FDATE",        #需要查询的字段信息,下面的是过滤规则
                "FilterString": [{"FieldName":"FPAYORGID.FName","Compare":"67","Value":"xxx有限公司","Left":"","Right":"","Logic":"0"},{"FieldName":"FDATE","Compare":"63","Value":"","Left":"","Right":"","Logic":"1"}],
                "Limit": 10000       #查询的最大行数,最大就是10000行
            }
        )
    }
    response=requests.post(url=query_url, data=post_data, cookies=k3_login())
    print(response.text)