Qeasy Cloud
Get Started

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

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
统计 · POST · 请求参数 6 个(必填 3) · 响应参数 55 个 · 限流令牌桶容量 1
Updated At
2026-11-21

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

POST/erp/sc/routing/data/order/fbmReturnOrderList
Factory
{
  "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
  }
}

Request Parameters

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

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2message消息提示stringsuccessRequired消息提示
3error_details错误信息array<any>—Required错误信息
4request_id请求链路idstring2E9941CD-3A26-3550-52A3-F83F4D1977F1Required请求链路id
5response_time响应时间string2023-06-30 17:28:41Required响应时间
6total总数integer1Required总数
7data响应数据array<object>—Required响应数据
7.1id订单idinteger2Required订单id
7.2order_hash订单唯一hashstringb7ec98d3d3d11092b8838ef29508aa20Required订单唯一hash
7.3sid店铺idinteger101Required店铺id
7.4order_id亚马逊订单idstring112-6283972-5349000Required亚马逊订单id
7.5order_date订购时间string2023-05-22Required订购时间
7.6return_date退货时间string2023-05-24Required退货时间
7.7return_status退货状态stringApprovedRequired退货状态
7.8rma_idRMA单号stringDjMbMZrvRRMARequiredRMA单号
7.9label_type标签类型stringAmazonPrePaidLabelRequired标签类型
7.10label_cost标签费用string4.13Required标签费用
7.11currency_code币种stringUSDRequired币种
7.12return_carrier承运商stringUSPSRequired承运商
7.13tracking_id运单号string9202090339598309314960Required运单号
7.14label_payer标签支付方stringCustomerRequired标签支付方
7.15a_to_z_claim"A-to-Z"标签stringNRequired"A-to-Z"标签, N代表否,Y代表是
7.16is_prime"Prime"标签stringNRequired"Prime"标签, N代表否,Y代表是
7.17asinasinstringB0B4WP82TGRequiredasin
7.18seller_skuseller_sku【MSKU】stringHair-Ties-P0360Requiredseller_sku【MSKU】
7.19item_name标题stringYiWu HENGFU.hi Heart Pearl Black Hair TiesRequired标题
7.20return_quantity退货数量number1Required退货数量
7.21return_reason退货原因stringCR-UNWANTED_ITEM(客户退货-不想要的商品)Required退货原因
7.22in_policy是否符合政策stringYRequired是否符合政策:N代表否,Y代表是
7.23return_type退货类型stringC-ReturnsRequired退货类型
7.24resolution解决方法stringStandardRefundRequired解决方法
7.25invoice_number发票号码string—Required发票号码
7.26return_delivery_date退货送达日期string—Required退货送达日期
7.27order_amount订单金额string5.83Required订单金额
7.28order_quantity商品信息--原始数量integer1Required商品信息--原始数量
7.29safet_action_reasonSafe-T索赔原因string—RequiredSafe-T索赔原因
7.30safet_claim_idSaft-T索赔单号string—RequiredSaft-T索赔单号
7.31safet_claim_stateSaft-T索赔状态string—RequiredSaft-T索赔状态
7.32safet_claim_creation_timeSaft-T索赔时间string—RequiredSaft-T索赔时间
7.33safet_claim_reimbursement_amountSafe-T索赔金额string—RequiredSafe-T索赔金额
7.34refunded_amount退款金额string5.83Required退款金额
7.35sync_time同步数据时间戳integer1685260468Required同步数据时间戳
7.36rma_id_providerrma_id_providerstringAmazonRequiredRMA单号提供者(amazon或者Merchant)
7.37remark备注string自动化备注Required备注
7.38tag_type_ids标签信息array<object>—Required标签信息
7.38.1tag_name标签名称string尺码问题Required标签名称
7.38.2tag_color标签颜色stringE76A5DRequired标签颜色
7.39local_sku本地产品skustringZDH1688113470.6414766Required本地产品sku
7.40local_name品名string自动化单品Required品名
7.41brand_title品牌名stringxxRequired品牌名
7.42category_title_path分类stringxxxRequired分类
7.43country国家string美国Required国家
7.44seller_name店铺名string8p1-USRequired店铺名
7.45asin_urlasin地址stringhttps://www.amazon.com/dp/B0B4WP8XXXRequiredasin地址
7.46pic_url产品图片stringhttps://xxxx/a8dbce2f2.jpgRequired产品图片

The 查询亚马逊源报表 - FBM退货订单 API (/erp/sc/routing/data/order/fbmReturnOrderList) of 领星ERP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 领星ERP version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.