源系统平台：管易云
源系统接口： 商品查询gy.erp.items.get
目标系统平台： 金蝶云星空
目标系统接口： 物料新增batchSave
源平台元数据配置：
{
"id": "id",
"api": "gy.erp.items.get",
"type": "QUERY",
"method": "POST",
"number": "code",
"idCheck": true,
"request": [
{
"type": "string",
"field": "start_date",
"label": "修改时间开始段",
"value": "{{LAST_SYNC_TIME|datetime}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "end_date",
"label": "修改时间结束段",
"value": "{{CURRENT_TIME|datetime}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "code",
"label": "商品代码",
"value": null,
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "create_date",
"label": "创建时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "modify_date",
"label": "修改时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "combine",
"label": "是否为组合商品",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "del",
"label": "是否已停用",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "length",
"label": "长",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "width",
"label": "宽",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "height",
"label": "高",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "simple_name",
"label": "商品简称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "category_code",
"label": "分类代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "category_name",
"label": "分类名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "supplier_code",
"label": "供应商代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "item_unit_code",
"label": "商品单位代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "item_unit_name",
"label": "商品单位名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "pic_url",
"label": "图片地址",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shelf_life",
"label": "保质期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "warning_days",
"label": "预警天数",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "combine_items",
"label": "组合明细",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "custom_attr",
"label": "自定义属性",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "item_add_attribute",
"label": "商品附加属性",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "item_brand_code",
"label": "品牌代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "item_brand_name",
"label": "品牌名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "skus",
"label": "sku",
"children": [
{
"type": "string",
"field": "id",
"label": "规格ID",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "code",
"label": "规格代码",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "name",
"label": "规格名称",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "note",
"label": "备注",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "weight",
"label": "重量",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "volume",
"label": "体积",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "package_point",
"label": "打包积分",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sales_point",
"label": "销售积分",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sales_price",
"label": "标准售价",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "purchase_price",
"label": "标准进价",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "agent_price",
"label": "代理售价",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "cost_price",
"label": "成本价",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "stock_status_code",
"label": "库存状态代码",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "tax_no",
"label": "税号",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "tax_rate",
"label": "税率",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "origin_area",
"label": "原产地",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "supplier_outerid",
"label": "供应商货号",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "bar_code",
"label": "商品条码",
"value": null,
"parent": "skus",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"type": "string",
"field": "page_size",
"label": "分页大小",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "默认为10",
"is_required": false
},
{
"type": "string",
"field": "page_no",
"label": "页号",
"value": "{{PAGINATION_START_PAGE}}",
"describe": "默认1",
"is_required": false
}
],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FName",
"label": "名称",
"value": "{{skus.name}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": "{{skus.code}}-test",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDescription",
"label": "描述",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCreateOrgId",
"label": "创建组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FUseOrgId",
"label": "使用组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSpecification",
"label": "规格型号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMnemonicCode",
"label": "助记码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "object",
"field": "SubHeadEntity",
"label": "基本",
"value": "undefined{{skus.note}}",
"children": [
{
"type": "string",
"field": "FErpClsID",
"label": "物料属性",
"value": "1",
"parent": "SubHeadEntity",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBaseUnitId",
"label": "基本单位",
"value": "Pcs",
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCategoryID",
"label": "存货类别",
"value": "CHLB05_SYS",
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBARCODE",
"label": "条形码",
"value": null,
"parent": "SubHeadEntity",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": true
},
{
"type": "object",
"field": "SubHeadEntity1",
"label": "库存",
"children": [
{
"type": "string",
"field": "FStockId",
"label": "仓库",
"value": null,
"parent": "SubHeadEntity1",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSafeStock",
"label": "安全库存",
"value": null,
"parent": "SubHeadEntity1",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "object",
"field": "SubHeadEntity2",
"label": "销售",
"children": [
{
"type": "string",
"field": "FMaxQty",
"label": "最大批量",
"value": null,
"parent": "SubHeadEntity2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMinQty",
"label": "最小批量",
"value": null,
"parent": "SubHeadEntity2",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "object",
"field": "SubHeadEntity3",
"label": "采购",
"children": [
{
"type": "string",
"field": "FDefaultVendor",
"label": "默认供应商",
"value": null,
"parent": "SubHeadEntity3",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPurchaseOrgId",
"label": "采购组织",
"value": null,
"parent": "SubHeadEntity3",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"response": [],
"operation": {
"rows": 1,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "BD_MATERIAL",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "Save",
"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": []
}
