/pb/mp/returns/workOrder/list{
"operation": {
"method": "POST",
"path": "/pb/mp/returns/workOrder/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 10,
"text": ""
},
"requestExample": {
"date_type": "create_time",
"start_time": "2023-06-15 00:00:00",
"end_time": "2023-06-16 23:59:59",
"offset": 0,
"length": 20
},
"responseExample": {
"code": 0,
"message": "操作成功",
"request_id": "895f2f0493414a4184d28cffaff87a09.1686797615263",
"response_time": "2023-06-15 10:53:36",
"data": {
"total": 101,
"list": [
{
"status": "处理中/待收货",
"rma_id": 202306050003,
"rma_type": 2,
"order_number": 103280851812762110,
"platform_code": "10008",
"country": "美国",
"store_name": "test-walmart",
"rma_from": 2,
"rma_reason": "不给换",
"return_warehouse_code": 11,
"return_warehouse_name": "仓库11",
"return_type_code": 1,
"return_logistice_type_code": 1,
"return_logistics": "",
"tracking_number": "",
"estimate_arrive_date": 0,
"order_amount": null,
"refund_method": 1,
"refund_status": "",
"comment": "",
"create_time": "2023-06-09 11:23:44",
"update_time": "2023-06-09 11:25:01",
"complete_time": "2023-06-09 11:25:01",
"tag_list": [
{
"tag_id": "907225000920047630",
"tag_name": "RMA标签1"
}
],
"refund": [],
"rma_info": [
{
"sku": "SKUPIC",
"msku": "walm_test2_sku6kGpZ",
"product_name": "pic",
"product_image": "https://xxx/47889efe3d00df67cb39.jpg",
"product_amount": 5,
"product_rma_amount": 1,
"product_comment": "",
"product_rma_image": null,
"platform_order_no": "NINE00002"
}
],
"related_info": [
{
"return_order_id": "RT901280870700859904",
"return_order_status_code": 5,
"issue_order_number": null
},
{
"return_order_id": "RT901294602998157824",
"return_order_status_code": 3,
"issue_order_number": null
},
{
"return_order_id": "RT901294603713667072",
"return_order_status_code": 3,
"issue_order_number": null
},
{
"return_order_id": "RT901320516537774080",
"return_order_status_code": 3,
"issue_order_number": null
}
]
}
]
}
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | date_type | 时间类型 | string | — | Required | 时间类型: create_time 创建时间 complete_time 完成时间 |
| 2 | start_time | 开始时间 | string | — | Required | 开始时间,闭区间,格式:Y-m-d H:i:s |
| 3 | end_time | 结束时间 | string | — | Required | 结束时间,闭区间,格式:Y-m-d H:i:s |
| 4 | offset | 分页偏移量 | integer | — | Required | 分页偏移量 |
| 5 | length | 分页长度 | integer | — | Required | 分页长度,上限500 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 提示信息 | string | 操作成功 | Required | 提示信息 |
| 3 | request_id | 请求链路id | string | eb2bdeed-4842-42b0-8b5e-81345dda5078.1679967282563 | Required | 请求链路id |
| 4 | response_time | 响应时间 | string | 2023-03-28 09:34:45 | Required | 响应时间 |
| 5 | data | 响应数据 | object | — | Required | 响应数据 |
| 5.1 | total | 总数 | integer | 46 | Required | 总数 |
| 5.2 | list | 列表信息 | array<object> | — | Required | 列表信息 |
| 5.2.1 | rma_id | 售后单号 | string | 202306050003 | Required | 售后单号 |
| 5.2.2 | rma_type | 售后类型 | integer | 1 | Required | 售后类型: 1 退货退款 2 仅退货 3 仅退款 4 退货补发 5 补发 |
| 5.2.3 | status | 状态【售后单状态/订单状态】 | string | 处理中/待收货 | Required | 状态【售后单状态/订单状态】 |
| 5.2.4 | order_number | 系统单号 | string | 103290951812762112 | Required | 系统单号 |
| 5.2.5 | platform_code | 平台code | string | 10002 | Required | 平台code |
| 5.2.6 | country | 国家 | string | 美国 | Required | 国家 |
| 5.2.7 | store_name | 店铺名称 | string | test-walmart | Required | 店铺名称 |
| 5.2.8 | rma_from | 单据来源 | integer | 2 | Required | 单据来源:1 手工创建,2 线上同步 |
| 5.2.9 | rma_reason | 售后原因 | string | 不给换 | Required | 售后原因 |
| 5.2.10 | return_warehouse_code | 退货仓库id | string | 11 | Required | 退货仓库id |
| 5.2.11 | return_warehouse_name | 退货仓库名称 | string | 仓库11 | Required | 退货仓库名称 |
| 5.2.12 | return_type_code | 退货类型 | integer | 1 | Required | 退货类型:1 买家退货,2 卖家退货 |
| 5.2.13 | return_logistice_type_code | 物流类型 | integer | 1 | Required | 物流类型:1 自选物流,2 三方物流 |
| 5.2.14 | return_logistics | 物流商 | string | 物流商xx | Required | 物流商 |
| 5.2.15 | tracking_number | 跟踪号 | string | 123 | Required | 跟踪号 |
| 5.2.16 | estimate_arrive_date | 预计到货时间 | string | 168658600000 | Required | 预计到货时间 |
| 5.2.17 | order_amount | 订单金额 | string | 338.0 | Required | 订单金额 |
| 5.2.18 | returen_method | 退款方式 | integer | 1 | Required | 退款方式:0 无选择,1 手动退款 |
| 5.2.19 | refund_status | 退款状态 | string | 退款完成 | Required | 退款状态: 待退款 退款中 退款失败 退款完成 |
| 5.2.20 | comment | 备注 | string | 备注xx | Required | 备注 |
| 5.2.21 | create_time | 创建时间 | string | 2023-06-09 11:23:44 | Required | 创建时间 |
| 5.2.22 | update_time | 更新时间 | string | 2023-06-09 11:25:01 | Required | 更新时间 |
| 5.2.23 | complete_time | 完成时间 | string | 2023-06-09 11:25:01 | Required | 完成时间 |
| 5.2.24 | tag_list | 标签信息 | array<object> | — | Required | 标签信息 |
| 5.2.24.1 | tag_id | 标签id | string | 907225000920047630 | Required | 标签id |
| 5.2.24.2 | tag_name | 标签名称 | string | RMA标签1 | Required | 标签名称 |
| 5.2.25 | refund | 退款信息 | array<object> | — | Required | 退款信息 |
| 5.2.25.1 | platform_order_number | 退款平台单号 | string | ama-test0330-mnkg8a | Required | 退款平台单号 |
| 5.2.25.2 | refund_amount | 退款金额 | number | 2 | Required | 退款金额 |
| 5.2.26 | rma_info | 售后信息 | array<object> | — | Required | 售后信息 |
| 5.2.26.1 | sku | sku | string | danpin2 | Required | SKU |
| 5.2.26.2 | msku | msku | string | sHOLDER001 | Required | MSKU |
| 5.2.26.3 | product_name | 品名 | string | 单品2 | Required | 品名 |
| 5.2.26.4 | product_image | 商品图片 | string | https//xxxx.jpg | Required | 商品图片 |
| 5.2.26.5 | product_amount | 商品订购数量 | integer | 1 | Required | 商品订购数量 |
| 5.2.26.6 | product_rma_amount | 商品售后数量 | integer | 1 | Required | 商品售后数量 |
| 5.2.26.7 | product_comment | 商品售后说明 | string | 暂无说明 | Required | 商品售后说明 |
| 5.2.26.8 | product_rma_image | 商品售后图片 | string | https://xxxx-xxxxx.com/xxxxxxxxxx.jpg | Required | 商品售后图片 |
| 5.2.26.9 | platform_order_no | 平台单号 | string | — | Required | 平台单号 |
| 5.2.27 | related_info | 关联单据 | array<object> | — | Required | 关联单据 |
| 5.2.27.1 | return_order_id | 销售退货单单据号 | string | RT901305646307553280 | Required | 销售退货单单据号 |
| 5.2.27.2 | return_order_status_code | 销售退货单状态 | integer | 3 | Required | 销售退货单状态: -1 异常 1 待提交 2 待审批 3 待收货 4 已作废 5 已完成 6 导入中 |
| 5.2.27.3 | issue_order_number | 补发订单系统单号 | string | 103295742586946048 | Required | 补发订单系统单号 |
The 查询售后工单列表 API (/pb/mp/returns/workOrder/list) 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.