源系统平台:管易云
源系统接口: 店铺查询gy.erp.shop.get
目标系统平台: 金蝶云星空
目标系统接口: 部门新增batchSave
源平台元数据配置:
{
"id": "id",
"api": "gy.erp.shop.get",
"type": "QUERY",
"method": "POST",
"number": "code",
"idCheck": true,
"request": [
{
"type": "string",
"field": "modify_start_date",
"label": "修改时间开始段",
"value": "{{LAST_SYNC_TIME|datetime}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "modify_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": "id",
"label": "ID",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "nick",
"label": "店铺昵称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "code",
"label": "代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "name",
"label": "名称",
"value": null,
"describe": null,
"is_required": false
},
{
"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": "note",
"label": "备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "type_name",
"label": "类型",
"value": null,
"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": "{{name}}",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": "{{code}}",
"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": "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": []
}