/cepf/fms/openapi/walmartPayment/queryPage{
"operation": {
"method": "POST",
"path": "/cepf/fms/openapi/walmartPayment/queryPage"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 10,
"text": ""
},
"requestExample": {
"length": 15,
"offset": 0,
"report_id": "MI7cc13c6a4f7d8769629e807e8263fc87",
"store_id": [
110000000018008000,
110000000018008000
],
"transaction_posted_timestamp_start": "2023-05-01",
"transaction_posted_timestamp_end": "2023-05-20"
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "45fd55efd92b4aad8c97f5c0371ec063.1684735677529",
"response_time": "2023-05-22 14:07:58",
"data": {
"total": "7",
"records": [
{
"period_end_date": null,
"period_start_date": null,
"transaction_key": "2023_05_01_001",
"currency": "USD",
"transaction_posted_timestamp": "2023-05-15",
"transaction_description": "Purchase",
"transaction_type": "Sale",
"customer_order": "2023_05_01_oPX5au",
"purchase_order": "walmart-test051702-XmIVJU",
"amount_type": "Product Price",
"amount": 20,
"ship_qty": "11",
"transaction_reason_description": "No Longer Wanted",
"commission_rate": 2,
"commission_rate_str": "2.00%",
"msku": "walm_wjc2_sku7xP4a",
"partner_item_name": "Casabrews Espresso Machine",
"partner_gtin": "850030773067",
"product_taxCode": "2042275",
"ship_to_city": "Miami Lakes",
"ship_to_state": "FL",
"ship_to_zipcode": "33016",
"product_type": "Espresso Machines",
"commission_rule": "BSE-65-3.0",
"shipping_method": "Marketplace expedited",
"fulfillment_type": "Walmart-fulfilled(WFS)",
"store_id": "110000000018008002",
"store_name": "walmart测试店铺"
}
]
}
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 2 | length | 分页长度 | integer | — | Optional | 分页长度,默认15,上限200 |
| 3 | store_id | 店铺id | array<any> | — | Required | 店铺id |
| 4 | report_id | 报告id | string | — | Optional | 报告id 【时间范围 与 报告id 二选一必填】 |
| 5 | transaction_posted_timestamp_start | 开始时间 | string | — | Optional | 开始时间,格式:Y-m-d 【时间范围 与 报告id 二选一必填】 |
| 6 | transaction_posted_timestamp_end | 结束时间 | string | — | Optional | 结束时间,格式:Y-m-d 【时间范围 与 报告id 二选一必填】 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | f4044649b1be46398c7eb4e6eb6ab6d5.1684735739946 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2022-05-22 14:08:59 | Required | 响应时间 |
| 6 | data | 响应数据 | object | — | Required | 响应数据 |
| 6.1 | total | 总数 | integer | 10 | Required | 总数 |
| 6.2 | records | 详细信息列表 | array<object> | — | Required | 详细信息列表 |
| 6.2.1 | amount | 金额 | string | 5 | Required | 金额 |
| 6.2.2 | amount_type | 金额类型 | string | Product Price | Required | 金额类型 |
| 6.2.3 | commission_rate | 佣金率 | string | 20 | Required | 佣金率 |
| 6.2.4 | commission_rate_str | 佣金率% | string | 20% | Required | 佣金率% |
| 6.2.5 | commission_rule | 佣金规则 | string | 0.00000 | Required | 佣金规则 |
| 6.2.6 | currency | 币种 | string | USD | Required | 币种 |
| 6.2.7 | customer_order | 客户订单号 | string | 2023_05_01_oPX5au | Required | 客户订单号 |
| 6.2.8 | fulfillment_type | 发货类型 | string | Walmart-fulfilled(WFS) | Required | 发货类型 |
| 6.2.9 | msku | msku | string | walm_wjc9_sku7xP4a | Required | msku |
| 6.2.10 | partner_gtin | Partner GTIN | string | 850030773067 | Required | Partner GTIN |
| 6.2.11 | partner_item_name | 商品标题 | string | Casabrews Espresso Machine | Required | 商品标题 |
| 6.2.12 | period_end_date | 结束日期 | string | 2023-05-15 | Required | 结束日期 |
| 6.2.13 | period_start_date | 开始日期 | string | 2023-05-20 | Required | 开始日期 |
| 6.2.14 | product_taxCode | 产品税号 | string | 2042275 | Required | 产品税号 |
| 6.2.15 | product_type | 产品类型 | string | Espresso Machines | Required | 产品类型 |
| 6.2.16 | purchase_order | 平台单号 | string | walmart-test051702-XmIVJU | Required | 平台单号 |
| 6.2.17 | ship_qty | 数量 | integer | 1 | Required | 数量 |
| 6.2.18 | ship_to_city | 收货城市 | string | Miami Lakes | Required | 收货城市 |
| 6.2.19 | ship_to_state | 收货州 | string | FL | Required | 收货州 |
| 6.2.20 | ship_to_zipcode | 收货邮编 | string | 33016 | Required | 收货邮编 |
| 6.2.21 | shipping_method | 运输方式 | string | Marketplace expedited | Required | 运输方式 |
| 6.2.22 | store_id | 店铺id | string | 110000000018008002 | Required | 店铺id |
| 6.2.23 | store_name | 店铺名称 | string | walmart测试店铺2号 | Required | 店铺名称 |
| 6.2.24 | transaction_description | 交易描述 | string | Purchase | Required | 交易描述 |
| 6.2.25 | transaction_key | 交易key | string | 2023_05_01_001 | Required | 交易key |
| 6.2.26 | transaction_posted_timestamp | 交易日期 | string | 2023-05-15 | Required | 交易日期 |
| 6.2.27 | transaction_reason_description | 交易原因描述 | string | transaction_reason_description | Required | 交易原因描述 |
| 6.2.28 | transaction_type | 交易类型 | string | Sale | Required | 交易类型 |
The 查询报告详情 - Walmart Payment API (/cepf/fms/openapi/walmartPayment/queryPage) 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.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.