聚水潭与金蝶云星空聚水潭店铺对接金蝶部门

小群青V

源系统平台：聚水潭
源系统接口：店铺查询shops.query

目标系统平台：金蝶云星空
目标系统接口：部门新增batchSave

源平台元数据配置：

{
  "id": "shop_id",
  "api": "shops.query",
  "type": "QUERY",
  "method": "POST",
  "number": "shop_id",
  "idCheck": true,
  "request": [
    {
      "id": "店铺",
      "type": "string",
      "field": "店铺",
      "label": "店铺名",
      "value": "垃圾",
      "parent": null,
      "parser": {
        "name": "StringToArray",
        "params": ","
      }
    }
  ],
  "response": [
    {
      "type": "string",
      "field": "code",
      "label": "0,代表成功，其他代表失败",
      "value": null,
      "describe": null,
      "is_required": false
    },
    {
      "type": "string",
      "field": "msg",
      "label": "提示信息",
      "value": null,
      "describe": null,
      "is_required": false
    },
    {
      "type": "array",
      "field": "shops",
      "label": "店铺列表",
      "children": [
        {
          "type": "string",
          "field": "shop_id",
          "label": "店铺编号",
          "value": null,
          "parent": "shops",
          "describe": null,
          "is_required": false
        },
        {
          "type": "string",
          "field": "shop_name",
          "label": "店铺名称",
          "value": null,
          "parent": "shops",
          "describe": null,
          "is_required": false
        },
        {
          "type": "string",
          "field": "shop_site",
          "label": "站点",
          "value": null,
          "parent": "shops",
          "describe": null,
          "is_required": false
        },
        {
          "type": "string",
          "field": "nick",
          "label": "昵称",
          "value": null,
          "parent": "shops",
          "describe": null,
          "is_required": false
        },
        {
          "type": "string",
          "field": "session_expired",
          "label": "授权过期时间",
          "value": null,
          "parent": "shops",
          "describe": null,
          "is_required": false
        },
        {
          "type": "string",
          "field": "created",
          "label": "创建时间",
          "value": null,
          "parent": "shops",
          "describe": null,
          "is_required": false
        },
        {
          "type": "string",
          "field": "organization",
          "label": "组织",
          "value": null,
          "parent": "shops",
          "describe": null,
          "is_required": false
        }
      ],
      "describe": null,
      "is_required": false
    }
  ],
  "pagination": {
    "pageSize": 100
  },
  "otherRequest": [],
  "otherResponse": []
}

目标平台元数据配置：

{
  "id": null,
  "api": "batchSave",
  "type": "EXECUTE",
  "method": "POST",
  "number": null,
  "idCheck": true,
  "request": [
    {
      "type": "string",
      "field": "FName",
      "label": "部门名称",
      "value": "{{shops.shop_name}}",
      "describe": null,
      "is_required": true
    },
    {
      "type": "string",
      "field": "FNumber",
      "label": "编码",
      "value": "{{shops.shop_id}}",
      "describe": null,
      "is_required": true
    },
    {
      "type": "string",
      "field": "FCreateOrgId",
      "label": "创建组织",
      "value": "101",
      "parser": {
        "name": "ConvertObjectParser",
        "params": "FNumber"
      },
      "describe": null,
      "is_required": true
    },
    {
      "type": "string",
      "field": "FUseOrgId",
      "label": "使用组织",
      "value": "101",
      "parser": {
        "name": "ConvertObjectParser",
        "params": "FNumber"
      },
      "describe": null,
      "is_required": true
    },
    {
      "type": "string",
      "field": "FHelpCode",
      "label": "助记码",
      "value": null,
      "describe": null,
      "is_required": false
    },
    {
      "type": "string",
      "field": "FDescription",
      "label": "描述",
      "value": null,
      "describe": null,
      "is_required": false
    }
  ],
  "response": [],
  "operation": {
    "rows": 20,
    "method": "batchArraySave",
    "rowsKey": "array"
  },
  "otherRequest": [
    {
      "type": "string",
      "field": "FormId",
      "label": "业务对象表单Id",
      "value": "BD_Department",
      "describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
      "is_required": true
    },
    {
      "type": "string",
      "field": "Operation",
      "label": "执行的操作",
      "value": "BatchSave",
      "describe": null,
      "is_required": true
    },
    {
      "type": "bool",
      "field": "IsAutoSubmitAndAudit",
      "label": "提交并审核",
      "value": "true",
      "describe": null,
      "is_required": true
    },
    {
      "type": "bool",
      "field": "IsVerifyBaseDataField",
      "label": "验证基础资料",
      "value": "false",
      "describe": "是否验证所有的基础资料有效性，布尔类，默认false（非必录）",
      "is_required": false
    }
  ],
  "otherResponse": []
}