外部数据导入接口调用指南
问题描述
需要将外部数据导入，怎么去调用接口？
解决方法
1.1星瀚平台配置
1.1.2创建第三方应用
菜单：开放平台->安全策略->第三方应用
系统编码：第三方应用APP唯一标识
AccessToken认证密钥：获取AccessToken时需要
API授权、IP白名单：需要打开，否则访问不通过
1.2外部数据接口调用
即是通过调用星瀚开放平台中的“保存外部数据（操作）”接口，将数据传输给智能核算平台，一次完整的通讯则产生一个外部数据；如下图：
1.2.1 准备
创建第三方应用
所在位置： 开放平台-第三方应用
第三方应用，即是需要与星瀚平台对接的三方系统，在此创建是为了获取与星瀚平台通讯的连接信息，即access token 值；后面会给出完整获取示例。
API服务列表
所在位置：开放平台-其他-API服务管理列表1.0-会计平台
上图是由相关星瀚财务开发人员已经内置好的几个API清单，即是说，外部数据不需要我们来手动添加，如果后面有需要，需要跟星瀚财务相关研发、产品等人沟通，由其内置成功后，由我们来调用；
API服务接口信息
所在位置：开放平台-API清单
可以查看到各接口基础信息，请求报文示例、返回报文示例等。
1.2.2 外部数据模型
创建外部数据模型
外部数据模型是调用星瀚外部数据的数据载体，即是说外部数据接口的请求报文体；外部数据会以星瀚平台内置的数据结构存储，如下图：
1.2.3 完整调用示例（postman）
说明：本次使用postman工具演示一次完整的会计事件接口调用：
即 获取APP_TOKEN ->获取ACCESS_TOKEN->调用会计事件（保存）->退出登录；
查询数据中心ID
通过如下链接查询数据中心ID集合：
https://环境地址/auth/getAllDatacenters.do
获取APP_TOKEN
Header: Content-Type=application/json
Body:
请求报文：
{
"appId": "第三方应用配置的系统编码",
"appSecret": "第三方应用配置的AccessToken认证密钥",
"tenantid": "",
"accountId": "1001444809426077696"
}
返回报文：
{
"data": {
"app_token": "d5bda955-dd57-445d-80d0-598f57c549ac",
"success": true,
"error_desc": "",
"expire_time": 1650008523742,
"error_code": "0"
},
"state": "success"
}
获取ACCESS_TOKEN
Header: Content-Type=application/json
Body:
请求报文：
{
"user":"17299999999",
"apptoken": "d5bda955-dd57-445d-80d0-598f57c549ac",
"tenantid":"",
"accountId":"1001444809426077696",
"usertype":"Mobile"
}
说明：apptoken是上面获取的APP_TOKEN值
返回报文：
{
"data": {
"access_token": "1001444809426077696_6yCCKAKugUQtt2i9Hf2ggFp4JseSI3to8DzMV8DTrj6d5KecKMV7JN87krOrAiO5PgPjM1wcVlmoHrs3MrtH4bO2zmvAHg1x4Lcg",
"success": true,
"error_desc": "",
"expire_time": 1650008526017,
"error_code": "0"
},
"state": "success"
}
调用外部数据（保存）
Header: Content-Type=application/json
accesstoken=上面获取的access_token
请求报文
Body:
请求报文：
{
"datas": [
{
"eventclass": "SHR-CMP-ItemAccountBill",--外部数据模型编码
"number": "ItemAccountBill-004",--外部数据编码
"org": "00",--业务单元
"sourcesys": "SHR系统",--来源系统
"description": "SHR费用分配单",--描述信息
"paging": "true",--是否分页
"data": {
"cmpItemAccountBill": "8r0AAABxW5fYm+a9",
"company": "8r0AAAAAAN/M567U",
"currency": "dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC",
"recordDate": "2022-06-08",
"businessDate": "2022-06-09",
"entries": [
{
"cmpItem": "8UAtquExRsi0PtM/6pxo4Py0kJc=",
"costBearOrgUnit": "8r0AAABxW5gRZ9+1",
"calTableItemAmount": "500.0000000000",
"commitmentItemAmount": "166.6666666667",
"commitmentItemCurrency": "e0c5c474-00fd-1000-e000-3909c0a8100dDEB58FDC",
"exchangeRate": "3.0000000000"
},
{
"cmpItem": "8UAtquExRsi0PtM/6pxo4Py0kJc=",
"costBearOrgUnit": "8r0AAABxW5gRZ9+1",
"calTableItemAmount": "149500.0000000000",
"commitmentItemAmount": "149500.0000000000",
"commitmentItemCurrency": "dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC",
"exchangeRate": "1.0000000000"
},
{
"cmpItem": "8r0AAAAGmN38tJCX",
"costBearOrgUnit": "8r0AAABxW5oRZ9+1",
"calTableItemAmount": "15.0000000000",
"commitmentItemAmount": "5.0000000000",
"commitmentItemCurrency": "e0c5c474-00fd-1000-e000-3909c0a8100dDEB58FDC",
"exchangeRate": "3.0000000000"
},
{
"cmpItem": "8r0AAAAGmN38tJCX",
"costBearOrgUnit": "8r0AAABxW5oRZ9+1",
"calTableItemAmount": "4485.0000000000",
"commitmentItemAmount": "4485.0000000000",
"commitmentItemCurrency": "dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC",
"exchangeRate": "1.0000000000"
}
]
}
},
{
"eventclass": "SHR-CMP-ItemAccountBill",
"number": "ItemAccountBill-003",
"org": "00",
"sourcesys": "SHR系统",
"description": "SHR费用分配单",
"paging": "commit",
"data": {
"cmpItemAccountBill": "8r0AAABxW5fYm+a9",
"company": "8r0AAAAAAN/M567U",
"currency": "dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC",
"recordDate": "",
"businessDate": "",
"entries": [
{
"cmpItem": "8UAtquExRsi0PtM/6pxo4Py0kJc=",
"costBearOrgUnit": "8r0AAABxW5gRZ9+1",
"calTableItemAmount": "500.0000000000",
"commitmentItemAmount": "166.6666666667",
"commitmentItemCurrency": "e0c5c474-00fd-1000-e000-3909c0a8100dDEB58FDC",
"exchangeRate": "3.0000000000"
},
{
"cmpItem": "8UAtquExRsi0PtM/6pxo4Py0kJc=",
"costBearOrgUnit": "8r0AAABxW5gRZ9+1",
"calTableItemAmount": "149500.0000000000",
"commitmentItemAmount": "149500.0000000000",
"commitmentItemCurrency": "dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC",
"exchangeRate": "1.0000000000"
},
{
"cmpItem": "8r0AAAAGmN38tJCX",
"costBearOrgUnit": "8r0AAABxW5oRZ9+1",
"calTableItemAmount": "15.0000000000",
"commitmentItemAmount": "5.0000000000",
"commitmentItemCurrency": "e0c5c474-00fd-1000-e000-3909c0a8100dDEB58FDC",
"exchangeRate": "3.0000000000"
},
{
"cmpItem": "8r0AAAAGmN38tJCX",
"costBearOrgUnit": "8r0AAABxW5oRZ9+1",
"calTableItemAmount": "4485.0000000000",
"commitmentItemAmount": "4485.0000000000",
"commitmentItemCurrency": "dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC",
"exchangeRate": "1.0000000000"
}
]
}
}
]
}
返回报文
返回报文：
{
"data": [
{
"dindex": 0,
"data": [
{
"pkValue": 1398579568255709184,
"entityKey": "ai_event",
"dataEntityIndex": 0,
"rowIndex": 0,
"subRowIndex": 0,
"title": "保存",
"message": "[businessDate业务日期]字段数据格式不正确",
"errorCode": "errorcode_001",
"level": "Error",
"errorLevel": "Error"
},
{
"pkValue": 1398579568255709184,
"entityKey": "ai_event",
"dataEntityIndex": 0,
"rowIndex": 0,
"subRowIndex": 0,
"title": "保存",
"message": "[recordDate记账日期]字段数据格式不正确",
"errorCode": "errorcode_001",
"level": "Error",
"errorLevel": "Error"
}
],
"success": false,
"id": 1398579568255709184
},
{
"dindex": 1,
"success": true,
"id": 1398579568448692224
}
],
"success": false,
"errorCode": "fail",
"message": null
}
退出登录
Header: Content-Type=application/json
Body:
请求报文：
{
"access_token": {{access_token}}
}
access_token即是获取的ACCESS_TOKEN值
适用版本
5.0版本及以上
参考资料
服务的完整流程如上图，详细信息参考：
https://vip.kingdee.com/article/213309216688450304?productLineId=29
外部数据导入接口调用指南
本文2024-09-22 22:57:25发表“云星瀚知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-xinghan-129937.html
- 鼎捷EAI整合規範文件V3.1.07 (集團).pdf
- 鼎捷OpenAPI應用場景說明_基礎資料.pdf
- 鼎捷OpenAPI應用場景說明_財務管理.pdf
- 鼎捷T100 API設計器使用手冊T100 APIDesigner(V1.0).docx
- 鼎新e-GoB2雲端ERP B2 線上課程E6-2應付票據整批郵寄 領取.pdf
- 鼎新e-GoB2雲端ERP B2 線上課程A4使用者建立權限設定.pdf
- 鼎新e-GoB2雲端ERP B2 線上課程C3會計開帳與會計傳票.pdf
- 鼎新e-GoB2雲端ERP B2 線上課程E6-1應付票據.pdf
- 鼎新e-GoB2雲端ERP B2 線上課程A5-1進銷存參數設定(初階篇).pdf
- 鼎新e-GoB2雲端ERP B2 線上課程D2帳款開帳與票據開帳.pdf
