申请演示/体验

企业AI知识库

轻易云AI知识库是一个为企业量身打造的智能解决方案，它能够进行机器人角色设定、知识库训练、发布/分享机器人，同时还带有AI智能对话功能，可以设定多种AI行业场景。适用于企业智能客服、企业智能文档、专家顾问助理等多种企业级商业场景，具有较大的商业使用价值。

了解更多，请访问轻企AI知识库官网

AI智能体

AI智能体是轻易云知识库的核心组成部分，它通过录入文档或问答来创建知识库，让机器人学习。根据机器人训练情况，企业可以实时删除或替换文档，以保持知识库的更新和准确性。AI智能体支持多种角色设定，如客服、销售、培训师、营销人员、行业专家等，以满足不同业务需求。

了解更多，请访问轻易云知识库体验中心

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

    轻易云数据集成平台

本文将介绍如何获取有成报销的连接器信息及配置有成报销的请求方案和写入方案
开发文档：https://bbs.qeasy.cloud/d/12960-you-cheng-bao-xiao-pei-zhi-zhi-nan
一、建立连接器

  1. 使用有管理员权限的账号登录有成报销，如果是钉钉账户授权的，需要从钉钉进入
  2. 在系统管理-开发者中心中，获取appkey和appSecret

    将参数填入连接器中，host固定为https://www.h3yun.com/OpenApi/Invoke，enginecode填入appKey，enginesecret填入appSecret

二、配置请求适配器

  1. 请求适配器：\Adapter\Ycbg\YcbgQueryAdapter
  2. 获取单据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. 找到单据类型
      在有成的基础设置-自定义单据中找到对应的单据类型，1. 报销单 2.借款单 3.付款单 4.费用类型 5. 申请单 6. 合同 7. 项目 8.收款单
    2. 配置列表查询方案
      将刚才获取到的单据类型和单据code填入请求调度者参数中。

三、写入调度者配置

  1. 写入适配器：\Adapter\Ycbg\YcbgExecuteAdapter
  2. 查询单据模板
    手工在有成做对应的单据，并把他查出来，以下为源数据，而后通过找中文的方式，找到对应字段的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
}
  3. 配置写入调度者
    通过刚才请求出来的单据模板，用中文找到对应字段的key

热门文章

基于轻易云平台的数据集成：从吉客云到金蝶云星空

2022-01-27 01:26:09

数据集成实战：轻易云平台上的MySQL物料信息管理

2021-08-05 19:05:51

调用钉钉接口topapi/processinstance/get进行数据采集与处理

2021-06-07 20:34:36

调用汤臣倍健营销云API实现数据集成的案例分析

2021-07-17 05:47:22

用友U8数据调用及处理的技术详解

2023-06-05 07:33:34

如何配置汤臣倍健营销云API进行采购入库数据同步

2023-02-23 01:44:46

高效数据处理及转换：从每刻到金蝶云星空

2022-12-27 11:19:01

深度解析金蝶云星空API接口获取与数据清洗处理

2022-10-10 11:27:50

从钉钉到MySQL的数据集成实战

2021-06-25 10:01:43

技术案例：旺店通与金蝶云星空的高效数据传输方案

2023-02-07 09:47:17

从泛微OA到金蝶云：生产订单审批数据的跨系统对接

2021-09-21 13:37:58

数据转化与适配：吉客云到用友BIP的实践技巧

2021-09-02 12:17:45

调用旺店通接口并转换数据格式实现销售单对接

2023-04-30 04:36:01

高效数据同步：MySQL与广东特殊食品电子追溯平台的集成方案

2022-07-19 13:34:12

通过轻易云平台调用金蝶云星空API进行数据集成

2022-08-14 17:26:46

调用金蝶云星空API获取供应链数据的最佳实践

2021-03-11 09:11:41

轻松实现售后单数据集成：从聚水潭到MySQL

2021-02-10 00:19:38

金蝶云星空数据转换与映射到MySQL数据库的技术实操

2023-03-16 07:09:02

使用轻易云平台实现金蝶与旺店通的数据同步

2023-07-03 03:23:31

如何利用轻易云实现汤臣倍健采购入库数据的无缝转换

2022-04-22 17:35:03

如何从零到一的设计一套轻易云数据集成平台这样的系统架构

2023-02-28 06:19:33

[轻易云数据集成平台 V2.1] 发版说明

2023-02-18 07:39:21

数据集成平台的自定义函数使用明细

2023-02-12 02:11:43

关于轻易云数据集成平台请求调度者配置

2023-02-07 09:33:55

关于集成方案的【方案信息】页签中每一个字段的详细解释

2023-02-06 06:14:45