本文将介绍如何获取有成报销的连接器信息及配置有成报销的请求方案和写入方案
开发文档:https://bbs.qeasy.cloud/d/12960-you-cheng-bao-xiao-pei-zhi-zhi-nan
一、建立连接器
appkey
和appSecret
host
固定为https://www.h3yun.com/OpenApi/Invoke
,enginecode
填入appKey
,enginesecret
填入appSecret
二、配置请求适配器
\Adapter\Ycbg\YcbgQueryAdapter
/reimburse/base/getTemplateList.rjson
这个接口,来查请求单据列表所需要的相关字段,以下为请求调度者源数据,进行一次性的查询,并保留原始的返回参数,后续配置过程中需要用到。其中templateCode
为各单据的单据code。
{
"api": "/reimburse/base/getTemplateList.rjson",
"type": "RESTful",
"effect": "QUERY",
"method": "POST",
"number": "templateName",
"id": "templateCode",
"name": "id",
"idCheck": true,
"request": [],
"otherRequest": [],
"response": [
{
"field": "code",
"label": "code",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "codeRYSmj",
"title": "code-code",
"key": "codeRYSmj"
},
{
"field": "configureObject",
"label": "configureObject",
"type": "object",
"value": "",
"describe": "_autoFillResponse",
"id": "configureObject4J88x",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"children": [
{
"field": "valueRule",
"label": "valueRule",
"type": "string",
"value": "",
"id": "configureObjectVwpjM",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"describe": "_autoFillResponse",
"title": "valueRule-valueRule",
"key": "configureObjectVwpjM"
},
{
"field": "editable",
"label": "editable",
"type": "string",
"value": "",
"id": "configureObjecthO9Et",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"describe": "_autoFillResponse",
"title": "editable-editable",
"key": "configureObjecthO9Et"
},
{
"field": "textType",
"label": "textType",
"type": "string",
"value": "",
"id": "configureObjectjyUFP",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"describe": "_autoFillResponse",
"title": "textType-textType",
"key": "configureObjectjyUFP"
},
{
"field": "optional",
"label": "optional",
"type": "string",
"value": "",
"id": "configureObjectZkH91",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"describe": "_autoFillResponse",
"title": "optional-optional",
"key": "configureObjectZkH91"
},
{
"field": "label",
"label": "label",
"type": "string",
"value": "",
"id": "configureObjectRF2Kg",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"describe": "_autoFillResponse",
"title": "label-label",
"key": "configureObjectRF2Kg"
},
{
"field": "placeholder",
"label": "placeholder",
"type": "string",
"value": "",
"id": "configureObjectdgqjO",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"describe": "_autoFillResponse",
"title": "placeholder-placeholder",
"key": "configureObjectdgqjO"
},
{
"field": "maxLength",
"label": "maxLength",
"type": "string",
"value": "",
"id": "configureObjectktUip",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"describe": "_autoFillResponse",
"title": "maxLength-maxLength",
"key": "configureObjectktUip"
},
{
"field": "destruction",
"label": "destruction",
"type": "string",
"value": "",
"id": "configureObjectGHJv9",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"describe": "_autoFillResponse",
"title": "destruction-destruction",
"key": "configureObjectGHJv9"
}
],
"title": "configureObject-configureObject",
"key": "configureObject4J88x"
},
{
"field": "label",
"label": "label",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "labelwYl1h",
"title": "label-label",
"key": "labelwYl1h"
},
{
"field": "name",
"label": "name",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "nameRgILx",
"title": "name-name",
"key": "nameRgILx"
},
{
"field": "orderTemplateType",
"label": "orderTemplateType",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "orderTemplateTypeNi2wO",
"title": "orderTemplateType-orderTemplateType",
"key": "orderTemplateTypeNi2wO"
},
{
"field": "require",
"label": "require",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "require3p3RP",
"title": "require-require",
"key": "require3p3RP"
},
{
"field": "subformComponentList",
"label": "subformComponentList",
"type": "object",
"value": "",
"describe": "_autoFillResponse",
"id": "subformComponentListiw3YF",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"children": [],
"title": "subformComponentList-subformComponentList",
"key": "subformComponentListiw3YF"
},
{
"field": "templateCode",
"label": "templateCode",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "templateCodelz3rz",
"title": "templateCode-templateCode",
"key": "templateCodelz3rz"
},
{
"field": "templateName",
"label": "templateName",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "templateNamebt0pp",
"title": "templateName-templateName",
"key": "templateNamebt0pp"
},
{
"field": "templateType",
"label": "templateType",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "templateTypeQLjtF",
"title": "templateType-templateType",
"key": "templateTypeQLjtF"
},
{
"field": "type",
"label": "type",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "typeQxaZk",
"title": "type-type",
"key": "typeQxaZk"
}
],
"otherResponse": [
{
"id": "65be8c25-24e5-3163-a8e4-91835b58f61e",
"field": "statusKey",
"label": "statusKey",
"type": "string",
"is_required": false,
"describe": "",
"value": "result",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "statusKey-statusKey",
"key": "65be8c25-24e5-3163-a8e4-91835b58f61e"
},
{
"id": "7feeba0d-38b2-3a89-a291-2f34790d49fb",
"field": "statusValue",
"label": "statusValue",
"type": "string",
"is_required": false,
"describe": "",
"value": "100",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "statusValue-statusValue",
"key": "7feeba0d-38b2-3a89-a291-2f34790d49fb"
},
{
"id": "c97bc60c-eb2b-3d31-8592-ba6528369c33",
"field": "dataKey",
"label": "dataKey",
"type": "string",
"is_required": false,
"describe": "",
"value": "data",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "dataKey-dataKey",
"key": "c97bc60c-eb2b-3d31-8592-ba6528369c33"
},
{
"id": "bcfd3482-b286-3bc9-a917-7b7e90960888",
"field": "pageKey",
"label": "pageKey",
"type": "string",
"is_required": false,
"describe": "",
"value": "page",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "pageKey-pageKey",
"key": "bcfd3482-b286-3bc9-a917-7b7e90960888"
}
],
"buildModel": false,
"autoFillResponse": true
}
1. 报销单 2.借款单 3.付款单 4.费用类型 5. 申请单 6. 合同 7. 项目 8.收款单
三、写入调度者配置
\Adapter\Ycbg\YcbgExecuteAdapter
{
"api": "/reimburse/order/getOrderList.rjson",
"type": "RESTful",
"effect": "QUERY",
"method": "POST",
"number": "{{random}}",
"id": "{{random}}",
"name": "id",
"idCheck": true,
"request": [
{
"id": "b5e2fa99-9bba-3b53-b308-56118051dd25",
"field": "type",
"label": "type",
"type": "string",
"is_required": false,
"describe": "暂无描述",
"value": "3",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "type-type",
"key": "b5e2fa99-9bba-3b53-b308-56118051dd25"
},
{
"id": "17a97526-8a4a-3bea-b46b-4c697fc240af",
"field": "page",
"label": "page",
"type": "int",
"is_required": false,
"describe": "暂无描述",
"value": "1",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "page-page",
"key": "17a97526-8a4a-3bea-b46b-4c697fc240af"
},
{
"id": "275db7a2-570d-3b05-b049-b6b3abe0456a",
"field": "pageSize",
"label": "pageSize",
"type": "int",
"is_required": false,
"describe": "暂无描述",
"value": "10",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "pageSize-pageSize",
"key": "275db7a2-570d-3b05-b049-b6b3abe0456a"
},
{
"id": "bf1f8107-27e7-317d-94b2-e7c2cd9f8630",
"field": "beginTime",
"label": "beginTime",
"type": "string",
"is_required": false,
"describe": "暂无描述",
"value": "2021-10-11 19:32:27",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "beginTime-beginTime",
"key": "bf1f8107-27e7-317d-94b2-e7c2cd9f8630"
},
{
"id": "1cfee916-edc9-3931-9282-c0b4adc47e53",
"field": "dateType",
"label": "dateType",
"type": "int",
"is_required": false,
"describe": "暂无描述",
"value": "0",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "dateType-dateType",
"key": "1cfee916-edc9-3931-9282-c0b4adc47e53"
}
],
"otherRequest": [],
"response": [
{
"field": "completeTime",
"label": "completeTime",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "completeTimen4txe",
"title": "completeTime-completeTime",
"key": "completeTimen4txe"
},
{
"field": "contractPlanInfoList",
"label": "contractPlanInfoList",
"type": "object",
"value": "",
"describe": "_autoFillResponse",
"id": "contractPlanInfoListWJAXk",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"children": [],
"title": "contractPlanInfoList-contractPlanInfoList",
"key": "contractPlanInfoListWJAXk"
},
{
"field": "orderCode",
"label": "orderCode",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "orderCodebBuqg",
"title": "orderCode-orderCode",
"key": "orderCodebBuqg"
},
{
"field": "orderDate",
"label": "orderDate",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "orderDatendpDI",
"title": "orderDate-orderDate",
"key": "orderDatendpDI"
},
{
"field": "orderName",
"label": "orderName",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "orderName7jBfW",
"title": "orderName-orderName",
"key": "orderName7jBfW"
},
{
"field": "payAccountInfo",
"label": "payAccountInfo",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "payAccountInfo5vIbj",
"title": "payAccountInfo-payAccountInfo",
"key": "payAccountInfo5vIbj"
},
{
"field": "payAmount",
"label": "payAmount",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "payAmountYQCzA",
"title": "payAmount-payAmount",
"key": "payAmountYQCzA"
},
{
"field": "submitDate",
"label": "submitDate",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "submitDateJljtt",
"title": "submitDate-submitDate",
"key": "submitDateJljtt"
},
{
"field": "templateInsName",
"label": "templateInsName",
"value": "",
"type": "string",
"describe": "_autoFillResponse",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"id": "templateInsNameoUo0V",
"title": "templateInsName-templateInsName",
"key": "templateInsNameoUo0V"
},
{
"field": "userBankInfoList",
"label": "userBankInfoList",
"type": "object",
"value": "",
"describe": "_autoFillResponse",
"id": "userBankInfoListQ44GU",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"children": [],
"title": "userBankInfoList-userBankInfoList",
"key": "userBankInfoListQ44GU"
},
{
"field": "writeOffList",
"label": "writeOffList",
"type": "object",
"value": "",
"describe": "_autoFillResponse",
"id": "writeOffListAe4Kz",
"formModel": {
"enable": false
},
"physicalModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"children": [],
"title": "writeOffList-writeOffList",
"key": "writeOffListAe4Kz"
}
],
"otherResponse": [
{
"id": "65be8c25-24e5-3163-a8e4-91835b58f61e",
"field": "statusKey",
"label": "statusKey",
"type": "string",
"is_required": false,
"describe": "",
"value": "result",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "statusKey-statusKey",
"key": "65be8c25-24e5-3163-a8e4-91835b58f61e"
},
{
"id": "7feeba0d-38b2-3a89-a291-2f34790d49fb",
"field": "statusValue",
"label": "statusValue",
"type": "string",
"is_required": false,
"describe": "",
"value": "100",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "statusValue-statusValue",
"key": "7feeba0d-38b2-3a89-a291-2f34790d49fb"
},
{
"id": "c97bc60c-eb2b-3d31-8592-ba6528369c33",
"field": "dataKey",
"label": "dataKey",
"type": "string",
"is_required": false,
"describe": "",
"value": "data.list",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "dataKey-dataKey",
"key": "c97bc60c-eb2b-3d31-8592-ba6528369c33"
},
{
"id": "bcfd3482-b286-3bc9-a917-7b7e90960888",
"field": "pageKey",
"label": "pageKey",
"type": "string",
"is_required": false,
"describe": "",
"value": "page",
"parent_id": "00000000-0000-0000-0000-000000000000",
"physicalModel": {
"enable": false
},
"formModel": {
"enable": false
},
"tableModel": {
"enable": false
},
"title": "pageKey-pageKey",
"key": "bcfd3482-b286-3bc9-a917-7b7e90960888"
}
],
"buildModel": false,
"autoFillResponse": true
}
2023-12-19 02:04:27 | |
2024-01-09 10:47:50 | |
2023-02-22 05:45:49 | |
2022-07-04 13:22:18 | |
2022-10-04 05:52:22 | |
2024-06-21 09:01:14 | |
2021-08-25 17:18:09 | |
2024-12-02 00:38:37 | |
2024-12-04 11:12:36 | |
2024-12-16 06:43:08 | |
2024-12-29 03:24:45 | |
2024-12-11 02:31:28 | |
2024-12-11 12:09:48 | |
2024-12-17 08:23:25 | |
2024-12-01 17:49:32 | |
2024-11-12 14:18:48 | |
2024-11-28 16:33:39 | |
2024-10-28 11:28:27 | |
2024-12-16 11:28:49 | |
2025-01-28 11:26:19 | |
2024-03-11 09:18:11 | |
2024-03-11 09:01:32 | |
2024-03-11 09:00:48 | |
2024-03-11 08:59:59 | |
2024-03-11 08:58:56 |
何海波 18175716035
数据集成顾问 轻易云的技术专家,拥有丰富的数据集成规划经验。他能够为客户提供专业、全面的数据集成规划方案,熟练掌握多种集成技术和工具,帮助企业在数据集成领域得到长远发展。
黄宏棵 13286997615
数据集成顾问 资深系统集成顾问,专长于ERP、电商OMS、钉钉及CRM系统。他能提供高效的集成方案,优化企业运营流程,提升业务效率和决策智能化。
胡秀丛 15813570600
数据集成顾问 项目总监 她以卓越的数据集成专长,精通ERP、MES系统,以及数据中台的构建与优化。通过创新的一站式解决方案,她助力企业实现数据的无缝对接,提升业务流程效率,确保信息流通无障碍,为企业的数字化转型提供强有力的支持。
卢剑航 13760755942
数据集成专家 拥有十多年丰富的经验,擅长ERP、MES、数据中台、营销云中台等集成。他能够根据客户需求,为其提供一站式集成解决方案,帮助企业快速实现各类系统数据集成服务。