Qeasy Cloud
Get Started

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

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

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

POST/erp/sc/data/mws_report/refundOrders
Factory
{
  "operation": {
    "method": "POST",
    "path": "/erp/sc/data/mws_report/refundOrders"
  },
  "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": "3387708D-4BB5-BB28-F8CE-18EE2A3D591F",
    "response_time": "2023-06-30 17:30:02",
    "data": [
      {
        "sid": 101,
        "order_id": "133666",
        "product_name": "SUPER J Cell Phone Armband Running Armband for Iphone Samsung Sports Phone Holder Waterproof",
        "sku": "JJ001",
        "asin": "B0BB9XV7CW",
        "fnsku": "B0BB9XV7CW",
        "quantity": 1,
        "return_date": "2023-06-04T19:57:09+01:00",
        "return_date_locale": "2023-06-04",
        "purchase_date": "2023-08-13T07:20:35Z",
        "purchase_date_locale": "2023-08-13",
        "fulfillment_center_id": "AUS3",
        "detailed_disposition": "SELLABLE",
        "reason": "UNDELIVERABLE_UNKNOWN",
        "status": "Unit returned to inventory",
        "license_plate_number": "LPNT010424593",
        "customer_comments": "",
        "gmt_modified": "2023-06-08 09:48:10",
        "local_sku": "10369333",
        "remark": "备注",
        "tag": [
          {
            "tag_name": "尺码问题",
            "tag_color": "E76A5D"
          }
        ]
      }
    ],
    "total": 1
  }
}

Request Parameters

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

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2message消息提示stringsuccessRequired消息提示
3error_details错误信息array<any>—Required错误信息
4request_id请求链路idstring2C1A1C68-395F-C1A0-5639-9AF0A5BE08A4Required请求链路id
5response_time响应时间string2020-05-18 11:23:47Required响应时间
6data响应数据array<object>—Required响应数据
6.1sid店铺idinteger3Required店铺id
6.2order_id订单号string028-0034384-7536302Required订单号
6.3local_sku本地产品skustring456487456Required本地产品sku
6.4product_name品名string6 Zoll Mikrofon Popschutz Studio MikrofonRequired品名
6.5skuskustringDA190379B1RequiredMSKU
6.6asinasinstringB06XPGK9SHLRequiredASIN
6.7fnskufnskustringX000NYD9RDXRequiredFNSKU
6.8quantity数量integer1Required数量
6.9return_date退货时间【UTC时间】string2019-01-17T02:28:18+00:00Required退货时间【UTC时间】
6.10return_date_locale退货时间【站点时间】string2020-06-04Required退货时间【站点时间】
6.11purchase_date订购时间【UTC时间】string2019-01-17T02:28:18+00:00Required订购时间【UTC时间】
6.12purchase_date_locale订购时间【站点时间】string2020-06-04Required订购时间【站点时间】
6.13gmt_modified更新时间string2023-06-08 09:48:10Required更新时间
6.14fulfillment_center_id存储库存的运营中心stringBTS2Required存储库存的运营中心
6.15detailed_disposition商品状态属性stringSELLABLERequired商品状态属性
6.16reason退回原因stringNO_REASON_GIVENRequired退回原因
6.17status状态stringUnit returned to inventoryRequired状态
6.18license_plate_number唯一序列号stringLPNHE298128253Required唯一序列号
6.19customer_comments买家评论string&nbsp;Required买家评论
6.20remark备注string备注Required备注
6.21tag标签信息array<object>—Required标签信息
6.21.1tag_name标签名称string尺码问题Required标签名称
6.21.2tag_color标签颜色stringE76A5DRequired标签颜色

The 查询亚马逊源报表 - FBA退货订单 API (/erp/sc/data/mws_report/refundOrders) 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.