轻易云
注册体验

MySQL和吉客云单据接口对接

1 条评论

MySQL和吉客云单据接口对接

API数据集成

数据源系统:吉客云

吉客云是基于“网店管家”十五年电商ERP行业和技术积累基础上顺应产业发展需求，重新定位、全新设计推出的换代产品，从业务数字化和组织数字化两个方向出发，以构建流程的闭环为依归，致力于为企业的数字化升级提供落地工具。

集成系统:MySQL

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

数据接口配置

轻易云集成平台的对接是通过一个个对应的对接方案去形成两个系统对接的连线，所以对接方案的配置极其重要，方案可以选择一键复制，轻易云有海量的对接方案可支持一键复制，复制后直接启动使用（对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息。或者可以通过手工配置，配置只要确认源平台：吉客云的取数逻辑，例如什么时间取什么样的数据。即可完成配置，目标平台：MySQL，把获取的数据组装成目标系统需要的格式进行写入。
多系统间数据对接

吉客云接口明细

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

请求参数

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

响应参数

字段名称类型描述 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接口明细

  • API：execute
  • NAME：执行操作-v1
  • METHOD：POST

请求参数

接口字段字段名称预设值描述 main_params主参数 main_params.bill_no单据编号{{allocateNo}} main_params.status状态1 main_params.stock_org_id调入库存组织findCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{intWarehouseCode}} main_params.date日期_function FROM_UNIXTIME( ( {{auditDate}} / 1000 ) ,'%Y-%m-%d %T' ) main_params.bill_type_id单据类型ZJDB01_SYS main_params.owner_type_id_head调入货主类型BD_OwnerOrg main_params.owner_id_head调入货主??findCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{intWarehouseCode}} main_params.transfer_type调拨类型InnerOrgTransfer main_params.stock_out_org_id调出库存组织_findCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{outWarehouseCode}} main_params.owner_type_out_id_head调出货主类型BD_OwnerOrg main_params.owner_out_id_head调出货主??findCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{outWarehouseCode}} main_params.transfer_direction调拨方向GENERAL main_params.remark备注{{memo}} main_params.create_time创建时间_function FROM_UNIXTIME( ( {{gmtCreate}} / 1000 ) ,'%Y-%m-%d %T' ) main_params.created_by创建者{{applyUserName}} main_params.update_time更新时间_function FROM_UNIXTIME( ( {{auditDate}} / 1000 ) ,'%Y-%m-%d %T' ) main_params.updated_by更新者{{auditUserName}} main_params.extend_params_11:1扩展参数stockAllocateDetailViews main_params.extend_params_1.lastInsertIdorder_id:lastInsertId main_params.extend_params_1.material_id物料编码{{stockAllocateDetailViews.goodsNo}} main_params.extend_params_1.src_stock_id调出仓库{{outWarehouseId}} main_params.extend_params_1.dest_stock_id调入仓库{{inWarehouseId}} main_params.extend_params_1.unit_id单位idPcs main_params.extend_params_1.qty数量{{stockAllocateDetailViews.skuCount}} main_params.extend_params_1.remark备注{{stockAllocateDetailViews.rowRemark}} main_params.extend_params_1.source_id源单id?? main_params.extend_params_1.source_detail_id源单明细行id?? main_params.extend_params_1.source_code源单单号?? main_params.extend_params_1.source_type源单类型?? main_params.extend_params_1.main_sql主语句INSERT 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扩展语句INSERT 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: }>);

系统集成总览

通过数据集成平台可视化的快速配置调用接口打通吉客云与MySQL之间的数据接口，使得两个系统之间的对接更加快捷、稳定。轻易云数据集成平台打破信息孤岛、适配多种场景、降低运营成本、缩短开发周期、灵活调度配置是这种多系统数据打通时的特性优势。采用元数据模型驱动的低代码集成工具，基于系统预置的数据模型、映射、编排、日志、脚本等集成核心引擎，通过可视化配置，快速实现客户灵活多变的动态集成需求，让集成开发简单、执行过程可靠、问题风险可控。
系统接口打通

论坛热帖