![image.png](http://tmpbbs.ztc.ztccloud.com.cn:6875/developers-server/rest/file/group1/2024/07/29/9F46917F204D9BCD32B7B1B7B2AE1732.png) 以我本次的开发需求《使用权资产折旧明细导入》为例，说一下如何摸索出一个导入配置。步骤一：按照需求实现一个导入接口，添加相应的注解，示例如下： ![image.png](http://tmpbbs.ztc.ztccloud.com.cn:6875/developers-server/rest/file/group1/2024/07/29/9F46917F207C15F3B577B1B7B2AE1736.png) 实现相应的业务逻辑后呢，需要重启下服务，以便swagger抓取到我们定义的接口。步骤二：使用脚本插入配置数据，以便实现多集团初始化字段说明： 1、API_ID是对应Mongodb中api-document表的主键字段 2、CONFIG_VERSION这个字段是MD5加密字段，来源是将Mongodb中api-document表主键对应API_ID值的requestBodyList进行加密。为了简单操作，可以在页面上手动创建一条接口配置，然后将页面配置中生成的configVersion值拷贝过来即可。 3、CONFIG_CODE与ID保持与一致 ``` select count(1) from ZFS_IP.IP_DATA_IMPORT_CONFIG where id = '0298d55f-238e-1d4c-7cb2-1878c0265ce4_XY' INSERT INTO ZFS_IP.IP_DATA_IMPORT_CONFIG (ID, CONFIG_NAME, SERVICE_URL, REQUEST_METHOD, CONTENT_TYPE, IMPORT_DESC, SORT_NO, VALIDITY_FLAG, ENABLED_FLAG, CREATE_BY, CREATE_DATE, LAST_UPDATE_BY, LAST_UPDATE_DATE, API_ID, SYNC_COUNT, SERVICE_NAME, CONFIG_VERSION, MAIN_SHEET_NAME, GROUP_ID, REMARK, CONFIG_CODE) VALUES('0298d55f-238e-1d4c-7cb2-1878c0265ce4_@{groupCode}', '（3.9.4）使用权资产折旧明细导入', '/ldgasset/sync/depreciation', 'post', NULL, NULL, 1, '0', '0', 'dd0be1d549ec0065cbd7b1b9b2ae33cf', TIMESTAMP '2024-07-23 16:53:11.820000', 'dd0be1d549ec0065cbd7b1b9b2ae33cf', TIMESTAMP '2023-07-28 09:59:48.463000', 'zfs-ledger|/ldgasset/sync/depreciation|post|@{groupCode}', 1000, '使用权资产折旧明细同步接口', '471bd02a3648025c48ada5ce7d68cd5f', '数据导入', '@{groupId}', '用于将外系统的使用权资产已提折旧信息同步到租赁资产系统', '0298d55f-238e-1d4c-7cb2-1878c0265ce4_@{groupCode}'); ``` 步骤三：按照需求，将新建的配置分配到指定的数据分组里面，同样的使用sql实现 ``` select count(1) from ZFS_IP.IP_INTERFACE_GROUP_CONFIG_REF where id = '1095cbaf-3bf6-28bc-17b3-4b6f5e693db7_XY' INSERT INTO ZFS_IP.IP_INTERFACE_GROUP_CONFIG_REF (ID, INTERFACE_GROUP_ID, IMPORT_CONFIG_ID, VALIDITY_FLAG, ENABLED_FLAG, CREATE_BY, CREATE_DATE, LAST_UPDATE_BY, LAST_UPDATE_DATE, GROUP_ID, IMPORT_STEP) VALUES('1095cbaf-3bf6-28bc-17b3-4b6f5e693db7_@{groupCode}', '8545d278-29b9-2fc7-1728-84cbc2dfab09_@{groupCode}', '0298d55f-238e-1d4c-7cb2-1878c0265ce4_@{groupCode}', '0', '0', '220839d540cd64525829b1b2b7ae7134',TIMESTAMP '2024-02-29 09:09:56', '220839d540cd64525829b1b2b7ae7134',TIMESTAMP '2024-02-29 09:09:56', '@{groupId}', 'DATA_IMPORT_STEP_TWO'); ``` 到这一步，万里长征算是走完一半了。这个时候去接口管理-数据管理-导入配置菜单就可以看到你刚刚sql插入的数据了，同时在数据分组里面也能看到你添加进来的数据配置了。然后你选中你的导入配置，点击编辑，就会发现系统会给你报错“配置错误”... 这是正常情况，因为还有MongoDB数据没有插入。步骤四：因为MongoDB插入的数据比较复杂，所以这里需要在菜单：接口管理-数据管理-导入配置页面点击新建数据导入，就会出现如下页面： ![image.png](http://tmpbbs.ztc.ztccloud.com.cn:6875/developers-server/rest/file/group1/2024/07/29/9F46917F210FDE9E64E2B1B7B2AE1737.png) 点击引用标准API，选择步骤一中创建的接口，这个时候页面会带出接口的所有信息，然后命名一个自己喜欢的名称，保存就好了(注：如果选择不到自己定义的接口，请检查代码是否提交并且服务是否重启)。返回上一级页面后，点击编辑页面就可以正常看到页面打开而不会报"配置错误"的信息了。从接口返回里拿到该条数据的id，然后连接上MongoDB数据库（数据库配置信息如果不知道，可以找其他同事咨询），在DATA_IMPORT_CONFIG中查找configId等于前面id的数据，然后将MongoDB数据库中对应的字段信息拷贝出来，就是一个完整的MongoDB数据了。完整数据如下所示： ``` db.DATA_IMPORT_CONFIG.insertMany([{ "_id": "603ed6e733784535074ebecaf7dcb56_XY", "configId": "0298d55f-238e-1d4c-7cb2-1878c0265ce4_XY", "dataFlag": false, "apiDtos": [{ "filedName": "资产编码", "dataId": "data.assetCode", "pid": "data", "required": true, "sourceDataIsRequired": true, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "assetCode", "importFlag": true, "filedDesc": "填写资产编码；校验在使用权资产中是否存在和有效", "sortNo": new NumberInt("0"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "折旧金额", "dataId": "data.depreciationAmount", "pid": "data", "required": true, "sourceDataIsRequired": true, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "depreciationAmount", "importFlag": true, "filedDesc": "填写计提折旧金额；限制输入大于等于0的两位小数", "sortNo": new NumberInt("1"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "折旧期间", "dataId": "data.depreciationTime", "pid": "data", "required": true, "sourceDataIsRequired": true, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "depreciationTime", "importFlag": true, "filedDesc": "填写折旧期间；格式YYYY-MM", "sortNo": new NumberInt("2"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "行号", "dataId": "data.rowNum", "pid": "data", "required": false, "sourceDataIsRequired": false, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "rowNum", "importFlag": true, "filedDesc": "外系统传过来的行号，用于接口返回时告知外系统哪一行数据同步失败了", "sortNo": new NumberInt("3"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "集团id", "dataId": "data.groupId", "pid": "data", "required": false, "sourceDataIsRequired": false, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "groupId", "importFlag": false, "sortNo": new NumberInt("2147483647"), "sheetName": "请求数据-数据导入", "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "行ID", "dataId": "data.rowId", "pid": "data", "required": false, "sourceDataIsRequired": false, "refFlag": false, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "rowId", "importFlag": false, "sortNo": new NumberInt("2147483647"), "sheetName": "请求数据-数据导入", "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" } ], "apiExportDtos": [{ "filedName": "资产编码[assetCode]", "dataId": "data.assetCode", "pid": "data", "required": true, "sourceDataIsRequired": true, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "assetCode", "importFlag": true, "filedDesc": "填写资产编码；校验在使用权资产中是否存在和有效", "sortNo": new NumberInt("0"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "折旧金额[depreciationAmount]", "dataId": "data.depreciationAmount", "pid": "data", "required": true, "sourceDataIsRequired": true, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "depreciationAmount", "importFlag": true, "filedDesc": "填写计提折旧金额；限制输入大于等于0的两位小数", "sortNo": new NumberInt("1"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "折旧期间[depreciationTime]", "dataId": "data.depreciationTime", "pid": "data", "required": true, "sourceDataIsRequired": true, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "depreciationTime", "importFlag": true, "filedDesc": "填写折旧期间；格式YYYY-MM", "sortNo": new NumberInt("2"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "行号[rowNum]", "dataId": "data.rowNum", "pid": "data", "required": false, "sourceDataIsRequired": false, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "rowNum", "importFlag": true, "filedDesc": "外系统传过来的行号，用于接口返回时告知外系统哪一行数据同步失败了", "sortNo": new NumberInt("3"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" } ], "baseApiBody": [{ "_id": "data", "name": "请求数据", "pid": "", "level": new NumberInt("1"), "fieldType": "array", "isRequired": true, "demo": "", "desc": "请求数据", "publishParam": "data", "targetParam": "data", "children": [{ "_id": "data.assetCode", "name": "资产编码", "pid": "data", "level": new NumberInt("2"), "fieldType": "string", "isRequired": true, "demo": "LM01", "desc": "填写资产编码；校验在使用权资产中是否存在和有效", "publishParam": "assetCode", "targetParam": "assetCode" }, { "_id": "data.depreciationAmount", "name": "折旧金额", "pid": "data", "level": new NumberInt("2"), "fieldType": "string", "isRequired": true, "demo": "2000", "desc": "填写计提折旧金额；限制输入大于等于0的两位小数", "publishParam": "depreciationAmount", "targetParam": "depreciationAmount" }, { "_id": "data.depreciationTime", "name": "折旧期间", "pid": "data", "level": new NumberInt("2"), "fieldType": "string", "isRequired": true, "demo": "2024-01", "desc": "填写折旧期间；格式YYYY-MM", "publishParam": "depreciationTime", "targetParam": "depreciationTime" }, { "_id": "data.groupId", "name": "集团id", "pid": "data", "level": new NumberInt("2"), "fieldType": "string", "isRequired": false, "demo": "1", "desc": "集团id", "publishParam": "groupId", "targetParam": "groupId" }, { "_id": "data.rowNum", "name": "行号", "pid": "data", "level": new NumberInt("2"), "fieldType": "string", "isRequired": false, "demo": "1", "desc": "外系统传过来的行号，用于接口返回时告知外系统哪一行数据同步失败了", "publishParam": "rowNum", "targetParam": "rowNum" }, { "_id": "data.rowId", "name": "行ID", "pid": "data", "level": new NumberInt("2"), "fieldType": "string", "isRequired": false, "demo": "38ffbdb043f045ed544eb1b9b2ae034b", "desc": "该参数由接口自动处理，无需传值", "publishParam": "rowId", "targetParam": "rowId" } ], "_class": "cn.ztessc.entity.apiConfig.CustomApiEntity$JSONParam" } ], "sheetFiledMap": { "请求数据-数据导入": [{ "filedName": "资产编码[assetCode]", "dataId": "data.assetCode", "pid": "data", "required": true, "sourceDataIsRequired": true, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "assetCode", "importFlag": true, "filedDesc": "填写资产编码；校验在使用权资产中是否存在和有效", "sortNo": new NumberInt("0"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "折旧金额[depreciationAmount]", "dataId": "data.depreciationAmount", "pid": "data", "required": true, "sourceDataIsRequired": true, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "depreciationAmount", "importFlag": true, "filedDesc": "填写计提折旧金额；限制输入大于等于0的两位小数", "sortNo": new NumberInt("1"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "折旧期间[depreciationTime]", "dataId": "data.depreciationTime", "pid": "data", "required": true, "sourceDataIsRequired": true, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "depreciationTime", "importFlag": true, "filedDesc": "填写折旧期间；格式YYYY-MM", "sortNo": new NumberInt("2"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" }, { "filedName": "行号[rowNum]", "dataId": "data.rowNum", "pid": "data", "required": false, "sourceDataIsRequired": false, "level": new NumberInt("2"), "fieldType": "string", "apiFiledName": "rowNum", "importFlag": true, "filedDesc": "外系统传过来的行号，用于接口返回时告知外系统哪一行数据同步失败了", "sortNo": new NumberInt("3"), "sheetName": "请求数据-数据导入", "associatedField": [], "change": false, "delFlag": false, "_class": "cn.ztessc.dto.dataImportNew.DataImportApiDTO" } ] } } ]) ``` 上面例子中的configId改成插入IP_DATA_IMPORT_CONFIG脚本中的id就可以了 ``` db.api_document.insertMany([ { "_id": "zfs-ledger|/ldgasset/sync/depreciation|post|XY", "_class": "cn.ztessc.entity.apiConfig.StandardApiEntity", "code": "FSSC-API-000161", "desc": "用于将外系统的使用权资产已提折旧信息同步到租赁资产系统", "historyList": { "2024-07-22 20:00:00": "创建接口" }, "mdApiFlag": "1", "name": "使用权资产折旧明细同步接口", "notice": "1.资产编码+折旧期间，有则更新数据，无则新增数据；;\r\n2.此接口为实时接口；;", "onceSyncMaxNum": 1000, "requestBodyExample": "{\"data\":[{\"assetCode\":\"LM01\",\"groupId\":\"1\",\"rowNum\":\"1\",\"depreciationAmount\":\"2000\",\"depreciationTime\":\"2024-01\",\"rowId\":\"38ffbdb043f045ed544eb1b9b2ae034b\"}]}", "requestBodyList": [ { "_id": "data", "name": "请求数据", "pid": "", "level": 1, "fieldType": "array", "isRequired": true, "demo": "", "desc": "请求数据", "publishParam": "data", "targetParam": "data", "children": [ { "_id": "data.assetCode", "name": "资产编码", "pid": "data", "level": 2, "fieldType": "string", "isRequired": true, "demo": "LM01", "desc": "填写资产编码；校验在使用权资产中是否存在和有效", "publishParam": "assetCode", "targetParam": "assetCode" }, { "_id": "data.depreciationAmount", "name": "折旧金额", "pid": "data", "level": 2, "fieldType": "string", "isRequired": true, "demo": "2000", "desc": "填写计提折旧金额；限制输入大于等于0的两位小数", "publishParam": "depreciationAmount", "targetParam": "depreciationAmount" }, { "_id": "data.depreciationTime", "name": "折旧期间", "pid": "data", "level": 2, "fieldType": "string", "isRequired": true, "demo": "2024-01", "desc": "填写折旧期间；格式YYYY-MM", "publishParam": "depreciationTime", "targetParam": "depreciationTime" }, { "_id": "data.groupId", "name": "集团id", "pid": "data", "level": 2, "fieldType": "string", "isRequired": false, "demo": "1", "desc": "集团id", "publishParam": "groupId", "targetParam": "groupId" }, { "_id": "data.rowNum", "name": "行号", "pid": "data", "level": 2, "fieldType": "string", "isRequired": false, "demo": "1", "desc": "行号", "publishParam": "rowNum", "targetParam": "rowNum" }, { "_id": "data.rowId", "name": "行ID", "pid": "data", "level": 2, "fieldType": "string", "isRequired": false, "demo": "38ffbdb043f045ed544eb1b9b2ae034b", "desc": "该参数由接口自动处理，无需传值", "publishParam": "rowId", "targetParam": "rowId" } ] } ], "requestHeaderList": [], "requestMethod": "post", "requestParamList": [], "responseBodyExample": "{\"msg\":\"成功\",\"code\":\"0\",\"failNum\":\"1\",\"data\":[{\"rowNum\":\"1\",\"errMsg\":\"错误\",\"rowId\":\"38ffbdb043f045ed544eb1b9b2ae034b\"}],\"successNum\":\"1\"}", "responseParamList": [ { "_id": "msg", "name": "信息", "pid": "", "level": 1, "fieldType": "string", "isRequired": false, "demo": "成功", "desc": "返回消息-整体", "publishParam": "msg", "targetParam": "msg" }, { "_id": "code", "name": "编码", "pid": "", "level": 1, "fieldType": "string", "isRequired": true, "demo": "0", "desc": "0-全部成功;1-全部失败;2-部分成功", "publishParam": "code", "targetParam": "code" }, { "_id": "failNum", "name": "失败条数", "pid": "", "level": 1, "fieldType": "string", "isRequired": false, "demo": "1", "desc": "失败条数", "publishParam": "failNum", "targetParam": "failNum" }, { "_id": "data", "name": "数据", "pid": "", "level": 1, "fieldType": "array", "isRequired": false, "demo": "", "desc": "返回数据", "publishParam": "data", "targetParam": "data", "children": [ { "_id": "data.rowNum", "name": "行号", "pid": "data", "level": 2, "fieldType": "string", "isRequired": true, "demo": "1", "desc": "行号", "publishParam": "rowNum", "targetParam": "rowNum" }, { "_id": "data.errMsg", "name": "错误信息", "pid": "data", "level": 2, "fieldType": "string", "isRequired": true, "demo": "错误", "desc": "每行错误消息", "publishParam": "errMsg", "targetParam": "errMsg" }, { "_id": "data.rowId", "name": "行ID", "pid": "data", "level": 2, "fieldType": "string", "isRequired": false, "demo": "38ffbdb043f045ed544eb1b9b2ae034b", "desc": "接口平台数据同步标识", "publishParam": "rowId", "targetParam": "rowId" } ] }, { "_id": "successNum", "name": "成功条数", "pid": "", "level": 1, "fieldType": "string", "isRequired": false, "demo": "1", "desc": "成功条数", "publishParam": "successNum", "targetParam": "successNum" } ], "serviceCode": "zfs-ledger", "serviceName": "台账平台", "serviceUrl": "/ldgasset/sync/depreciation", "statusCodeList": [], "systemName": "租赁资产", "type": "1", "version": "V3.9.4" } ]) ``` 这条sql的作用是模板配置以及版本号匹配，页面就不会出现api已更新的提示了。到这里配置大体就结束了，最后需要将mongodb的脚本进行部署归档，具体的部署位置可以请教组长。 Over~

新增导入接口的详细步骤

新增导入接口的详细步骤

关于作者

目录