源系统平台:钉钉
源系统接口: 钉钉回调事件钉钉回调事件
目标系统平台: 金蝶云星空
目标系统接口: 采购订单新增batchSave
源平台元数据配置:
{
"id": null,
"api": "钉钉回调事件",
"type": "QUERY",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"id": "type",
"type": "string",
"field": "type",
"label": "审核事件",
"value": "finish",
"parent": null,
"describe": "可以过滤 启动:start,完成:finish",
"is_required": true
},
{
"id": "result",
"type": "string",
"field": "result",
"label": "审核结果",
"value": "agree",
"parent": null,
"describe": "审核的结果是同意agree还是不同意unagree",
"is_required": true
},
{
"id": "processCode",
"type": "string",
"field": "processCode",
"label": "审核表单模板ID",
"value": "PROC-FE56D27F-A41F-43FE-AF0B-D23A217131E8",
"parent": null,
"describe": "打开钉钉的模板编辑页面查看,网址参数中有该模板ID",
"is_required": true
}
],
"response": [
{
"type": "string",
"field": "金蝶采购单号",
"label": "文本",
"value": null,
"parent": null
},
{
"type": "string",
"field": "供应商",
"label": "文本",
"value": null,
"parent": null
},
{
"type": "string",
"field": "日期",
"label": "日期",
"value": null,
"parent": null
},
{
"type": "array",
"field": "报价明细",
"label": "表格",
"value": "报价明细",
"parent": null,
"children": [
{
"type": "string",
"field": "物料编码",
"label": "文本",
"value": null,
"parent": null
},
{
"type": "string",
"field": "数量",
"label": "数字",
"value": null,
"parent": null
},
{
"type": "string",
"field": "单价",
"label": "数字",
"value": null,
"parent": null
}
]
},
{
"type": "string",
"field": "备注",
"label": "文本",
"value": null,
"parent": null
},
{
"type": "string",
"field": "title",
"label": "文本",
"value": null,
"parent": null
}
],
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{金蝶采购单号}}"
},
{
"type": "string",
"field": "FDate",
"label": "采购日期",
"value": "{{日期}}"
},
{
"type": "string",
"field": "FPurchaseOrgId",
"label": "采购组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FSupplierId",
"label": "供应商",
"value": "0003",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "CGDD01_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FBusinessType",
"label": "业务类型",
"value": "CG"
},
{
"type": "array",
"field": "FPOOrderEntry",
"label": "明细信息",
"value": "报价明细",
"children": [
{
"type": "string",
"field": "FMaterialId",
"label": "物料编码",
"value": "{{报价明细.物料编码}}",
"parent": "FPOOrderEntry",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FQty",
"label": "采购数量",
"value": "{{报价明细.数量}}",
"parent": "FPOOrderEntry"
},
{
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": "{{报价明细.单价}}",
"parent": "FPOOrderEntry"
},
{
"type": "string",
"field": "FReceiveOrgId",
"label": "收料组织",
"value": "100",
"parent": "FPOOrderEntry",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FRequireOrgId",
"label": "需求组织",
"value": "100",
"parent": "FPOOrderEntry",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FEntryPayOrgId",
"label": "付款组织",
"value": "100",
"parent": "FPOOrderEntry",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FEntrySettleOrgId",
"label": "结算组织",
"value": "100",
"parent": "FPOOrderEntry",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
}
]
}
],
"response": [],
"operation": {
"rows": 2,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "PUR_PurchaseOrder"
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "BatchSave"
},
{
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "true"
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false"
}
],
"otherResponse": []
}