从轻易云集成平台到旺店通·企业版通过接口配置打通数据

接入系统:轻易云集成平台
使用全界面可视化配置集成流,快速应对企业的集成需求使得系统与系统之间的数据接口一站式的快速集成能力,构建企业数据通道,解决数据孤岛问题。快速构建企业元数据标准、主数据标准、业财数据标准,完成数据的采集、统一、分发、清洗、归集等,帮助企业建立高质量的数据中台。目前轻易云平台已经支持300+系统,同时具备快速适配新系统的能力,集成海量接口数据。无论是对接ERP还是MES、OA、CRM、WMS、OMS等等系统,都可以通过接口相互集成。
写入目标:旺店通·企业版
旺店通是北京掌上先机网络科技有限公司旗下品牌,国内的零售云服务提供商,基于云计算SaaS服务模式,以体系化解决方案,助力零售企业数字化智能化管理升级。为零售电商企业的订单管理及仓储管理提供解决方案,致力于帮助企业实现数字化转型,企业规模化发展
系统对接接口配置
轻易云集成平台的对接是通过一个个对应的对接方案去形成两个系统对接的连线,所以对接方案的配置极其重要,方案可以选择一键复制,轻易云有海量的对接方案可支持一键复制,复制后直接启动使用(对接方案借鉴可以在轻易云系统数据集成交流社区bbs.qeasy.cloud 中找到相关信息。或者可以通过手工配置,配置只要确认源平台:轻易云集成平台的取数逻辑,例如什么时间取什么样的数据。即可完成配置,目标平台:旺店通·企业版,把获取的数据组装成目标系统需要的格式进行写入。

轻易云集成平台接口明细
- API:OpenCallback
- NAME:开放式的回调方法
- METHOD:POST
响应参数
| 接口字段 | 字段名称 | 预设值 | 描述 |
| bad_reason | bad_reason | | autoFillResponse |
| batch_no | batch_no | | _autoFillResponse |
| block_reason | block_reason | | autoFillResponse |
| buyer_message | buyer_message | | _autoFillResponse |
| calc_post_cost | calc_post_cost | | autoFillResponse |
| calc_weight | calc_weight | | _autoFillResponse |
| checker_name | checker_name | | autoFillResponse |
| checkouter_id | checkouter_id | | _autoFillResponse |
| cod_amount | cod_amount | | autoFillResponse |
| consign_status | consign_status | | _autoFillResponse |
| consign_time | consign_time | | autoFillResponse |
| consigner_id | consigner_id | | _autoFillResponse |
| created | created | | autoFillResponse |
| cs_remark | cs_remark | | _autoFillResponse |
| currency | currency | | autoFillResponse |
| custom_type | custom_type | | _autoFillResponse |
| customer_id | customer_id | | autoFillResponse |
| customer_name | customer_name | | _autoFillResponse |
| customer_no | customer_no | | autoFillResponse |
| delivery_term | delivery_term | | _autoFillResponse |
| details_list | details_list | | autoFillResponse |
| discount | discount | | _autoFillResponse |
| ebill_status | ebill_status | | autoFillResponse |
| employee_no | employee_no | | _autoFillResponse |
| error_info | error_info | | autoFillResponse |
| examiner_id | examiner_id | | _autoFillResponse |
| examiner_name | examiner_name | | autoFillResponse |
| examiner_no | examiner_no | | _autoFillResponse |
| fenxiao_nick | fenxiao_nick | | autoFillResponse |
| fenxiao_type | fenxiao_type | | _autoFillResponse |
| flag_id | flag_id | | autoFillResponse |
| flag_name | flag_name | | _autoFillResponse |
| freeze_reason | freeze_reason | | autoFillResponse |
| fullname | fullname | | _autoFillResponse |
| goods_count | goods_count | | autoFillResponse |
| goods_total_amount | goods_total_amount | | _autoFillResponse |
| goods_total_cost | goods_total_cost | | autoFillResponse |
| goods_type_count | goods_type_count | | _autoFillResponse |
| has_invoice | has_invoice | | autoFillResponse |
| id_card | id_card | | _autoFillResponse |
| id_card_type | id_card_type | | autoFillResponse |
| invoice_content | invoice_content | | _autoFillResponse |
| invoice_id | invoice_id | | autoFillResponse |
| invoice_print_status | invoice_print_status | | _autoFillResponse |
| invoice_title | invoice_title | | autoFillResponse |
| invoice_type | invoice_type | | _autoFillResponse |
| is_allocated | is_allocated | | autoFillResponse |
| lock_id | lock_id | | _autoFillResponse |
| logistics_code | logistics_code | | autoFillResponse |
| logistics_id | logistics_id | | _autoFillResponse |
| logistics_name | logistics_name | | autoFillResponse |
| logistics_no | logistics_no | | _autoFillResponse |
| logistics_print_status | logistics_print_status | | autoFillResponse |
| logistics_template_id | logistics_template_id | | _autoFillResponse |
| logistics_type | logistics_type | | autoFillResponse |
| md5_str | md5_str | | _autoFillResponse |
| modified | modified | | autoFillResponse |
| nick_name | nick_name | | _autoFillResponse |
| note_count | note_count | | autoFillResponse |
| operator_id | operator_id | | _autoFillResponse |
| operator_name | operator_name | | autoFillResponse |
| order_no | order_no | | _autoFillResponse |
| order_type | order_type | | autoFillResponse |
| order_type_name | order_type_name | | _autoFillResponse |
| outer_no | outer_no | | autoFillResponse |
| pack_score | pack_score | | _autoFillResponse |
| package_cost | package_cost | | autoFillResponse |
| package_fee | package_fee | | _autoFillResponse |
| package_id | package_id | | autoFillResponse |
| packager_id | packager_id | | _autoFillResponse |
| packager_name | packager_name | | autoFillResponse |
| packager_no | packager_no | | _autoFillResponse |
| paid | paid | | autoFillResponse |
| pay_time | pay_time | | _autoFillResponse |
| pick_error_count | pick_error_count | | autoFillResponse |
| pick_score | pick_score | | _autoFillResponse |
| picker_id | picker_id | | autoFillResponse |
| picker_name | picker_name | | _autoFillResponse |
| picker_no | picker_no | | autoFillResponse |
| picklist_no | picklist_no | | _autoFillResponse |
| picklist_print_status | picklist_print_status | | autoFillResponse |
| picklist_seq | picklist_seq | | _autoFillResponse |
| platform_id | platform_id | | autoFillResponse |
| pos_allocate_mode | pos_allocate_mode | | _autoFillResponse |
| post_amount | post_amount | | autoFillResponse |
| post_cost | post_cost | | _autoFillResponse |
| post_fee | post_fee | | autoFillResponse |
| post_weight | post_weight | | _autoFillResponse |
| pre_charge_time | pre_charge_time | | autoFillResponse |
| print_batch_no | print_batch_no | | _autoFillResponse |
| print_remark | print_remark | | autoFillResponse |
| printer_id | printer_id | | _autoFillResponse |
| printer_name | printer_name | | autoFillResponse |
| printer_no | printer_no | | _autoFillResponse |
| raw_goods_count | raw_goods_count | | autoFillResponse |
| reason_id | reason_id | | _autoFillResponse |
| receivable | receivable | | autoFillResponse |
| receiver_address | receiver_address | | _autoFillResponse |
| receiver_area | receiver_area | | autoFillResponse |
| receiver_city | receiver_city | | _autoFillResponse |
| receiver_city_code | receiver_city_code | | autoFillResponse |
| receiver_country | receiver_country | | _autoFillResponse |
| receiver_district | receiver_district | | autoFillResponse |
| receiver_district_code | receiver_district_code | | _autoFillResponse |
| receiver_dtb | receiver_dtb | | autoFillResponse |
| receiver_mobile | receiver_mobile | | _autoFillResponse |
| receiver_name | receiver_name | | autoFillResponse |
| receiver_province | receiver_province | | _autoFillResponse |
| receiver_province_code | receiver_province_code | | autoFillResponse |
| receiver_ring | receiver_ring | | _autoFillResponse |
| receiver_telno | receiver_telno | | autoFillResponse |
| receiver_zip | receiver_zip | | _autoFillResponse |
| refund_status | refund_status | | autoFillResponse |
| remark | remark | | _autoFillResponse |
| reserve | reserve | | autoFillResponse |
| salesman_name | salesman_name | | _autoFillResponse |
| salesman_no | salesman_no | | autoFillResponse |
| sendbill_print_status | sendbill_print_status | | _autoFillResponse |
| sendbill_template_id | sendbill_template_id | | autoFillResponse |
| shop_name | shop_name | | _autoFillResponse |
| shop_no | shop_no | | autoFillResponse |
| shop_remark | shop_remark | | _autoFillResponse |
| sorter_id | sorter_id | | autoFillResponse |
| src_order_id | src_order_id | | _autoFillResponse |
| src_order_no | src_order_no | | autoFillResponse |
| src_order_type | src_order_type | | _autoFillResponse |
| src_tids | src_tids | | autoFillResponse |
| src_trade_no | src_trade_no | | _autoFillResponse |
| status | status | | autoFillResponse |
| stock_check_time | stock_check_time | | _autoFillResponse |
| stockout_id | stockout_id | | autoFillResponse |
| stockout_no | stockout_no | | _autoFillResponse |
| stockout_reason | stockout_reason | | autoFillResponse |
| stockout_receiver_dtb | stockout_receiver_dtb | | _autoFillResponse |
| subtype | subtype | | autoFillResponse |
| tax | tax | | _autoFillResponse |
| tax_rate | tax_rate | | autoFillResponse |
| to_deliver_time | to_deliver_time | | _autoFillResponse |
| trade_id | trade_id | | autoFillResponse |
| trade_no | trade_no | | _autoFillResponse |
| trade_status | trade_status | | autoFillResponse |
| trade_time | trade_time | | _autoFillResponse |
| trade_type | trade_type | | autoFillResponse |
| unknown_goods_amount | unknown_goods_amount | | _autoFillResponse |
| warehouse_id | warehouse_id | | autoFillResponse |
| warehouse_name | warehouse_name | | _autoFillResponse |
| warehouse_no | warehouse_no | | autoFillResponse |
| warehouse_type | warehouse_type | | _autoFillResponse |
| watcher_id | watcher_id | | autoFillResponse |
| weight | weight | | _autoFillResponse |
| wms_status | wms_status | | autoFillResponse |
| tid | tid | | _autoFillResponse |
| kuaidi100Data | kuaidi100Data | | autoFillResponse |
| kuaidi100Data.message | message | | _autoFillResponse |
| kuaidi100Data.nu | nu | | autoFillResponse |
| kuaidi100Data.ischeck | ischeck | | _autoFillResponse |
| kuaidi100Data.com | com | | autoFillResponse |
| kuaidi100Data.status | status | | _autoFillResponse |
| kuaidi100Data.data | data | | autoFillResponse |
| kuaidi100Data.state | state | | _autoFillResponse |
| kuaidi100Data.condition | condition | | autoFillResponse |
| kuaidi100Data.routeInfo | routeInfo | | _autoFillResponse |
| kuaidi100Data.isLoop | isLoop | | autoFillResponse |
| kuaidi100Data.tid | tid | | _autoFillResponse |
旺店通·企业版接口明细
- 调用接口:trade_push
- 接口名称:创建调拨入库单
- 方法:POST
请求参数
| 字段 | 字段名称 | 类型 | 配置值 |
| tid | 原始单号 | string | {{tid}} |
| trade_status | 平台状态 | string | _function case when '{{kuaidi100Data.state}}' in ('301','302','303','304','3','501') then '70' else '{{trade_status}}' end |
| pay_status | 支付状态 | string | {{pay_status}} |
| delivery_term | 发货条件 | string | 3 |
| trade_time | 下单时间 | datetime | {{trade_time}} |
| pay_time | 支付时间 | datetime | {{pay_time}} |
| fenxiao_type | 分销类别 | string | |
| purchase_id | 采购单ID | string | |
| fenxiao_nick | 分销商id | string | |
| buyer_nick | 客户网名 | string | {{buyer_nick}} |
| buyer_email | 买家email | string | |
| pay_id | 支付单号 | string | |
| pay_account | 支付账号 | string | |
| receiver_name | 收件人 | string | {{receiver_name}} |
| receiver_address | 地址详情 | string | {{receiver_address}} |
| receiver_province | 省份 | string | {{receiver_province}} |
| receiver_city | 城市 | string | {{receiver_city}} |
| receiver_district | 区县 | string | {{receiver_district}} |
| receiver_mobile | 手机 | string | {{receiver_mobile}} |
| receiver_telno | 电话 | string | {{FLINKPHONE}} |
| receiver_zip | 邮编 | string | |
| logistics_type | 物流方式 | string | -1 |
| invoice_kind | 发票类别 | string | |
| invoice_title | 发票抬头 | string | |
| invoice_content | 发票内容 | string | |
| remark_flag | 客户备注标旗 | string | |
| buyer_message | 买家备注 | string | {{FNote}} |
| seller_memo | 客服备注 | string | {{FCustId_FName}} |
| seller_flag | 标旗 | string | |
| post_amount | 邮费 | string | {{post_amount}} |
| cod_amount | 货到付款金额 | string | {{cod_amount}} |
| ext_cod_fee | 货到付款买家费用 | string | {{ext_cod_fee}} |
| other_amount | 其它收费 | string | {{other_amount}} |
| paid | 已付 | string | 1.0000 |
| is_auto_wms | 自动流转模式 | string | |
| warehouse_no | 仓库编号 | string | {{warehouse_no}} |
| order_list | 订单货品明细节点 | array | details_list |
| order_list.oid | 子订单编号 | string | {{details_list.src_oid}} |
| order_list.num | 数量 | string | {{details_list.num}} |
| order_list.price | 单价 | string | {{details_list.price}} |
| order_list.status | 状态 | string | {{status}} |
| order_list.refund_status | 退款状态 | string | {{refund_status}} |
| order_list.goods_id | 平台货品ID | string | {{details_list.goods_id}} |
| order_list.spec_id | 平台规格ID | string | {{details_list.spec_id}} |
| order_list.goods_no | 货品编码 | string | {{details_list.goods_no}} |
| order_list.spec_no | 规格编码 | string | {{details_list.spec_no}} |
| order_list.goods_name | 货品名称 | string | {{details_list.goods_name}} |
| order_list.spec_name | 规格名称 | string | {{details_list.spec_name}} |
| order_list.adjust_amount | 调整 | string | |
| order_list.discount | 优惠 | string | |
| order_list.share_discount | 分摊优惠 | string | |
| order_list.remark | 备注 | string | {{details_list.FAllAmount}} |
| order_list.cid | 类目 | string | |
| order_list.trade_list | trade_list | array | |
| order_list.shop_no | shop_no | string | 005 |
| order_list.switch | switch | string | 1 |
数据对接效果
通过无代码的数据集成与数据建模的智能数据管道技术,帮助企业将所有应用程序、数据库、事件和文件等数据信息提取到数据仓库中,并快速将分散的数据转化为数据集、API、自动化流程等开箱即用的数据服务。配置接口的模式对接轻易云集成平台和旺店通·企业版,使得单据无缝互通。打造企业内部数据一体化,让企业日常运营管理实现敏捷数据化运营。实现供应链业务信息流的互通,同时支持供应链数据分析流程自动化,结果推送,推进相关供应链问题优化。及时打通供应链孤岛,实现数据驱动供应链协同,进一步提升企业竞争力。
