轻易云
注册体验

领星ERP查询亚马逊源报表 - FBM退货订单接口

所属平台
领星ERP
类型
WebAPI
作用
QUERY
接口版本
1.0
适配器
\Adapter\LingXing\LXQueryAdapter
授权方式
OTHER
描述
统计 · POST · 请求参数 6 个(必填 3) · 响应参数 55 个 · 限流令牌桶容量 1
更新日期
2026-11-21

查询亚马逊源报表 - FBM退货订单

POST/erp/sc/routing/data/order/fbmReturnOrderList
加工厂
{
  "operation": {
    "method": "POST",
    "path": "/erp/sc/routing/data/order/fbmReturnOrderList"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": {
    "sid": 109,
    "date_type": 1,
    "start_date": "2020-01-01",
    "end_date": "2024-08-05",
    "offset": 0,
    "length": 1000
  },
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "2E9941CD-3A26-3550-52A3-F83F4D1977F1",
    "response_time": "2023-06-30 17:28:41",
    "data": [
      {
        "id": 2,
        "order_hash": "b7ec98d3d3d11092b8838ef29508aa20",
        "sid": 101,
        "order_id": "112-6283972-5349000",
        "order_date": "2023-05-22",
        "return_date": "2023-05-24",
        "return_status": "Approved",
        "rma_id": "DjMbMZrvRRMA",
        "rma_id_provider": "Amazon",
        "label_type": "AmazonPrePaidLabel",
        "label_cost": "4.13",
        "currency_code": "USD",
        "return_carrier": "USPS",
        "tracking_id": "9202090339598309314960",
        "label_payer": "Customer",
        "a_to_z_claim": "N",
        "is_prime": "N",
        "asin": "B0B4WP8XXX",
        "seller_sku": "Hair-Ties-P0360",
        "item_name": "YiWu HENGFU.hi Heart Pearl Black Hair Ties - High Stretch Elastic Bands for Women and Girls, Double as Jewelry and Head Rope",
        "return_quantity": 1,
        "return_reason": "CR-UNWANTED_ITEM(客户退货-不想要的商品)",
        "in_policy": "Y",
        "return_type": "C-Returns",
        "resolution": "StandardRefund",
        "invoice_number": "",
        "return_delivery_date": "",
        "order_amount": "5.83",
        "order_quantity": 1,
        "safet_action_reason": "",
        "safet_claim_id": "",
        "safet_claim_state": "",
        "safet_claim_creation_time": "",
        "safet_claim_reimbursement_amount": "",
        "refunded_amount": "5.83",
        "sync_time": 1685260468,
        "remark": "自动化备注",
        "tag_type_ids": [
          {
            "id": 60,
            "tag_name": "尺码问题",
            "tag_type": 2,
            "tag_color": "E76A5D",
            "tag_type_id": "2-60"
          }
        ],
        "local_sku": "ZDH1688113470.6414766",
        "local_name": "自动化单品",
        "brand_title": "",
        "category_title_path": "",
        "country": "美国",
        "seller_name": "8p1-US",
        "asin_url": "https://www.amazon.com/dp/B0B4WP8XXX",
        "pic_url": "https://xxxx/a8dbce2f2.jpg"
      }
    ],
    "total": 1
  }
}

接口请求参数

序号字段名称类型默认值必填描述
1sid店铺idinteger—必填店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
2start_date开始时间string—必填开始时间,左闭区间,格式:Y-m-d
3end_date结束时间string—必填结束时间,右开区间,格式:Y-m-d
4date_type时间查询类型integer—可选时间查询类型:【默认1】 1 退货日期 2 下单日期
5offset分页偏移量integer—可选分页偏移量,默认0
6length分页长度integer—可选分页长度,默认1000

接口响应参数

序号字段名称类型默认值必填描述
1code状态码integer0必填状态码,0 成功
2message消息提示stringsuccess必填消息提示
3error_details错误信息array<any>—必填错误信息
4request_id请求链路idstring2E9941CD-3A26-3550-52A3-F83F4D1977F1必填请求链路id
5response_time响应时间string2023-06-30 17:28:41必填响应时间
6total总数integer1必填总数
7data响应数据array<object>—必填响应数据
7.1id订单idinteger2必填订单id
7.2order_hash订单唯一hashstringb7ec98d3d3d11092b8838ef29508aa20必填订单唯一hash
7.3sid店铺idinteger101必填店铺id
7.4order_id亚马逊订单idstring112-6283972-5349000必填亚马逊订单id
7.5order_date订购时间string2023-05-22必填订购时间
7.6return_date退货时间string2023-05-24必填退货时间
7.7return_status退货状态stringApproved必填退货状态
7.8rma_idRMA单号stringDjMbMZrvRRMA必填RMA单号
7.9label_type标签类型stringAmazonPrePaidLabel必填标签类型
7.10label_cost标签费用string4.13必填标签费用
7.11currency_code币种stringUSD必填币种
7.12return_carrier承运商stringUSPS必填承运商
7.13tracking_id运单号string9202090339598309314960必填运单号
7.14label_payer标签支付方stringCustomer必填标签支付方
7.15a_to_z_claim"A-to-Z"标签stringN必填"A-to-Z"标签, N代表否,Y代表是
7.16is_prime"Prime"标签stringN必填"Prime"标签, N代表否,Y代表是
7.17asinasinstringB0B4WP82TG必填asin
7.18seller_skuseller_sku【MSKU】stringHair-Ties-P0360必填seller_sku【MSKU】
7.19item_name标题stringYiWu HENGFU.hi Heart Pearl Black Hair Ties必填标题
7.20return_quantity退货数量number1必填退货数量
7.21return_reason退货原因stringCR-UNWANTED_ITEM(客户退货-不想要的商品)必填退货原因
7.22in_policy是否符合政策stringY必填是否符合政策:N代表否,Y代表是
7.23return_type退货类型stringC-Returns必填退货类型
7.24resolution解决方法stringStandardRefund必填解决方法
7.25invoice_number发票号码string—必填发票号码
7.26return_delivery_date退货送达日期string—必填退货送达日期
7.27order_amount订单金额string5.83必填订单金额
7.28order_quantity商品信息--原始数量integer1必填商品信息--原始数量
7.29safet_action_reasonSafe-T索赔原因string—必填Safe-T索赔原因
7.30safet_claim_idSaft-T索赔单号string—必填Saft-T索赔单号
7.31safet_claim_stateSaft-T索赔状态string—必填Saft-T索赔状态
7.32safet_claim_creation_timeSaft-T索赔时间string—必填Saft-T索赔时间
7.33safet_claim_reimbursement_amountSafe-T索赔金额string—必填Safe-T索赔金额
7.34refunded_amount退款金额string5.83必填退款金额
7.35sync_time同步数据时间戳integer1685260468必填同步数据时间戳
7.36rma_id_providerrma_id_providerstringAmazon必填RMA单号提供者(amazon或者Merchant)
7.37remark备注string自动化备注必填备注
7.38tag_type_ids标签信息array<object>—必填标签信息
7.38.1tag_name标签名称string尺码问题必填标签名称
7.38.2tag_color标签颜色stringE76A5D必填标签颜色
7.39local_sku本地产品skustringZDH1688113470.6414766必填本地产品sku
7.40local_name品名string自动化单品必填品名
7.41brand_title品牌名stringxx必填品牌名
7.42category_title_path分类stringxxx必填分类
7.43country国家string美国必填国家
7.44seller_name店铺名string8p1-US必填店铺名
7.45asin_urlasin地址stringhttps://www.amazon.com/dp/B0B4WP8XXX必填asin地址
7.46pic_url产品图片stringhttps://xxxx/a8dbce2f2.jpg必填产品图片

领星ERP的接口:查询亚马逊源报表 - FBM退货订单(/erp/sc/routing/data/order/fbmReturnOrderList),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。