通過(guò)宜搭低代碼平臺(tái)快速搭建出來(lái)的費(fèi)用報(bào)銷應(yīng)用需要與金蝶云星空財(cái)務(wù)系統(tǒng)數(shù)據(jù)實(shí)現(xiàn)無(wú)縫集成打通。通過(guò)接口對(duì)接的方式，可視化界面配置實(shí)現(xiàn)數(shù)據(jù)源和數(shù)據(jù)目的地的連接，即可開始執(zhí)行數(shù)據(jù)同步工作，支持?jǐn)?shù)據(jù)實(shí)時(shí)同步。

整體業(yè)務(wù)架構(gòu)設(shè)計(jì)

依托宜搭強(qiáng)大的低代碼開發(fā)能力，構(gòu)建了一整套的資金費(fèi)控系統(tǒng)全生命周期管理。

再通過(guò)宜搭開放的接口能力，我們將審批流程與財(cái)務(wù)系統(tǒng)、支付系統(tǒng)打通。現(xiàn)在日常報(bào)銷、對(duì)外付款，資金上交下?lián)艿葮I(yè)務(wù)只需手機(jī)點(diǎn)一點(diǎn)審批，后續(xù)記賬、付款數(shù)據(jù)自動(dòng)生成，大幅提升了效率，節(jié)約了人工。借助系統(tǒng)集成的實(shí)時(shí)數(shù)據(jù)集成API統(tǒng)一管理，可視化的配置工具，實(shí)現(xiàn)低代碼集成方案，非入侵式、松耦合集成，不侵入現(xiàn)有業(yè)務(wù)系統(tǒng)，敏捷交付開箱即用，豐富的場(chǎng)景化集成方案，幫助企業(yè)告別數(shù)據(jù)孤。

主數(shù)據(jù)集成實(shí)現(xiàn)

集成流程

集成平臺(tái)配置實(shí)現(xiàn)

一、新增集成方案配置

設(shè)置集成方案編碼、名稱、優(yōu)先級(jí)（默認(rèn)為0），最大重試次數(shù)，集成同步定時(shí)策略。

通過(guò)系統(tǒng)集成平臺(tái)配置數(shù)據(jù)源的【接入系統(tǒng)】，分別選擇

源數(shù)據(jù)平臺(tái)=>金蝶云星空；

連接器=>對(duì)應(yīng)金蝶的授權(quán)連接器；

接口=>金蝶云星空供應(yīng)商查詢接口；

通過(guò)系統(tǒng)集成平臺(tái)配置【寫入系統(tǒng)】，分別選擇

源數(shù)據(jù)平臺(tái)=>阿里宜搭；

連接器=>宜搭連接器；

接口=>新增表單實(shí)例接口；

二、配置源平臺(tái)取數(shù)規(guī)則

進(jìn)入集成平臺(tái)的詳情頁(yè)面，選擇【源平臺(tái)配置】頁(yè)簽，可以開始可視化的配置金蝶的【查詢供應(yīng)商接口】取數(shù)規(guī)則。

三、金蝶查詢供應(yīng)商接口配置集成元數(shù)據(jù)

調(diào)用金蝶列表查詢接口【executeBillQuery】并且傳入【FormId=BD_Supplier】

{ "api": "executeBillQuery", "type": "QUERY", "method": "POST", "number": "FNumber", "id": "FSupplierId", "pagination": { "pageSize": 100 }, "idCheck": true, "request": [ { "field": "FSupplierId", "label": "FSupplierId", "type": "string", "is_required": true, "describe": null, "value": "FSupplierId" }, { "field": "FNumber", "label": "編碼", "type": "string", "is_required": true, "describe": null, "value": "FNumber" }, { "field": "FName", "label": "名稱", "type": "string", "is_required": true, "describe": null, "value": "FName" }, { "field": "FCreateOrgId_FNumber", "label": "創(chuàng)建組織", "type": "string", "is_required": true, "describe": null, "value": "FCreateOrgId.FNumber" } ], "otherRequest": [ { "field": "Limit", "label": "最大行數(shù)", "type": "string", "is_required": true, "describe": "金蝶的查詢分頁(yè)參數(shù)", "value": "{{PAGINATION_PAGE_SIZE}}" }, { "field": "StartRow", "label": "開始行索引", "type": "string", "is_required": true, "describe": "金蝶的查詢分頁(yè)參數(shù)", "value": "{{PAGINATION_START_ROW}}" }, { "field": "TopRowCount", "label": "返回總行數(shù)", "type": "int", "is_required": false, "describe": "金蝶的查詢分頁(yè)參數(shù)", "value": "0" }, { "field": "FilterString", "label": "過(guò)濾條件", "type": "string", "is_required": false, "describe": "示例寫法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=", "value": "FAuditDate > '{{LAST_SYNC_TIME|datetime}}'" }, { "field": "FieldKeys", "label": "需查詢的字段key集合", "type": "array", "is_required": true, "describe": "金蝶分錄主鍵ID格式：FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber", "parser": { "name": "ArrayToString", "params": "," } }, { "field": "FormId", "label": "業(yè)務(wù)對(duì)象表單Id", "type": "string", "is_required": true, "describe": "必須填寫金蝶的表單ID如:PUR_PurchaseOrder", "value": "BD_Supplier" } ], "response": [ ], "otherResponse": []}

四、配置目標(biāo)平臺(tái)寫入規(guī)則

進(jìn)入集成平臺(tái)的詳情頁(yè)面，選擇【目標(biāo)平臺(tái)配置】頁(yè)簽，可以開始可視化的配置宜搭的【表單實(shí)例新增接口】發(fā)送數(shù)據(jù)。

注意：宜搭的表單寫入接口必須要配置其它請(qǐng)求參數(shù)【應(yīng)用ID】【應(yīng)用密鑰】【表單ID】【釘釘用戶userId】

五、宜搭表單寫入接口集成元數(shù)據(jù)

{ "api":"/v1.0/yida/forms/instances", "type":"EXECUTE", "method":"POST", "number":null, "id":null, "idCheck":true, "request":[ { "parent":null, "label":"供應(yīng)商名稱", "field":"textField_ku6aw61g", "type":"string", "id":"textField_ku6aw61g", "value":"{{FName}}" }, { "parent":null, "label":"供應(yīng)商編碼", "field":"textField_ku6aw61h", "type":"string", "id":"textField_ku6aw61h", "value":"{{FNumber}}" }, { "parent":null, "label":"類型", "field":"textField_ku6aw61f", "type":"string", "value":"供應(yīng)商", "id":"textField_ku6aw61f" } ], "otherRequest":[ { "field":"appType", "label":"應(yīng)用ID", "type":"string", "is_required":false, "value":"XXXXXXXXXXXXXXXXXXXXXXXXXXXXX" }, { "field":"systemToken", "label":"應(yīng)用秘鑰", "type":"string", "is_required":false, "describe":"在應(yīng)用數(shù)據(jù)中獲取。", "value":"XXXXXXXXXXXXXXXXXXXXXXXXXXXX" }, { "field":"language", "label":"語(yǔ)言", "type":"string", "is_required":false, "describe":null, "value":"zh_CN" }, { "field":"formUuid", "label":"表單ID", "type":"string", "is_required":false, "value":"FORM-XXXXXXXXXXXXXXXXXXXXXXX" }, { "field":"userId", "label":"釘釘?shù)膗serId", "type":"string", "is_required":false, "describe":null, "value":"16000443318138909" } ], "response":[ ], "otherResponse":[ ]}

費(fèi)用報(bào)銷業(yè)務(wù)集成實(shí)現(xiàn)

集成流程

集成平臺(tái)配置實(shí)現(xiàn)

一、新增集成方案配置

通過(guò)系統(tǒng)集成平臺(tái)，設(shè)置集成方案編碼、名稱（Ioan_新借款單（費(fèi)用申請(qǐng)單））、優(yōu)先級(jí)（默認(rèn)為0），最大重試次數(shù)，集成同步定時(shí)策略。

二、配置源平臺(tái)宜搭取數(shù)方式

進(jìn)入集成平臺(tái)方案詳情頁(yè)面，選擇【源平臺(tái)配置】頁(yè)簽?？梢蚤_始配置如何調(diào)用宜搭數(shù)據(jù)查詢接口。

三、配置寫入金蝶費(fèi)用申請(qǐng)單接口

進(jìn)入【目標(biāo)平臺(tái)配置】開始配置金蝶費(fèi)用申請(qǐng)單寫入接口。 在頁(yè)面左側(cè)可以選擇對(duì)應(yīng)的字段與宜搭字段的對(duì)應(yīng)關(guān)系。

通過(guò)系統(tǒng)集成平臺(tái)配置完成之后即可實(shí)現(xiàn)：金蝶云星空與阿里宜搭自建費(fèi)控應(yīng)用如何與金蝶云星空對(duì)接打通。