有成报销连接器获取及方案配置

丁仪_Qesay

本文将介绍如何获取有成报销的连接器信息及配置有成报销的请求方案和写入方案
开发文档：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

获取单据code
调用/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.收款单
配置列表查询方案
将刚才获取到的单据类型和单据code填入请求调度者参数中。

三、写入调度者配置

写入适配器：\Adapter\Ycbg\YcbgExecuteAdapter

查询单据模板
手工在有成做对应的单据，并把他查出来，以下为源数据，而后通过找中文的方式，找到对应字段的key。

{
  "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
}

配置写入调度者
通过刚才请求出来的单据模板，用中文找到对应字段的key