轻易云
注册体验

吉客云和MySQL接口打通对接实战

1 条评论

吉客云和MySQL接口打通对接实战

金蝶如何对接

对接系统吉客云

杭州吉客云网络技术有限公司是经国家认定的高新技术企业，是国内领先的SaaSERP软件服务商，致力于为企业提供安全稳定、高可用性和高扩展性的一站式数字化解决方案。

接通系统：MySQL

MySQL是一个关系型数据库管理系统，由瑞典MySQLAB公司开发，属于Oracle旗下产品。MySQL是最流行的关系型数据库管理系统之一，在WEB应用方面，MySQL是最好的RDBMS(RelationalDatabaseManagementSystem，关系数据库管理系统)应用软件之一。

系统对接接口配置

系统对接前期需要通过调研公司的业务，规划出最便捷，效率最高的整体流程。通过流程我们需要建立对应的方案来吧这些流程一一的落地，轻易云集成平台开箱即用的、可视化拖、拉、拽实现接口服务编排与聚合。只需要根据指引设定好对应的参数即可启动使用。设定好源平台：吉客云的接口参数设置，以及设定好目标平台：MySQL的映射，即可启动方案进行测试
金蝶KIS接口集成
用友ERP对接

吉客云接口明细

  • 调用接口：erp.allocate.get
  • 接口名称：调拨查询
  • 方法：POST

请求参数

字段字段名称类型配置值 pageIndex页码(默认从0开始)string pageSize每页条数(默认50)string50 status调拨单状态（多个中间逗号隔开)string startCreateTime创建时间的起始时间string{{LAST_SYNC_TIME datetime}} endCreateTime创建时间结束时间string{{CURRENT_TIME datetime}} inWarehouseCode调入仓库编号string outSkuCode外部货品主键（支持批量 例:123,456）string outWarehouseCode调出仓库编号string allocateNos调拨单号,多个中间逗号隔开string instatus入库状态 （支持批量查询，多个值逗号隔开 1=入库等待，2=部分入库，3=入库完成）string3 outstatus出库状态（支持批量，多个值逗号隔开 1=出库等待，2=部分出库，3=出库完成）string3

响应参数

字段字段名称类型配置值 isAllocateDifferentCompany是否跨公司调拨(0-否 1-是)string allocateNo调拨单号string outWarehouseId调出仓库idstring inWarehouseId调入仓库idstring outWarehouseCode调出仓库编号string intWarehouseCode调入仓库编号string outWarehouseName调出仓库名称string intWarehouseName调入仓库名称string allocateType调拨类型:0=同价调拨1=异价调拨string allocatePrice1=批发价，2=零售价，3=会员价string applyUserId申请人id,关联用户表string applyUserName申请人姓名string applyDepartId申请部门idstring applyDepartName申请人部门string applyDate申请时间string operator制单人string operatorId制单人idstring auditUserId审核人idstring auditUserName审核人姓名string auditDate审核时间(时间戳)string status0=草稿1=待审核2=已审核3=已关闭 10-审核中string outStatus出库状态1=出库等待2=部分出库3=出库完成string inStatus入库状态1=入库等待2=部分入库3=入库完成string memo备注string goodsCount货品种类string gmtCreate创建时间(时间戳)string allocatePriceType调拨价格类型:1=批发价，2=零售价，3=会员价string flagData标记Id集合string companyId公司idstring companyName公司名称string planOutDate预计出库时间(时间戳)string planInDate预计入库时间(时间戳)string stockAllocateDetailViews库存调拨明细array stockAllocateDetailViews.allocateId调拨单id,关联调拨单string stockAllocateDetailViews.skuCount数量string stockAllocateDetailViews.totalAmount总金额string stockAllocateDetailViews.allocateDetailId主键idstring stockAllocateDetailViews.goodsId货品idstring stockAllocateDetailViews.goodsName货品名称（冗余字段）string stockAllocateDetailViews.skuIdskuidstring stockAllocateDetailViews.skuNamesku名称，冗余字段string stockAllocateDetailViews.unitName计量单位名称（冗余字段）string stockAllocateDetailViews.skuPrice单价string stockAllocateDetailViews.outCount已出库数量string stockAllocateDetailViews.inCount已入库数量string stockAllocateDetailViews.isCertified是否正品string stockAllocateDetailViews.rowRemark备注string stockAllocateDetailViews.skuBarcode条形码string stockAllocateDetailViews.goodsNo商品编号string stockAllocateDetailViews.assistUnit辅助单位string stockAllocateDetailViews.outSkuCode外部货品主键string stockAllocateDetailViews.isNegativeStock是否允许负库存出库1-是 空或者0是否string stockAllocateDetailViews.stockAllocateExpressInfo收发货人信息array stockAllocateDetailViews.stockAllocateExpressInfo.id主键idstring stockAllocateDetailViews.stockAllocateExpressInfo.relDataNo关联入库申请单编号string stockAllocateDetailViews.stockAllocateExpressInfo.sendCompanyName发件公司名称string stockAllocateDetailViews.stockAllocateExpressInfo.send发件人string stockAllocateDetailViews.stockAllocateExpressInfo.sendTel发件人电话string stockAllocateDetailViews.stockAllocateExpressInfo.sendPhone发件人手机号string stockAllocateDetailViews.stockAllocateExpressInfo.sendEmail发件人邮箱string stockAllocateDetailViews.stockAllocateExpressInfo.sendCountryName发件人国家string stockAllocateDetailViews.stockAllocateExpressInfo.sendProvinceName发件人省string stockAllocateDetailViews.stockAllocateExpressInfo.sendCityName发件人市string stockAllocateDetailViews.stockAllocateExpressInfo.sendTownName发件人镇，区string stockAllocateDetailViews.stockAllocateExpressInfo.sendStreetName发件人街道string stockAllocateDetailViews.stockAllocateExpressInfo.sendAddress发件人详细地址string stockAllocateDetailViews.stockAllocateExpressInfo.receiveCompanyName收件公司名称string stockAllocateDetailViews.stockAllocateExpressInfo.receive收件人string stockAllocateDetailViews.stockAllocateExpressInfo.receiveTel收件人电话string stockAllocateDetailViews.stockAllocateExpressInfo.receivePhone收件人手机号string stockAllocateDetailViews.stockAllocateExpressInfo.receiveEmail收件人邮箱string stockAllocateDetailViews.stockAllocateExpressInfo.receiveCountryName收件人国家string stockAllocateDetailViews.stockAllocateExpressInfo.receiveProvinceName收件人省string stockAllocateDetailViews.stockAllocateExpressInfo.receiveCityName收件人市string stockAllocateDetailViews.stockAllocateExpressInfo.receiveTownName收件人镇，区string stockAllocateDetailViews.stockAllocateExpressInfo.receiveStreetName收件人街道string stockAllocateDetailViews.stockAllocateExpressInfo.receiveAddress收件人详细地址string

MySQL接口明细

  • 调用接口：execute
  • 接口名称：执行操作-v1
  • 方法：POST

请求参数

字段字段名称类型配置值 main_params主参数object main_params.bill_no单据编号string{{allocateNo}} main_params.status状态string1 main_params.stock_org_id调入库存组织stringfindCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{intWarehouseCode}} main_params.date日期string_function FROM_UNIXTIME( ( {{auditDate}} / 1000 ) ,'%Y-%m-%d %T' ) main_params.bill_type_id单据类型stringZJDB01_SYS main_params.owner_type_id_head调入货主类型stringBD_OwnerOrg main_params.owner_id_head调入货主??stringfindCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{intWarehouseCode}} main_params.transfer_type调拨类型stringInnerOrgTransfer main_params.stock_out_org_id调出库存组织string_findCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{outWarehouseCode}} main_params.owner_type_out_id_head调出货主类型stringBD_OwnerOrg main_params.owner_out_id_head调出货主??stringfindCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{outWarehouseCode}} main_params.transfer_direction调拨方向stringGENERAL main_params.remark备注string{{memo}} main_params.create_time创建时间string_function FROM_UNIXTIME( ( {{gmtCreate}} / 1000 ) ,'%Y-%m-%d %T' ) main_params.created_by创建者string{{applyUserName}} main_params.update_time更新时间string_function FROM_UNIXTIME( ( {{auditDate}} / 1000 ) ,'%Y-%m-%d %T' ) main_params.updated_by更新者string{{auditUserName}} main_params.extend_params_11:1扩展参数arraystockAllocateDetailViews main_params.extend_params_1.lastInsertIdorder_idstring:lastInsertId main_params.extend_params_1.material_id物料编码string{{stockAllocateDetailViews.goodsNo}} main_params.extend_params_1.src_stock_id调出仓库string{{outWarehouseId}} main_params.extend_params_1.dest_stock_id调入仓库string{{inWarehouseId}} main_params.extend_params_1.unit_id单位idstringPcs main_params.extend_params_1.qty数量string{{stockAllocateDetailViews.skuCount}} main_params.extend_params_1.remark备注string{{stockAllocateDetailViews.rowRemark}} main_params.extend_params_1.source_id源单id??string main_params.extend_params_1.source_detail_id源单明细行id??string main_params.extend_params_1.source_code源单单号??string main_params.extend_params_1.source_type源单类型??string main_params.extend_params_1.main_sql主语句stringINSERT INTO lehua.wh_transfer_direct ( bill_no, status, stock_org_id, date, bill_type_id, owner_type_id_head, owner_id_head, transfer_type, stock_out_org_id, owner_type_out_id_head, owner_out_id_head, transfer_direction, remark, create_time, created_by, update_time, updated_by) VALUES ( <{bill_no: }>, <{status: }>, <{stock_org_id: }>, <{date: CURRENT_TIMESTAMP}>, <{bill_type_id: }>, <{owner_type_id_head: }>, <{owner_id_head: }>, <{transfer_type: }>, <{stock_out_org_id: }>, <{owner_type_out_id_head: }>, <{owner_out_id_head: }>, <{transfer_direction: }>, <{remark: }>, <{create_time: 0000-00-00 00:00:00}>, <{created_by: }>, <{update_time: 0000-00-00 00:00:00}>, <{updated_by: }>); main_params.extend_params_1.extend_sql_11:1扩展语句stringINSERT INTO lehua.wh_transfer_direct_detail ( order_id, material_id, src_stock_id, dest_stock_id, unit_id, qty, remark, source_id, source_detail_id, source_code, source_type) VALUES ( <{lastInsertId: }>, <{material_id: }>, <{src_stock_id: }>, <{dest_stock_id: }>, <{unit_id: }>, <{qty: }>, <{remark: }>, <{source_id: }>, <{source_detail_id: }>, <{source_code: }>, <{source_type: }>);

系统对接概况

当企业规模逐渐增大时，作为支撑业务运营的IT建设也变得越来越重要，不过往往企业的IT建设过程中会发现某一家软件供应商基本不能完全覆盖企业所有的业务运营流程，这样的结果就是，企业上的IT系统很多很全，从ERP到HR、CRM、PDM、OA等，貌似所有的业务都覆盖到了，但实际上因为这些系统的不集成，而形成了企业很多新的信息孤岛，非常不利于企业的后续的管理和战略发展。从现今和往后的发展趋势来看，也不可避免会遇到上述问题，毕竟企业经营的多样化，并不是所有的业务都能在一个系统中完成，所以我们必须在产品架构上支持更好的与外部系统进行协同。通过轻易云集成平台统一的API管理平台，对API进行显性化、可视化，使所有API服务成为企业的数字资产，提升API利用率，发挥业务系统价值，实现企业IT资产的可插拔、可复用、可组成。
旺店通对接

论坛热帖