金蝶接口
登錄接口
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獲取cookiesdef 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)