轻易云
注册体验

领星ERP查询亚马逊源报表 - 交易明细接口

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

查询亚马逊源报表 - 交易明细

POST/erp/sc/data/mws_report/transaction
加工厂
{
  "operation": {
    "method": "POST",
    "path": "/erp/sc/data/mws_report/transaction"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": {
    "sid": 109,
    "event_date": "2020-06-07",
    "offset": 0,
    "length": 1000
  },
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "38AA9D9A-5936-FD62-9901-C415C1951111",
    "response_time": "2021-07-02 11:23:08",
    "data": [
      {
        "sid": 103,
        "is_to_b": 0,
        "report_date_month": "2021-05",
        "report_index": 736,
        "date_str": "May 31, 2021 11:56:23 AM PDT",
        "date_locale": "2021-05-31",
        "date_iso": "2021-05-31T11:56:23-07:00",
        "settlement_id": "142111161",
        "type": 1,
        "order_id": "113-1111111111111111-9121025",
        "sku": "200J",
        "description_str": "KOo",
        "quantity": 1,
        "marketplace": "amazon.com",
        "fulfillment": "Amazon",
        "order_city": "REDWOOD CITY",
        "order_state": "CA",
        "order_postal": "9401142",
        "product_sales": "19.9900",
        "currency": "USD",
        "shipping_credits": "0.0000",
        "shipping_credits_tax": "0.0000",
        "gift_wrap_credits": "0.0000",
        "gift_wrap_credits_tax": "0.0000",
        "promotional_rebates": "-10.0000",
        "promotional_rebates_tax": "0.0000",
        "sales_tax_collected": "0.0000",
        "marketplace_facilitator_tax": "-0.9700",
        "selling_fees": "-1.5000",
        "fba_fees": "-5.4200",
        "other_transaction_fees": "-0.7000",
        "other": "0.0000",
        "total": "2.3700",
        "description": "KORsy to",
        "type_str": "Order"
      },
      {
        "sid": 103,
        "is_to_b": 0,
        "report_date_month": "2021-05",
        "report_index": 741,
        "date_str": "May 31, 2021 2:00:44 PM PDT",
        "date_locale": "2021-05-31",
        "date_iso": "2021-05-31T14:00:44-07:00",
        "settlement_id": "1426581161",
        "type": 1,
        "order_id": "113-111111111111-5120241",
        "sku": "200J",
        "description_str": "KO",
        "quantity": 1,
        "marketplace": "amazon.com",
        "fulfillment": "Amazon",
        "order_city": "HOUSTON",
        "order_state": "TX",
        "order_postal": "77044-6581",
        "product_sales": "19.9900",
        "currency": "USD",
        "shipping_credits": "0.0000",
        "shipping_credits_tax": "0.0000",
        "gift_wrap_credits": "0.0000",
        "gift_wrap_credits_tax": "0.0000",
        "promotional_rebates": "0.0000",
        "promotional_rebates_tax": "0.0000",
        "sales_tax_collected": "0.0000",
        "marketplace_facilitator_tax": "-1.4500",
        "selling_fees": "-3.0000",
        "fba_fees": "-5.4200",
        "other_transaction_fees": "-1.4000",
        "other": "0.0000",
        "total": "10.1700",
        "description": "11111sy to",
        "type_str": "Order"
      }
    ],
    "total": 0
  }
}

接口请求参数

序号字段名称类型默认值必填描述
1sid店铺idinteger—必填店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
2event_date报表日期string—必填报表日期,格式:Y-m-d【每月3日后支持查询上月数据】
3offset分页偏移量integer—可选分页偏移量,默认0
4length分页长度integer—可选分页长度,默认1000

接口响应参数

序号字段名称类型默认值必填描述
1code状态码integer0必填状态码,0 成功
2message消息提示stringsuccess必填消息提示
3error_details错误信息array<any>—必填错误信息
4request_id请求链路idstring2C1A1C68-395F-C1A0-5639-9AF0A5BE08A4必填请求链路id
5response_time响应时间string2020-05-18 11:23:47必填响应时间
6data响应数据array<object>—必填响应数据
6.1sid店铺idinteger1必填店铺id
6.2is_to_b是否为B2B订单integer0必填是否为B2B订单:0 否【2c】,1 是
6.3report_date_monthclient_task的月份string2019-03必填client_task的月份
6.4report_index报表行索引integer—必填报表行索引
6.5date_str原本的日期字符串string1 Mar 2019 00:00:45 GMT+00:00必填原本的日期字符串
6.6date_locale当地日期string2019-03-01必填当地日期
6.7date_isoISO时间string2019-03-01T00:00:45+00:00必填ISO时间
6.8settlement_id结算编号string11376876372必填结算编号
6.9type类型integer1必填类型: 1 ORDER 2 REFUND 3 ADJUSTMENT 4 A_TO_Z_GUARANTEE_CLAIM 5 CHARGEBACK_REFUND 6 FBA_INVENTORY_FEE 7 SERVICE_FEE 8 LIGHTNING_DEAL_FEE 9 TRANSFER 10 ORDER_RETROCHARGE 11 REFUND_RETROCHARGE 12 CHARGES_TO_CREDIT_CARD 13 FBA_CUSTOMER_RETURN_FEE 14 DEBT 15 NULL【其他类型】 16 FEE_ADJUSTMENT 17 LIQUIDATIONS 18 Shipping Services 19 Electronic Transactions 20 COD Transactions 21 Reimbursements 22 Tax Withheld 23 Liquidations Adjustments 24 PW Order Payment 25 PW Trial Shipment 26 Fulfilment Fee Refund 27 TBYB Order Payment 28 TBYB Trial Shipment
6.10type_str类型说明string—必填类型说明
6.11order_id订单号string205-0598548-1768342必填订单号
6.12skuskustring4H-3NL6-GL1I必填SKU
6.13description商品描述string—必填商品描述
6.14quantity商品数量number1必填商品数量
6.15marketplace销售市场stringamazon.co.uk必填销售市场
6.16fulfillment发货方式stringAmazon必填发货方式
6.17order_city城市stringMIDDLESBROUGH必填城市
6.18order_state州stringCleveland必填州
6.19order_postal邮编stringTS6 9JN必填邮编
6.20product_sales销售价格string12.4900必填销售价格
6.21product_sales_tax销售税string—必填销售税
6.22currency币种stringUSD必填币种
6.23shipping_credits运费string1.8700必填运费
6.24shipping_credits_tax运费税(荷兰string—可选运费税(荷兰,瑞典,沙特,阿联酋无该税费)
6.25gift_wrap_credits礼品包装费string0.0000必填礼品包装费
6.26gift_wrap_credits_tax礼品包装税(荷兰string—可选礼品包装税(荷兰,瑞典,沙特,阿联酋无该税费)
6.27promotional_rebates促销返点string-1.8700必填促销返点
6.28promotional_rebates_tax促销返点税(荷兰string—可选促销返点税(荷兰,瑞典,沙特,阿联酋无该税费)
6.29sales_tax_collected销售税(仅荷兰string0.0000可选销售税(仅荷兰,瑞典,沙特,阿联酋有该税费)
6.30marketplace_facilitator_tax市场税string0.0000必填市场税
6.31selling_fees平台费(佣金)string-2.2500必填平台费(佣金)
6.32fba_feesFBA发货费string-2.1700必填FBA发货费
6.33other_transaction_fees其他交易费string0.0000必填其他交易费
6.34other其他费string0.0000必填其他费
6.35total总计string10.5700必填总计

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

需要对接这个接口?

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