源系统平台:金蝶云星空
源系统接口: 逐个单据查询ExecuteBillQuery
目标系统平台: 吉客云
目标系统接口: 客户新增crm.customer.add
源平台元数据配置:
{
"id": "FId",
"api": "ExecuteBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FNumber",
"idCheck": false,
"request": [
{
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0",
"describe": "金蝶的查询分页参数",
"is_required": false
},
{
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": null,
"describe": "示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=",
"is_required": false
},
{
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"value": null,
"parser": {
"name": "ArrayToString",
"params": ","
},
"describe": "金蝶分录主键ID格式:FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber",
"is_required": true
},
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "ECC_Shop",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
}
],
"response": [
{
"type": "string",
"field": "DocumentStatus",
"label": "单据状态",
"value": null
},
{
"type": "string",
"field": "ForbidStatus",
"label": "禁用状态",
"value": null
},
{
"type": "string",
"field": "Name",
"label": "名称",
"value": null
},
{
"type": "string",
"field": "Number",
"label": "编码",
"value": null
},
{
"type": "string",
"field": "ModifierId_Id",
"label": "修改人_Id",
"value": null
},
{
"type": "string",
"field": "ModifierId_Name",
"label": "修改人_名称",
"value": null
},
{
"type": "string",
"field": "ModifierId_Number",
"label": "修改人_编码",
"value": null
},
{
"type": "string",
"field": "CreatorId_Id",
"label": "创建人_Id",
"value": null
},
{
"type": "string",
"field": "CreatorId_Name",
"label": "创建人_名称",
"value": null
},
{
"type": "string",
"field": "CreatorId_Number",
"label": "创建人_编码",
"value": null
},
{
"type": "string",
"field": "CreateDate",
"label": "创建日期",
"value": null
},
{
"type": "string",
"field": "FModifyDate",
"label": "修改日期",
"value": null
},
{
"type": "string",
"field": "Description",
"label": "描述",
"value": null
},
{
"type": "string",
"field": "SaleOrgId_Id",
"label": "对应销售组织_Id",
"value": null
},
{
"type": "string",
"field": "SaleOrgId_Name",
"label": "对应销售组织_名称",
"value": null
},
{
"type": "string",
"field": "SaleOrgId_Number",
"label": "对应销售组织_编码",
"value": null
},
{
"type": "string",
"field": "CreateOrgId_Id",
"label": "创建组织_Id",
"value": null
},
{
"type": "string",
"field": "CreateOrgId_Name",
"label": "创建组织_名称",
"value": null
},
{
"type": "string",
"field": "CreateOrgId_Number",
"label": "创建组织_编码",
"value": null
},
{
"type": "string",
"field": "ShopType",
"label": "网店类型",
"value": null
},
{
"type": "string",
"field": "ShopName",
"label": "店铺名称",
"value": null
},
{
"type": "string",
"field": "Token",
"label": "网店特征码",
"value": null
},
{
"type": "string",
"field": "EnterAddress",
"label": "接入网址",
"value": null
},
{
"type": "string",
"field": "StartDate",
"label": "开通时间",
"value": null
},
{
"type": "string",
"field": "CustomerId_Id",
"label": "对应客户_Id",
"value": null
},
{
"type": "string",
"field": "CustomerId_Name",
"label": "对应客户_名称",
"value": null
},
{
"type": "string",
"field": "CustomerId_Number",
"label": "对应客户_编码",
"value": null
},
{
"type": "string",
"field": "SettlementCurrency_Id",
"label": "结算币别_Id",
"value": null
},
{
"type": "string",
"field": "SettlementCurrency_Name",
"label": "结算币别_名称",
"value": null
},
{
"type": "string",
"field": "SettlementCurrency_Number",
"label": "结算币别_编码",
"value": null
},
{
"type": "string",
"field": "SettlementOrgId_Id",
"label": "对应结算组织_Id",
"value": null
},
{
"type": "string",
"field": "SettlementOrgId_Name",
"label": "对应结算组织_名称",
"value": null
},
{
"type": "string",
"field": "SettlementOrgId_Number",
"label": "对应结算组织_编码",
"value": null
},
{
"type": "string",
"field": "EnableDown",
"label": "启用下载",
"value": null
},
{
"type": "string",
"field": "IsTBYZShop",
"label": "默认菜鸟接入网店",
"value": null
},
{
"type": "string",
"field": "ShopCustomerCode",
"label": "京东快递店铺商家编码",
"value": null
},
{
"type": "string",
"field": "ServiceMaterialID_Id",
"label": "对应运费物料_Id",
"value": null
},
{
"type": "string",
"field": "ServiceMaterialID_Name",
"label": "对应运费物料_名称",
"value": null
},
{
"type": "string",
"field": "ServiceMaterialID_Number",
"label": "对应运费物料_编码",
"value": null
},
{
"type": "string",
"field": "LogisticsFilterByStockOrg",
"label": "按库存组织匹配物流公司",
"value": null
},
{
"type": "string",
"field": "LogisticsFilterByNetShop",
"label": "按网店匹配物流公司",
"value": null
},
{
"type": "string",
"field": "LogisticsFilterByAreaScope",
"label": "按配送区域范围匹配物流公司",
"value": null
},
{
"type": "string",
"field": "LogisticsFilterByMaterialScope",
"label": "按配送物料范围匹配物流公司",
"value": null
},
{
"type": "string",
"field": "LogisticsFilterByFare",
"label": "按最小运费匹配物流公司",
"value": null
},
{
"type": "string",
"field": "BillOrgID_Id",
"label": "收付款组织_Id",
"value": null
},
{
"type": "string",
"field": "BillOrgID_Name",
"label": "收付款组织_名称",
"value": null
},
{
"type": "string",
"field": "BillOrgID_Number",
"label": "收付款组织_编码",
"value": null
},
{
"type": "string",
"field": "Nick",
"label": "昵称",
"value": null
},
{
"type": "string",
"field": "TBYZJoinNetShopId_Id",
"label": "菜鸟面单接入网店_Id",
"value": null
},
{
"type": "string",
"field": "TBYZJoinNetShopId_Name",
"label": "菜鸟面单接入网店_名称",
"value": null
},
{
"type": "string",
"field": "TBYZJoinNetShopId_Number",
"label": "菜鸟面单接入网店_编码",
"value": null
},
{
"type": "string",
"field": "FServiceMaterial_Id",
"label": "对应服务物料_Id",
"value": null
},
{
"type": "string",
"field": "FServiceMaterial_Name",
"label": "对应服务物料_名称",
"value": null
},
{
"type": "string",
"field": "FServiceMaterial_Number",
"label": "对应服务物料_编码",
"value": null
},
{
"type": "string",
"field": "LSBranch_Id",
"label": "门店信息_Id",
"value": null
},
{
"type": "string",
"field": "LSBranch_Name",
"label": "门店信息_名称",
"value": null
},
{
"type": "string",
"field": "LSBranch_Number",
"label": "门店信息_编码",
"value": null
},
{
"type": "string",
"field": "DownloadByGY",
"label": "管易对接网店",
"value": null
},
{
"type": "string",
"field": "GYShopType",
"label": "管易网店类型",
"value": null
},
{
"type": "string",
"field": "GYModifyDate",
"label": "管易网店修改日期",
"value": null
},
{
"type": "string",
"field": "IsSMSNotice",
"label": "生成出库单短信通知收货人",
"value": null
},
{
"type": "string",
"field": "IsOneSMSNotice",
"label": "拆分发货仅发一次短信通知",
"value": null
},
{
"type": "array",
"field": "ShopStock",
"label": "配送网络",
"children": [
{
"type": "string",
"field": "StockOrgId_Id",
"label": "库存组织_Id",
"value": null
},
{
"type": "string",
"field": "StockOrgId_Name",
"label": "库存组织_名称",
"value": null
},
{
"type": "string",
"field": "StockOrgId_Number",
"label": "库存组织_编码",
"value": null
},
{
"type": "string",
"field": "StockId_Id",
"label": "仓库_Id",
"value": null
},
{
"type": "string",
"field": "StockId_Name",
"label": "仓库_名称",
"value": null
},
{
"type": "string",
"field": "StockId_Number",
"label": "仓库_编码",
"value": null
},
{
"type": "string",
"field": "EnableInvSync",
"label": "启用库存同步",
"value": null
},
{
"type": "string",
"field": "SyncPercent",
"label": "同步比例",
"value": null
},
{
"type": "string",
"field": "SenderName",
"label": "发件人信息&名称",
"value": null
},
{
"type": "string",
"field": "CompanyName",
"label": "发件人信息&单位名称",
"value": null
},
{
"type": "string",
"field": "SenderAddress",
"label": "发件人信息&寄件地址",
"value": null
},
{
"type": "string",
"field": "Telephone",
"label": "发件人信息&联系电话",
"value": null
},
{
"type": "string",
"field": "ZipCode",
"label": "发件人信息&邮政编码",
"value": null
},
{
"type": "string",
"field": "IsSupportCarry",
"label": "支持自提",
"value": null
},
{
"type": "string",
"field": "CarryAddress_Id",
"label": "自提地址_Id",
"value": null
},
{
"type": "string",
"field": "CarryAddress_Name",
"label": "自提地址_名称",
"value": null
},
{
"type": "string",
"field": "CarryAddress_Number",
"label": "自提地址_编码",
"value": null
},
{
"type": "string",
"field": "SendAddress_Id",
"label": "发货地址_Id",
"value": null
},
{
"type": "string",
"field": "SendAddress_Name",
"label": "发货地址_名称",
"value": null
},
{
"type": "string",
"field": "SendAddress_Number",
"label": "发货地址_编码",
"value": null
},
{
"type": "string",
"field": "ReturnAddress_Id",
"label": "退货地址_Id",
"value": null
},
{
"type": "string",
"field": "ReturnAddress_Name",
"label": "退货地址_名称",
"value": null
},
{
"type": "string",
"field": "ReturnAddress_Number",
"label": "退货地址_编码",
"value": null
},
{
"type": "string",
"field": "IsEnable",
"label": "启用",
"value": null
},
{
"type": "string",
"field": "Level",
"label": "优先级",
"value": null
},
{
"type": "string",
"field": "TransType",
"label": "流转类型",
"value": null
}
]
},
{
"type": "array",
"field": "ShopMD",
"label": "门店配送网络",
"children": [
{
"type": "string",
"field": "EnableSyn",
"label": "启用库存同步",
"value": null
},
{
"type": "string",
"field": "SynRate",
"label": "同步比例(%)",
"value": null
},
{
"type": "string",
"field": "MDChannel_Id",
"label": "门店_Id",
"value": null
},
{
"type": "string",
"field": "MDChannel_Name",
"label": "门店_名称",
"value": null
},
{
"type": "string",
"field": "MDChannel_Number",
"label": "门店_编码",
"value": null
}
]
},
{
"type": "array",
"field": "ShopWB",
"label": "外部配送网络",
"children": [
{
"type": "string",
"field": "WBChannel_Id",
"label": "外部渠道_Id",
"value": null
},
{
"type": "string",
"field": "WBChannel_Name",
"label": "外部渠道_名称",
"value": null
},
{
"type": "string",
"field": "WBChannel_Number",
"label": "外部渠道_编码",
"value": null
},
{
"type": "string",
"field": "WBKeepInvQty",
"label": "预留库存",
"value": null
}
]
},
{
"type": "array",
"field": "ShopGYS",
"label": "供应商配送网络",
"children": [
{
"type": "string",
"field": "GYSKeepInvQty",
"label": "预留库存",
"value": null
}
]
}
],
"pagination": {
"pageSize": 10
},
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "crm.customer.add",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "customerCode",
"label": "客户编号",
"value": null,
"describe": "C201907050001",
"is_required": true
},
{
"type": "string",
"field": "nickname",
"label": "客户名称",
"value": null,
"describe": "张三",
"is_required": true
},
{
"type": "string",
"field": "alias",
"label": "别名",
"value": null,
"describe": "张飞",
"is_required": false
},
{
"type": "string",
"field": "vipLevel",
"label": "会员等级id",
"value": null,
"describe": "ad1a2w3q1ada65zc5621asd",
"is_required": false
},
{
"type": "string",
"field": "vipLevelName",
"label": "会员等级名称",
"value": null,
"describe": "金牌会员",
"is_required": false
},
{
"type": "string",
"field": "contacts",
"label": "联系人",
"value": null,
"describe": "李四",
"is_required": false
},
{
"type": "string",
"field": "country",
"label": "国家",
"value": null,
"describe": "中国",
"is_required": false
},
{
"type": "string",
"field": "state",
"label": "省份",
"value": null,
"describe": "浙江省",
"is_required": false
},
{
"type": "string",
"field": "city",
"label": "城市",
"value": null,
"describe": "杭州市",
"is_required": false
},
{
"type": "string",
"field": "district",
"label": "区",
"value": null,
"describe": "西湖区",
"is_required": false
},
{
"type": "string",
"field": "town",
"label": "镇",
"value": null,
"describe": "三墩镇",
"is_required": false
},
{
"type": "string",
"field": "address",
"label": "基本信息地址-地址",
"value": null,
"describe": "浙江省杭州市西湖区三墩镇",
"is_required": false
},
{
"type": "string",
"field": "detailedAddress",
"label": "基本信息地址-详细地址",
"value": null,
"describe": "西园十路8号笛佛大厦",
"is_required": false
},
{
"type": "string",
"field": "zip",
"label": "邮编",
"value": null,
"describe": "310000",
"is_required": false
},
{
"type": "string",
"field": "gender",
"label": "性别(枚举)",
"value": null,
"describe": "0(男),1(女)",
"is_required": false
},
{
"type": "string",
"field": "age",
"label": "年龄",
"value": null,
"describe": "18",
"is_required": false
},
{
"type": "string",
"field": "birthday",
"label": "生日",
"value": null,
"describe": "43671",
"is_required": false
},
{
"type": "string",
"field": "calendarType",
"label": "生日日期类型(枚举)",
"value": null,
"describe": "0(公历),1(阴历)",
"is_required": false
},
{
"type": "string",
"field": "phone",
"label": "联系电话",
"value": null,
"describe": "13588889999",
"is_required": false
},
{
"type": "string",
"field": "email",
"label": "email",
"value": null,
"describe": "13588889999@163.com",
"is_required": false
},
{
"type": "string",
"field": "qq",
"label": "QQ",
"value": null,
"describe": "1135888899",
"is_required": false
},
{
"type": "string",
"field": "weiXin",
"label": "微信",
"value": null,
"describe": "chat11111",
"is_required": false
},
{
"type": "string",
"field": "taxNumber",
"label": "开票税号",
"value": null,
"describe": "SH123456798",
"is_required": false
},
{
"type": "string",
"field": "customerManager",
"label": "客户经理id",
"value": null,
"describe": "a1d56ad1q56da321",
"is_required": false
},
{
"type": "string",
"field": "customerManagerName",
"label": "客户经理名称",
"value": null,
"describe": "王五",
"is_required": false
},
{
"type": "string",
"field": "refereeId",
"label": "客户经理名称",
"value": null,
"describe": "52691345816821",
"is_required": false
},
{
"type": "string",
"field": "referee",
"label": "推荐人名称",
"value": null,
"describe": "王五",
"is_required": false
},
{
"type": "string",
"field": "specialReminding",
"label": "特别提醒",
"value": null,
"describe": "重点客户",
"is_required": false
},
{
"type": "string",
"field": "customerType",
"label": "客户类别id",
"value": null,
"describe": "ada8z32c1a56asdc",
"is_required": false
},
{
"type": "string",
"field": "customerTypeName",
"label": "客户类别名称",
"value": null,
"describe": "类别1",
"is_required": false
}
],
"response": [],
"otherRequest": [],
"otherResponse": []
}