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) · 响应参数 32 个 · 限流令牌桶容量 1
Updated At
2026-11-21

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

POST/erp/sc/data/mws_report/fbaOrders
Factory
{
  "operation": {
    "method": "POST",
    "path": "/erp/sc/data/mws_report/fbaOrders"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": {
    "sid": 109,
    "date_type": 1,
    "start_date": "2020-04-01",
    "end_date": "2024-08-05",
    "offset": 0,
    "length": 1000
  },
  "responseExample": {
    "code": 0,
    "data": [
      {
        "sku": "Pink_Head_Rope",
        "currency": "USD",
        "carrier": "USPS",
        "amazon_order_id": "112-0065094-0449862",
        "shipment_id": "TBb1Gwxz1",
        "shipment_item_id": "DFJVVkwbH",
        "amazon_order_item_id": "67486918672938",
        "purchase_date": "2022-05-09T21:59:41+00:00",
        "payments_date": "2022-05-10T06:05:32+00:00",
        "shipment_date": "2022-05-10T06:05:32+00:00",
        "reporting_date": "2022-05-10T09:05:39+00:00",
        "estimated_arrival_date": "2022-05-12T03:00:00+00:00",
        "product_name": "Love Pearl Bottom Hair Circle Women's High Elastic Hair Binding Rope Jewelry Rubber Band Head Rope Pink",
        "quantity_shipped": 1,
        "item_price": "1.00",
        "item_tax": "0.00",
        "shipping_price": "0.00",
        "shipping_tax": "0.00",
        "gift_wrap_price": "0.00",
        "gift_wrap_tax": "0.00",
        "ship_service_level": "Expedited",
        "item_promotion_discount": "0.00",
        "ship_promotion_discount": "0.00",
        "tracking_number": "9374889705011506008135",
        "fulfillment_channel": "AFN",
        "points_granted": "",
        "hide_time": "2022-05-09 23:05:32",
        "buyer_email": "fbzdtkn3vgzftkk@marketplace.amazon.com",
        "buyer_name": "",
        "buyer_phone_number": "",
        "recipient_name": "",
        "ship_address_1": "",
        "ship_city": "BARNHART",
        "ship_state": "MO",
        "ship_postal_code": "63012",
        "ship_country": "US",
        "ship_phone_number": ""
      }
    ],
    "total": 9,
    "message": "操作成功",
    "request_id": "acb13574cdd14cd287043fadb895894e.1722930272131",
    "response_time": "2024-08-06 15:44:32",
    "error_details": []
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1sid店铺idinteger—Required店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
2date_type日期搜索维度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请求链路idstring69F77F67-F288-B0C8-F453-C653E4D0FA93Required请求链路id
5response_time响应时间string2021-05-14 18:08:36Required响应时间
6data响应数据array<object>—Required响应数据
6.1amazon_order_id订单号string112-4166816-7798631Required订单号
6.2shipment_id配送IDstringDHySD0zRYRequired配送ID
6.3shipment_item_id配送子IDstringD6ddjDd1RRequired配送子ID
6.4amazon_order_item_id订单子项IDstring37909714721266Required订单子项ID
6.5purchase_date下单日期string2018-11-04T23:57:08+00:00Required下单日期
6.6payments_date支付日期string2018-11-05T08:06:34+00:00Required支付日期
6.7shipment_date配送日期(零时区)string2018-11-05T08:06:37+00:00Required配送日期(零时区)
6.8reporting_date报表日期string2018-11-05T09:06:42+00:00Required报表日期
6.9estimated_arrival_date预计送达日期string2018-11-07T04:00:00+00:00Required预计送达日期
6.10skuskustringNP-10US-24Y8RequiredSKU
6.11product_name品名stringBicycle Saddle Dual Suspension Shock AbsorbingRequired品名
6.12quantity_shipped数量number1Required数量
6.13currency币种stringUSDRequired币种
6.14item_price商品金额string17.92Required商品金额
6.15item_tax商品税string0.00Required商品税
6.16shipping_price运费金额string0.00Required运费金额
6.17shipping_tax运费税string0.00Required运费税
6.18gift_wrap_price礼品包装费string0.00Required礼品包装费
6.19gift_wrap_tax礼品包装税string0.00Required礼品包装税
6.20ship_service_level配送级别stringExpeditedRequired配送级别
6.21item_promotion_discount订单商品促销折扣string0.00Required订单商品促销折扣
6.22ship_promotion_discount配送的促销折扣string0.00Required配送的促销折扣
6.23carrier运输方stringUSPSRequired运输方
6.24tracking_number快递号string9361289677090259988439Required快递号
6.25fulfillment_channel配送方式stringAFNRequired配送方式: 亚马逊配送 (AFN) 卖家自行配送 (MFN)
6.26points_granted亚马逊授予买家的积分string&nbsp;Required亚马逊授予买家的积分

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