/cost/center/ods/detail/query{
"operation": {
"method": "POST",
"path": "/cost/center/ods/detail/query"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 10,
"text": ""
},
"requestExample": {
"sellerIds": [
"AN05PRUL7R796"
],
"startDate": "2024-03-02",
"endDate": "2024-06-1",
"fnskus": [
"B085M7NH7S"
],
"asins": [
"B097MP26YP"
],
"mskus": [
"DA19037B1"
],
"eventTypes": [
"01",
"02"
],
"disposition": "01",
"location": "GB",
"offset": 0,
"length": 20
},
"responseExample": "{\n \"code\": 1,\n \"msg\": \"操作成功\",\n \"data\": {\n \"records\": [\n {\n \"sellerId\": \"xxxxxxxxxxxxxxxx\",\n \"date\": \"2022-04-01\",\n \"fnsku\": \"X0010DNT2F\",\n \"asin\": \"B07Q3PV8SR\",\n \"msku\": \"1300U1207\",\n \"title\": \"HEETA Scalp Massager [Soft& Convenient] Shampoo Brush with Silicone Bristles for Wet and Dry Hair\",\n \"eventType\": \"01\",\n \"eventTypeDesc\": \"Shipments\",\n \"referenceId\": \"41247588491302\",\n \"quantity\": -1,\n \"fulfillmentCenter\": \"EUK5\",\n \"disposition\": \"01\",\n \"dispositionDesc\": \"SELLABLE\",\n \"reason\": \"\",\n \"location\": \"GB\",\n \"uniqueMd5Idx\": \"bc4f83291d4fda71272fc586b81c3240\",\n \"uniqueMd5\": \"0\",\n }\n ],\n \"total\": 12673,\n \"size\": 20,\n \"current\": 1,\n \"orders\": [],\n \"optimizeCountSql\": true,\n \"hitCount\": false,\n \"countId\": null,\n \"maxLimit\": null,\n \"searchCount\": true,\n \"pages\": 634\n },\n \"traceId\": \"b2532fc7-9c1b-4b08-8d30-301b31b70562.1663226369188\",\n \"success\": true\n}"
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sellerIds | 亚马逊店铺id | array<any> | — | Required | 亚马逊店铺id |
| 2 | startDate | 统计起始日期 Y-m-d 闭区间 | string | — | Required | 统计起始日期 Y-m-d 闭区间 |
| 3 | endDate | 统计结束日期 Y-m-d 闭区间 | string | — | Required | 统计结束日期 Y-m-d 闭区间 |
| 4 | fnskus | fnsku列表 | array<any> | — | Optional | fnsku列表 |
| 5 | asins | asin列表 | array<any> | — | Optional | asin列表 |
| 6 | mskus | msku列表 | array<any> | — | Optional | msku列表 |
| 7 | eventTypes | 事件类型 | array<any> | — | Optional | 事件类型,支持传多值: 01 Shipments 02 CustomerReturns 03 WhseTransfers 04 Receipts 05 VendorReturns 06 Adjustments |
| 8 | referenceId | 引用id | string | — | Optional | 引用id,支持模糊搜索 |
| 9 | disposition | 库存类型 | string | — | Optional | 库存类型: 01 SELLABLE 02 UNSELLABLE 03 ALL |
| 10 | locations | 国家编码列表 | array<any> | — | Optional | 国家编码列表 |
| 11 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 12 | length | 分页长度 | integer | — | Optional | 分页长度,默认20,上限1000 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 1 | Required | 状态码,1 成功 |
| 2 | msg | 响应信息 | string | — | Required | 响应信息 |
| 3 | success | 操作是否成功 | boolean | — | Required | 操作是否成功 |
| 4 | traceId | 请求链路id | string | — | Required | 请求链路id |
| 5 | data | 明细数据 | object | — | Required | 明细数据 |
| 5.1 | total | 总记录条数 | number | — | Required | 总记录条数 |
| 5.2 | size | 每个数据页大小 | number | — | Required | 每个数据页大小 |
| 5.3 | current | 当前所在数据页 | number | — | Required | 当前所在数据页 |
| 5.4 | records | 明细数据列表 | array<object> | — | Required | 明细数据列表 |
| 5.4.1 | sellerId | 亚马逊店铺id | string | — | Required | 亚马逊店铺id |
| 5.4.2 | date | 数据日期 | string | 2022-04-01 | Required | 数据日期 |
| 5.4.3 | fnsku | fnsku | string | — | Required | fnsku |
| 5.4.4 | asin | asin | string | — | Required | asin |
| 5.4.5 | msku | msku | string | — | Required | msku |
| 5.4.6 | title | 标题 | string | — | Optional | 标题 |
| 5.4.7 | eventType | 事件类型 | string | 01 | Required | 事件类型 |
| 5.4.8 | eventTypeDesc | 事件类型描述 | string | Shipments | Required | 事件类型描述 |
| 5.4.9 | referenceId | 货物id | string | — | Optional | 货物id |
| 5.4.10 | quantity | 数量 | number | — | Required | 数量 |
| 5.4.11 | fulfillmentCenter | 储存库存的履行中心 | string | — | Required | 储存库存的履行中心 |
| 5.4.12 | disposition | 库存属性 | string | 01 | Required | 库存属性 |
| 5.4.13 | dispositionDesc | 库存属性描述 | string | SELLABLE | Required | 库存属性描述 |
| 5.4.14 | reason | 原因 | string | — | Optional | 原因 |
| 5.4.15 | location | 国家 | string | GB | Required | 国家 |
| 5.4.16 | uniqueMd5Idx | 和uniqueMd5联合作为唯一键 | string | bc4f83291d4fda71272fc586b81c3240 | Required | 和uniqueMd5联合作为唯一键,uniqueMd5Idx是标识uniqueMd5的index |
| 5.4.17 | uniqueMd5 | 和uniqueMd5Idx联合作为唯一键 | string | 0 | Required | 和uniqueMd5Idx联合作为唯一键 |
The 查询库存分类账detail数据 API (/cost/center/ods/detail/query) 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.