金蝶云星空和马帮接口打通对接实战数据源系统:金蝶云星空金蝶K/3Cloud在总结百万家客户管理最佳实践的基础上，提供了标准的管理模式；通过标准的业务架构：多会计准则、多币别、多地点、多组织、多税制应用框架等，有效支持企业的运营管理；K/3Cloud提供了标准的业务建模：35种标准ERP领域模型、1046种模型元素、21243种模型元素属性组合，288个业务服务构件，让企业及伙伴可快速构建出行业化及个性化的应用。写入目标:马帮马帮ERP隶属于上海马帮科技有限公司，马帮ERP成立十余年，聚焦服务于各阶段、各领域的跨境电商从业者，为跨境卖家提供订单处理、商品库存管理、采购供应链管理，物流渠道管理、WMS仓储发货等全流程跨境电商解决方案管理软件。国内外团队800多人，跨境业务范围遍布全国20多个城市，已开通海外东南亚本地化服务。我们已经服务超20万家电商卖家，对接电商近100家主流平台、1000多家物流公司、多家跨境主流收款工具数据对接方案使用轻易云系统数据集成平台对应的模块：数据集成方案。然后选择开始创建数据集成方案。在方案配置表单中选择对应的源业务系统：金蝶云星空，然后选择对应的连接器。选择对应的物料查询作为数据对接来源。然后再通过写入目标平台配置目标系统为马帮,并且选择对应连接器（关于马帮的接口如何配置可以在轻易云数据集成社区论坛中找到相关信息,选择好对应的新增自建仓库接口作为数据写入动作，既可以完成第一步的数据对接配置。金蝶云星空接口明细 API： executeBillQuery NAME：物料查询 METHOD： POST 请求参数接口字段字段名称预设值描述 FMATERIALID FMATERIALID FMATERIALID 111 FNumber FNumber FNumber 111 FName FName FName 111 FSpecification FSpecification FSpecification 111 FOldNumber FOldNumber FOldNumber 111 FBARCODE FBARCODE FBARCODE 111 FDescription FDescription FDescription 111 FMaterialGroup_FNumber FMaterialGroup_FNumber FMaterialGroup.FNumber 111 FErpClsID FErpClsID FErpClsID 111 FDocumentStatus FDocumentStatus FDocumentStatus 111 FForbidStatus FForbidStatus FForbidStatus 111 FBaseUnitId_FNumber FBaseUnitId_FNumber FBaseUnitId.FNumber 111 FCreateOrgId_FNumber FCreateOrgId_FNumber FCreateOrgId.FNumber 111 FUseOrgId_FNumber FUseOrgId_FNumber FUseOrgId.FNumber 111 FIsInventory FIsInventory FIsInventory 111 FIsSale FIsSale FIsSale 111 FIsAsset FIsAsset FIsAsset 111 FIsSubContract FIsSubContract FIsSubContract 111 FIsProduce FIsProduce FIsProduce 111 FIsPurchase FIsPurchase FIsPurchase 111 FStockId_FNumber FStockId_FNumber FStockId.FNumber 111 FPurchaseOrgId_FNumber FPurchaseOrgId_FNumber FPurchaseOrgId.FNumber 111 FPurchaseOrgId_FName FPurchaseOrgId_FName FPurchaseOrgId.FName 111 FIsBatchManage FIsBatchManage FIsBatchManage 111 FIsKFPeriod FIsKFPeriod FIsKFPeriod 111 FIsSNManage FIsSNManage FIsSNManage 111 FSafeStock FSafeStock FSafeStock 111 FCategoryID FCategoryID FCategoryID 111 FExpPeriod FExpPeriod FExpPeriod 111 FOrderQty FOrderQty FOrderQty 111 FMinQty FMinQty FMinQty 111 FMaxQty FMaxQty FMaxQty 111 FDefaultVendor_FNumber FDefaultVendor_FNumber FDefaultVendor.FNumber 111 FMaxPOQty FMaxPOQty FMaxPOQty 111 FMinPOQty FMinPOQty FMinPOQty 111 FIncreaseQty FIncreaseQty FIncreaseQty 111 FFixLeadTime FFixLeadTime FFixLeadTime 111 FVarLeadTime FVarLeadTime FVarLeadTime 111 FPlanBatchSplitQty FPlanBatchSplitQty FPlanBatchSplitQty 111 FProduceBillType_FNumber FProduceBillType_FNumber FProduceBillType.FNumber 111 FPOBillTypeId_FNumber FPOBillTypeId_FNumber FPOBillTypeId.FNumber 111 FSubBillType_FNumber FSubBillType_FNumber FSubBillType.FNumber 111 FGROSSWEIGHT FGROSSWEIGHT FGROSSWEIGHT 111 FNETWEIGHT FNETWEIGHT FNETWEIGHT 111 FWEIGHTUNITID_FNumber FWEIGHTUNITID_FNumber FWEIGHTUNITID.FNumber 111 FLENGTH FLENGTH FLENGTH 111 FWIDTH FWIDTH FWIDTH 111 FHEIGHT FHEIGHT FHEIGHT 111 FVOLUME FVOLUME FVOLUME 111 FWARRANTY FWARRANTY FWARRANTY 111 FSalePrice_CMK FSalePrice_CMK FSalePrice_CMK 111 FVIPPrice_CMK FVIPPrice_CMK FVIPPrice_CMK 111 FPurPrice_CMK FPurPrice_CMK FPurPrice_CMK 111 FComBrandId_CMK_FNumber FComBrandId_CMK_FNumber FComBrandId_CMK.FNumber 111 Limit Limit {{PAGINATION_PAGE_SIZE}} 金蝶的查询分页参数 StartRow StartRow {{PAGINATION_START_ROW}} 金蝶的查询分页参数 TopRowCount TopRowCount 金蝶的查询分页参数 FilterString FilterString FApproveDate>='{{LAST_SYNC_TIME dateTime}}' 示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>= FieldKeys FieldKeys {{MAIN_REQUEST}} 金蝶分录主键ID格式：FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber FormId FormId BD_MATERIAL 必须填写金蝶的表单ID如😛UR_PurchaseOrder 响应参数接口字段字段名称预设值描述 FMATERIALID FMATERIALID 1 111 FNumber FNumber 1 111 FName FName 1 111 FSpecification FSpecification 1 111 FOldNumber FOldNumber 1 111 FBARCODE FBARCODE 1 111 FDescription FDescription 1 111 FMaterialGroup_FNumber FMaterialGroup_FNumber 1 111 FErpClsID FErpClsID 1 111 FDocumentStatus FDocumentStatus 1 111 FForbidStatus FForbidStatus 1 111 FBaseUnitId_FNumber FBaseUnitId_FNumber 1 111 FCreateOrgId_FNumber FCreateOrgId_FNumber 1 111 FUseOrgId_FNumber FUseOrgId_FNumber 1 111 FIsInventory FIsInventory 1 111 FIsSale FIsSale 1 111 FIsAsset FIsAsset 1 111 FIsSubContract FIsSubContract 1 111 FIsProduce FIsProduce 1 111 FIsPurchase FIsPurchase 1 111 FStockId_FNumber FStockId_FNumber 1 111 FPurchaseOrgId_FNumber FPurchaseOrgId_FNumber 1 111 FPurchaseOrgId_FName FPurchaseOrgId_FName 1 111 FIsBatchManage FIsBatchManage 1 111 FIsKFPeriod FIsKFPeriod 1 111 FIsSNManage FIsSNManage 1 111 FSafeStock FSafeStock 1 111 FCategoryID FCategoryID 1 111 FExpPeriod FExpPeriod 1 111 FOrderQty FOrderQty 1 111 FMinQty FMinQty 1 111 FMaxQty FMaxQty 1 111 FDefaultVendor_FNumber FDefaultVendor_FNumber 1 111 FMaxPOQty FMaxPOQty 1 111 FMinPOQty FMinPOQty 1 111 FIncreaseQty FIncreaseQty 1 111 FFixLeadTime FFixLeadTime 1 111 FVarLeadTime FVarLeadTime 1 111 FPlanBatchSplitQty FPlanBatchSplitQty 1 111 FProduceBillType_FNumber FProduceBillType_FNumber 1 111 FPOBillTypeId_FNumber FPOBillTypeId_FNumber 1 111 FSubBillType_FNumber FSubBillType_FNumber 1 111 FGROSSWEIGHT FGROSSWEIGHT 1 111 FNETWEIGHT FNETWEIGHT 1 111 FWEIGHTUNITID_FNumber FWEIGHTUNITID_FNumber 1 111 FLENGTH FLENGTH 1 111 FWIDTH FWIDTH 1 111 FHEIGHT FHEIGHT 1 111 FVOLUME FVOLUME 1 111 FWARRANTY FWARRANTY 1 111 FSalePrice_CMK FSalePrice_CMK 1 111 FVIPPrice_CMK FVIPPrice_CMK 1 111 FPurPrice_CMK FPurPrice_CMK 1 111 FComBrandId_CMK_FNumber FComBrandId_CMK_FNumber 1 111 马帮接口明细接口： stock-do-change-stock 接口名称：新增自建仓库接口方法： POST 请求参数字段名称类型描述 stockSku 库存sku string 111 status 商品状态 string 系统集成总览全新的API数据集成模式，赋能企业业务创新传统企业集成主要采用点对点或ESB集成方式，基于全新API战略中台的API新型集成方式通过解耦系统资源，降低系统间对接难度，实现快速业务需求响应，提升对接效率，助力企业满足快速业务交付需求，实现业务创新。通过构建API生态，助力能力开放与共享基于API战略中台梳理并整合内部API资源与IT资产，可实现内部资源共享，满足内部开发人员资源使用需求，例如：马帮与金蝶云星空之间数据集成；并将API资源对外可控开放，打造面向开发者的生态服务，为您打通自身和上下游合作伙伴，创造共赢价值链。开展API战略中台，重塑IT 帮助您基于内部资源构建不同业务能力中心，打造企业统一API战略中台，赋能企业发展，实现对业务频繁变化的快速响应。同时您在能力中心基础上构建新业务时，无需从“零”组建各业务模块，提升开发效率，重塑IT组织及交付能力。

金蝶云星空和马帮接口打通对接实战

刘培强qeasy

金蝶云星空和马帮接口打通对接实战

数据源系统:金蝶云星空

金蝶K/3Cloud在总结百万家客户管理最佳实践的基础上，提供了标准的管理模式；通过标准的业务架构：多会计准则、多币别、多地点、多组织、多税制应用框架等，有效支持企业的运营管理；K/3Cloud提供了标准的业务建模：35种标准ERP领域模型、1046种模型元素、21243种模型元素属性组合，288个业务服务构件，让企业及伙伴可快速构建出行业化及个性化的应用。

写入目标:马帮

马帮ERP隶属于上海马帮科技有限公司，马帮ERP成立十余年，聚焦服务于各阶段、各领域的跨境电商从业者，为跨境卖家提供订单处理、商品库存管理、采购供应链管理，物流渠道管理、WMS仓储发货等全流程跨境电商解决方案管理软件。国内外团队800多人，跨境业务范围遍布全国20多个城市，已开通海外东南亚本地化服务。我们已经服务超20万家电商卖家，对接电商近100家主流平台、1000多家物流公司、多家跨境主流收款工具

数据对接方案

使用轻易云系统数据集成平台对应的模块：数据集成方案。然后选择开始创建数据集成方案。在方案配置表单中选择对应的源业务系统：金蝶云星空，然后选择对应的连接器。选择对应的物料查询作为数据对接来源。然后再通过写入目标平台配置目标系统为马帮,并且选择对应连接器（关于马帮的接口如何配置可以在轻易云数据集成社区论坛中找到相关信息,选择好对应的新增自建仓库接口作为数据写入动作，既可以完成第一步的数据对接配置。

金蝶云星空接口明细

API：executeBillQuery
NAME：物料查询
METHOD：POST

请求参数

接口字段	字段名称	预设值	描述
FMATERIALID	FMATERIALID	FMATERIALID	111
FNumber	FNumber	FNumber	111
FName	FName	FName	111
FSpecification	FSpecification	FSpecification	111
FOldNumber	FOldNumber	FOldNumber	111
FBARCODE	FBARCODE	FBARCODE	111
FDescription	FDescription	FDescription	111
FMaterialGroup_FNumber	FMaterialGroup_FNumber	FMaterialGroup.FNumber	111
FErpClsID	FErpClsID	FErpClsID	111
FDocumentStatus	FDocumentStatus	FDocumentStatus	111
FForbidStatus	FForbidStatus	FForbidStatus	111
FBaseUnitId_FNumber	FBaseUnitId_FNumber	FBaseUnitId.FNumber	111
FCreateOrgId_FNumber	FCreateOrgId_FNumber	FCreateOrgId.FNumber	111
FUseOrgId_FNumber	FUseOrgId_FNumber	FUseOrgId.FNumber	111
FIsInventory	FIsInventory	FIsInventory	111
FIsSale	FIsSale	FIsSale	111
FIsAsset	FIsAsset	FIsAsset	111
FIsSubContract	FIsSubContract	FIsSubContract	111
FIsProduce	FIsProduce	FIsProduce	111
FIsPurchase	FIsPurchase	FIsPurchase	111
FStockId_FNumber	FStockId_FNumber	FStockId.FNumber	111
FPurchaseOrgId_FNumber	FPurchaseOrgId_FNumber	FPurchaseOrgId.FNumber	111
FPurchaseOrgId_FName	FPurchaseOrgId_FName	FPurchaseOrgId.FName	111
FIsBatchManage	FIsBatchManage	FIsBatchManage	111
FIsKFPeriod	FIsKFPeriod	FIsKFPeriod	111
FIsSNManage	FIsSNManage	FIsSNManage	111
FSafeStock	FSafeStock	FSafeStock	111
FCategoryID	FCategoryID	FCategoryID	111
FExpPeriod	FExpPeriod	FExpPeriod	111
FOrderQty	FOrderQty	FOrderQty	111
FMinQty	FMinQty	FMinQty	111
FMaxQty	FMaxQty	FMaxQty	111
FDefaultVendor_FNumber	FDefaultVendor_FNumber	FDefaultVendor.FNumber	111
FMaxPOQty	FMaxPOQty	FMaxPOQty	111
FMinPOQty	FMinPOQty	FMinPOQty	111
FIncreaseQty	FIncreaseQty	FIncreaseQty	111
FFixLeadTime	FFixLeadTime	FFixLeadTime	111
FVarLeadTime	FVarLeadTime	FVarLeadTime	111
FPlanBatchSplitQty	FPlanBatchSplitQty	FPlanBatchSplitQty	111
FProduceBillType_FNumber	FProduceBillType_FNumber	FProduceBillType.FNumber	111
FPOBillTypeId_FNumber	FPOBillTypeId_FNumber	FPOBillTypeId.FNumber	111
FSubBillType_FNumber	FSubBillType_FNumber	FSubBillType.FNumber	111
FGROSSWEIGHT	FGROSSWEIGHT	FGROSSWEIGHT	111
FNETWEIGHT	FNETWEIGHT	FNETWEIGHT	111
FWEIGHTUNITID_FNumber	FWEIGHTUNITID_FNumber	FWEIGHTUNITID.FNumber	111
FLENGTH	FLENGTH	FLENGTH	111
FWIDTH	FWIDTH	FWIDTH	111
FHEIGHT	FHEIGHT	FHEIGHT	111
FVOLUME	FVOLUME	FVOLUME	111
FWARRANTY	FWARRANTY	FWARRANTY	111
FSalePrice_CMK	FSalePrice_CMK	FSalePrice_CMK	111
FVIPPrice_CMK	FVIPPrice_CMK	FVIPPrice_CMK	111
FPurPrice_CMK	FPurPrice_CMK	FPurPrice_CMK	111
FComBrandId_CMK_FNumber	FComBrandId_CMK_FNumber	FComBrandId_CMK.FNumber	111
Limit	Limit	{{PAGINATION_PAGE_SIZE}}	金蝶的查询分页参数
StartRow	StartRow	{{PAGINATION_START_ROW}}	金蝶的查询分页参数
TopRowCount	TopRowCount		金蝶的查询分页参数
FilterString	FilterString	FApproveDate>='{{LAST_SYNC_TIME dateTime}}'	示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=
FieldKeys	FieldKeys	{{MAIN_REQUEST}}	金蝶分录主键ID格式：FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber
FormId	FormId	BD_MATERIAL	必须填写金蝶的表单ID如😛UR_PurchaseOrder

响应参数

接口字段	字段名称	预设值	描述
FMATERIALID	FMATERIALID	1	111
FNumber	FNumber	1	111
FName	FName	1	111
FSpecification	FSpecification	1	111
FOldNumber	FOldNumber	1	111
FBARCODE	FBARCODE	1	111
FDescription	FDescription	1	111
FMaterialGroup_FNumber	FMaterialGroup_FNumber	1	111
FErpClsID	FErpClsID	1	111
FDocumentStatus	FDocumentStatus	1	111
FForbidStatus	FForbidStatus	1	111
FBaseUnitId_FNumber	FBaseUnitId_FNumber	1	111
FCreateOrgId_FNumber	FCreateOrgId_FNumber	1	111
FUseOrgId_FNumber	FUseOrgId_FNumber	1	111
FIsInventory	FIsInventory	1	111
FIsSale	FIsSale	1	111
FIsAsset	FIsAsset	1	111
FIsSubContract	FIsSubContract	1	111
FIsProduce	FIsProduce	1	111
FIsPurchase	FIsPurchase	1	111
FStockId_FNumber	FStockId_FNumber	1	111
FPurchaseOrgId_FNumber	FPurchaseOrgId_FNumber	1	111
FPurchaseOrgId_FName	FPurchaseOrgId_FName	1	111
FIsBatchManage	FIsBatchManage	1	111
FIsKFPeriod	FIsKFPeriod	1	111
FIsSNManage	FIsSNManage	1	111
FSafeStock	FSafeStock	1	111
FCategoryID	FCategoryID	1	111
FExpPeriod	FExpPeriod	1	111
FOrderQty	FOrderQty	1	111
FMinQty	FMinQty	1	111
FMaxQty	FMaxQty	1	111
FDefaultVendor_FNumber	FDefaultVendor_FNumber	1	111
FMaxPOQty	FMaxPOQty	1	111
FMinPOQty	FMinPOQty	1	111
FIncreaseQty	FIncreaseQty	1	111
FFixLeadTime	FFixLeadTime	1	111
FVarLeadTime	FVarLeadTime	1	111
FPlanBatchSplitQty	FPlanBatchSplitQty	1	111
FProduceBillType_FNumber	FProduceBillType_FNumber	1	111
FPOBillTypeId_FNumber	FPOBillTypeId_FNumber	1	111
FSubBillType_FNumber	FSubBillType_FNumber	1	111
FGROSSWEIGHT	FGROSSWEIGHT	1	111
FNETWEIGHT	FNETWEIGHT	1	111
FWEIGHTUNITID_FNumber	FWEIGHTUNITID_FNumber	1	111
FLENGTH	FLENGTH	1	111
FWIDTH	FWIDTH	1	111
FHEIGHT	FHEIGHT	1	111
FVOLUME	FVOLUME	1	111
FWARRANTY	FWARRANTY	1	111
FSalePrice_CMK	FSalePrice_CMK	1	111
FVIPPrice_CMK	FVIPPrice_CMK	1	111
FPurPrice_CMK	FPurPrice_CMK	1	111
FComBrandId_CMK_FNumber	FComBrandId_CMK_FNumber	1	111

马帮接口明细

接口：stock-do-change-stock
接口名称：新增自建仓库
接口方法：POST

请求参数

字段	名称	类型	描述
stockSku	库存sku	string	111
status	商品状态	string

系统集成总览

全新的API数据集成模式，赋能企业业务创新传统企业集成主要采用点对点或ESB集成方式，基于全新API战略中台的API新型集成方式通过解耦系统资源，降低系统间对接难度，实现快速业务需求响应，提升对接效率，助力企业满足快速业务交付需求，实现业务创新。通过构建API生态，助力能力开放与共享基于API战略中台梳理并整合内部API资源与IT资产，可实现内部资源共享，满足内部开发人员资源使用需求，例如：马帮与金蝶云星空之间数据集成；并将API资源对外可控开放，打造面向开发者的生态服务，为您打通自身和上下游合作伙伴，创造共赢价值链。开展API战略中台，重塑IT 帮助您基于内部资源构建不同业务能力中心，打造企业统一API战略中台，赋能企业发展，实现对业务频繁变化的快速响应。同时您在能力中心基础上构建新业务时，无需从“零”组建各业务模块，提升开发效率，重塑IT组织及交付能力。