通过此接口可商品退库预约信息批量查询
| 名称 | 类型 | 是否必须 | 示例值 | 描述 |
|---|---|---|---|---|
| appMethod | String | Y | suning.custom.category.query | 方法名 |
| appRequestTime | String | Y | 2012-04-25 20:23:30 | 时间戳，格式为yyyy-MM-dd HH:mm:ss，例如：2012-04-25 20:23:30。API服务端允许客户端请求时间误差为10分钟。 |
| format | String | N | XML | 默认xml,可指定格式为xml,json |
| appKey | String | Y | b0c332a133c102765f39de********** | 分配给应用的访问令牌 |
| versionNo | String | Y | v1.2 | API的版本，目前为v1.2版本 |
| signInfo | String | Y | 460d7ff15b073e463125b4********** | appSecret,appMethod ,appRequestTime, appKey, versionNo, 请求报文base64加密后的数据顺序MD5(32位小写)，其中appSecret为appKey对应的密钥 |
| access_token | String | N | a1c5c62b08df3a3cbf7efd********** | 采用OAuth授权方式为必填参数 |
| 名称 | 类型 | 是否必须 | 示例值 | 描述 |
|---|---|---|---|---|
| pageNo | String | N | 1 | 当前页。 |
| pageSize | String | N | 10 | 每页条数。 |
| appointStatus | String | N | 0 | 预约单状态。 |
| refundType | String | N | 0 | 退库类型。 |
| warehouseCode | String | N | 100 | 仓库编码。 |
| appointStartDate | String | N | 2014-11-21 | 预约开始日期。 |
| appointEndDate | String | N | 2014-11-21 | 预约结束日期。 |
| createStartDate | String | N | 2015—05—21 | 创建开始日期。 |
| createEndDate | String | N | 2014-11-21 | 创建结束日期。 |
| 名称 | 类型 | 示例值 | 描述 |
|---|---|---|---|
| supplierCode | String | 70055150 | 商户编码。 |
| appointOrderId | String | 2000000000036 | 退库预约单号。 |
| refundType | String | 1 | 退库类型。 |
| appointStatus | String | 1 | 退库预约单状态。 |
| createDate | String | 2014-11-21 | 退库预约创建日期。 |
| createTime | String | 15:00 | 退库预约创建时间。 |
| appointDate | String | 2014-11-21 | 预约退库日期。 |
| appointTime | String | 15:00 | 预约退库时间。 |
| recommendDate | String | 2014-11-21 | 建议预约退库日期。 |
| recommendTime | String | 15:00 | 建议预约退库时间。 |
| warehouseName | String | 广州城北配送中心 | 仓库名称。 |
| contacts | String | 商户1 | 承运人。 |
| supplierPhone | String | 15866992211 | 联系电话。 |
| warehouseCode | String | L300 | 仓库ID。 |
| supplierCode | String | 70055150 | 商户编码。 |
| commodityCode | String | 108291914 | 苏宁商品编码。 |
| supCommCode | String | 1 | 商家商品编码。 |
| commodityName | String | 黄浔博一号 | 商品名称。 |
| refundCount | String | 11 | 退库商品数量。 |
| supplierCode | String | 70055150 | 商户编码。 |
| commodityCode | String | 108291914 | 苏宁商品编码。 |
| supCommCode | String | 1 | 商家商品编码。 |
| commodityName | String | 黄浔博一号 | 商品名称。 |
| refundCount | String | 11 | 退库商品数量。 |
<sn_request>
<sn_body>
<queryRefundAppointOrder>
<pageNo>1</pageNo>
<pageSize>10</pageSize>
<appointStatus>01</appointStatus>
<refundType>1</refundType><warehouseCode>L025</warehouseCode>
<appointStartDate>2014-11-21 21:00:00</appointStartDate>
<appointEndDate>2014-11-20 18:00:00</appointEndDate>
<createStartDate>2014-11-20 21:00:00</createStartDate>
<createEndDate>2014-11-20 21:00:00</createEndDate>
</queryRefundAppointOrder>
</sn_body>
</sn_request>
{
"sn_request":{
"sn_body":{
"queryRefundAppointOrder":{
"pageNo":"1",
"pageSize":"10",
"appointStatus":"01",
"refundType":"1",
"warehouseCode":"L025",
"appointStartDate":"2014-11-21 21:00:00",
"appointEndDate":"2014-11-21 21:00:00",
"createStartDate":"2014-11-21 21:00:00",
"createEndDate":"2014-11-21 21:00:00"
}
}
}
}
<sn_responseContent>
<sn_head>
<pageTotal>3</pageTotal>
<pageNo>1</pageNo>
<totalSize>28</totalSize>
<returnMessage>biz.handler.data-get:success</returnMessage>
</sn_head>
<sn_body>
<queryRefundAppointOrder>
<supplierCode>70055150</supplierCode>
<appointOrderId>2000000000036</appointOrderId>
<refundType>1</refundType>
<appointStatus>1</appointStatus>
<createDate>2015-06-04</createDate>
<createTime>18:57</createTime>
<appointDate>2015-06-04</appointDate>
<appointTime>15:00</appointTime>
<warehouseName>广州城北配送中心</warehouseName>
<contacts>商户1</contacts>
<supplierPhone>15866992211</supplierPhone>
<warehouseCode>L300</warehouseCode>
<commodityList>
<supplierCode>70055150</supplierCode>
<commodityCode>108291914</commodityCode>
<supCommCode>1</supCommCode>
<commodityName>黄浔博一号</commodityName>
<refundCount>11</refundCount>
</commodityList>
<commodityList>
<supplierCode>70055150</supplierCode>
<commodityCode>108291914</commodityCode>
<commodityName>黄浔博一号</commodityName>
<refundCount>11</refundCount>
</commodityList>
</queryRefundAppointOrder>
<queryRefundAppointOrder>
<supplierCode>70055150</supplierCode>
<appointOrderId>2000000000035</appointOrderId>
<refundType>1</refundType>
<appointStatus>1</appointStatus>
<createDate>2015-06-04</createDate>
<createTime>18:49</createTime>
<appointDate>2015-06-04</appointDate>
<appointTime>15:00</appointTime>
<warehouseName>广州城北配送中心</warehouseName>
<contacts>商户1</contacts>
<supplierPhone>15866992211</supplierPhone>
<warehouseCode>L300</warehouseCode>
<commodityList>
<supplierCode>70055150</supplierCode>
<commodityCode>108291914</commodityCode>
<supCommCode>1</supCommCode>
<commodityName>黄浔博一号</commodityName>
<refundCount>11</refundCount>
</commodityList>
<commodityList>
<supplierCode>70055150</supplierCode>
<commodityCode>108291914</commodityCode>
<commodityName>黄浔博一号</commodityName>
<refundCount>11</refundCount>
</commodityList>
</queryRefundAppointOrder>
<queryRefundAppointOrder>
<supplierCode>70055150</supplierCode>
<appointOrderId>2000000000033</appointOrderId>
<refundType>1</refundType>
<appointStatus>1</appointStatus>
<createDate>2015-02-26</createDate>
<createTime>16:27</createTime>
<appointDate>2015-03-04</appointDate>
<appointTime>10:00</appointTime>
<warehouseName>武汉</warehouseName>
<contacts>3</contacts>
<supplierPhone>323</supplierPhone>
<warehouseCode>L024</warehouseCode>
</queryRefundAppointOrder>
<queryRefundAppointOrder>
<supplierCode>70055150</supplierCode>
<appointOrderId>2000000000032</appointOrderId>
<refundType>1</refundType>
<appointStatus>1</appointStatus>
<createDate>2015-01-23</createDate>
<createTime>15:54</createTime>
<appointDate>2015-01-26</appointDate>
<appointTime>11:00</appointTime>
<warehouseName>武汉</warehouseName>
<contacts>zw</contacts>
<supplierPhone>123</supplierPhone>
<warehouseCode>L024</warehouseCode>
</queryRefundAppointOrder>
<queryRefundAppointOrder>
<supplierCode>70055150</supplierCode>
<appointOrderId>2000000000031</appointOrderId>
<refundType>1</refundType>
<appointStatus>1</appointStatus>
<createDate>2015-01-23</createDate>
<createTime>15:53</createTime>
<appointDate>2015-01-26</appointDate>
<appointTime>09:00</appointTime>
<warehouseName>武汉</warehouseName>
<contacts>zw</contacts>
<supplierPhone>1223</supplierPhone>
<warehouseCode>L024</warehouseCode>
</queryRefundAppointOrder>
<queryRefundAppointOrder>
<supplierCode>70055150</supplierCode>
<appointOrderId>2000000000030</appointOrderId>
<refundType>1</refundType>
<appointStatus>1</appointStatus>
<createDate>2015-01-23</createDate>
<createTime>15:51</createTime>
<appointDate>2015-01-26</appointDate>
<appointTime>10:00</appointTime>
<warehouseName>武汉</warehouseName>
<contacts>zw</contacts>
<supplierPhone>123</supplierPhone>
<warehouseCode>L024</warehouseCode>
</queryRefundAppointOrder>
<queryRefundAppointOrder>
<supplierCode>70055150</supplierCode>
<appointOrderId>2000000000029</appointOrderId>
<refundType>1</refundType>
<appointStatus>1</appointStatus>
<createDate>2015-01-23</createDate>
<createTime>15:50</createTime>
<appointDate>2015-01-26</appointDate>
<appointTime>10:00</appointTime>
<warehouseName>武汉</warehouseName>
<contacts>zw</contacts>
<supplierPhone>21323</supplierPhone>
<warehouseCode>L024</warehouseCode>
</queryRefundAppointOrder>
<queryRefundAppointOrder>
<supplierCode>70055150</supplierCode>
<appointOrderId>2000000000028</appointOrderId>
<refundType>1</refundType>
<appointStatus>1</appointStatus>
<createDate>2015-01-23</createDate>
<createTime>15:48</createTime>
<appointDate>2015-01-26</appointDate>
<appointTime>10:00</appointTime>
<warehouseName>武汉</warehouseName>
<contacts>zw</contacts>
<supplierPhone>12332</supplierPhone>
<warehouseCode>L024</warehouseCode>
</queryRefundAppointOrder>
<queryRefundAppointOrder>
<supplierCode>70055150</supplierCode>
<appointOrderId>2000000000027</appointOrderId>
<refundType>1</refundType>
<appointStatus>1</appointStatus>
<createDate>2015-01-23</createDate>
<createTime>15:44</createTime>
<appointDate>2015-01-26</appointDate>
<appointTime>10:00</appointTime>
<warehouseName>武汉</warehouseName>
<contacts>zwq</contacts>
<supplierPhone>1212</supplierPhone>
<warehouseCode>L024</warehouseCode>
</queryRefundAppointOrder>
<queryRefundAppointOrder>
<supplierCode>70055150</supplierCode>
<appointOrderId>2000000000026</appointOrderId>
<refundType>0</refundType>
<appointStatus>1</appointStatus>
<createDate>2014-12-17</createDate>
<createTime>13:10</createTime>
<appointDate>2014-12-20</appointDate>
<appointTime>10:00</appointTime>
<warehouseName>武汉</warehouseName>
<contacts>zw</contacts>
<supplierPhone>124344</supplierPhone>
<warehouseCode>L024</warehouseCode>
</queryRefundAppointOrder>
</sn_body>
</sn_responseContent>
{
"sn_responseContent": {
"sn_head": {
"pageTotal": "3",
"pageNo": "1",
"totalSize": "28",
"returnMessage": "biz.handler.data-get:success"
},
"sn_body": {
"queryRefundAppointOrder": [
{
"supplierCode": "70055150",
"appointOrderId": "2000000000036",
"refundType": "1",
"appointStatus": "1",
"createDate": "2015-06-04",
"createTime": "18:57",
"appointDate": "2015-06-04",
"appointTime": "15:00",
"warehouseName": "广州城北配送中心",
"contacts": "商户1",
"supplierPhone": "15866992211",
"warehouseCode": "L300",
"commodityList": [
{
"supplierCode": "70055150",
"commodityCode": "108291914",
"supCommCode": "1",
"commodityName": "黄浔博一号",
"refundCount": "11"
},
{
"supplierCode": "70055150",
"commodityCode": "108291914",
"commodityName": "黄浔博一号",
"refundCount": "11"
}
]
},
{
"supplierCode": "70055150",
"appointOrderId": "2000000000035",
"refundType": "1",
"appointStatus": "1",
"createDate": "2015-06-04",
"createTime": "18:49",
"appointDate": "2015-06-04",
"appointTime": "15:00",
"warehouseName": "广州城北配送中心",
"contacts": "商户1",
"supplierPhone": "15866992211",
"warehouseCode": "L300",
"commodityList": [
{
"supplierCode": "70055150",
"commodityCode": "108291914",
"supCommCode": "1",
"commodityName": "黄浔博一号",
"refundCount": "11"
},
{
"supplierCode": "70055150",
"commodityCode": "108291914",
"commodityName": "黄浔博一号",
"refundCount": "11"
}
]
},
{
"supplierCode": "70055150",
"appointOrderId": "2000000000033",
"refundType": "1",
"appointStatus": "1",
"createDate": "2015-02-26",
"createTime": "16:27",
"appointDate": "2015-03-04",
"appointTime": "10:00",
"warehouseName": "武汉",
"contacts": "3",
"supplierPhone": "323",
"warehouseCode": "L024"
},
{
"supplierCode": "70055150",
"appointOrderId": "2000000000032",
"refundType": "1",
"appointStatus": "1",
"createDate": "2015-01-23",
"createTime": "15:54",
"appointDate": "2015-01-26",
"appointTime": "11:00",
"warehouseName": "武汉",
"contacts": "zw",
"supplierPhone": "123",
"warehouseCode": "L024"
},
{
"supplierCode": "70055150",
"appointOrderId": "2000000000031",
"refundType": "1",
"appointStatus": "1",
"createDate": "2015-01-23",
"createTime": "15:53",
"appointDate": "2015-01-26",
"appointTime": "09:00",
"warehouseName": "武汉",
"contacts": "zw",
"supplierPhone": "1223",
"warehouseCode": "L024"
},
{
"supplierCode": "70055150",
"appointOrderId": "2000000000030",
"refundType": "1",
"appointStatus": "1",
"createDate": "2015-01-23",
"createTime": "15:51",
"appointDate": "2015-01-26",
"appointTime": "10:00",
"warehouseName": "武汉",
"contacts": "zw",
"supplierPhone": "123",
"warehouseCode": "L024"
},
{
"supplierCode": "70055150",
"appointOrderId": "2000000000029",
"refundType": "1",
"appointStatus": "1",
"createDate": "2015-01-23",
"createTime": "15:50",
"appointDate": "2015-01-26",
"appointTime": "10:00",
"warehouseName": "武汉",
"contacts": "zw",
"supplierPhone": "21323",
"warehouseCode": "L024"
},
{
"supplierCode": "70055150",
"appointOrderId": "2000000000028",
"refundType": "1",
"appointStatus": "1",
"createDate": "2015-01-23",
"createTime": "15:48",
"appointDate": "2015-01-26",
"appointTime": "10:00",
"warehouseName": "武汉",
"contacts": "zw",
"supplierPhone": "12332",
"warehouseCode": "L024"
},
{
"supplierCode": "70055150",
"appointOrderId": "2000000000027",
"refundType": "1",
"appointStatus": "1",
"createDate": "2015-01-23",
"createTime": "15:44",
"appointDate": "2015-01-26",
"appointTime": "10:00",
"warehouseName": "武汉",
"contacts": "zwq",
"supplierPhone": "1212",
"warehouseCode": "L024"
},
{
"supplierCode": "70055150",
"appointOrderId": "2000000000026",
"refundType": "0",
"appointStatus": "1",
"createDate": "2014-12-17",
"createTime": "13:10",
"appointDate": "2014-12-20",
"appointTime": "10:00",
"warehouseName": "武汉",
"contacts": "zw",
"supplierPhone": "124344",
"warehouseCode": "L024"
}
]
}
}
}
| 异常码 | 错误描述 | 解决方案 |
|---|---|---|
| biz.handler.data-get:no-result | 查询为空 | 请输入正确参数。 |
| biz.swl.queryrefundappointorder.invalid.biz.appointstatus | 退库预约单状态不对 | 请输入正确参数。 |
| biz.swl.queryrefundappointorder.invalid.biz.refundtype | 退库类型不对 | 请输入正确参数。 |
| isp.sys.service.unavailable.mims | 服务不可用（系统异常） | 请联系苏宁技术人员。 |
| 异常码 | 错误描述 | 解决方案 |
|---|---|---|
| sys.check.user-permission:inexistence | 访问令牌不存在 | 更换访问令牌 |
| sys.check.user-permission:overdue | 访问令牌已过期 | 请使用刷新令牌刷新 |
| sys.check.api-permission:inexistence | Api方法不存在 | 请参考帮助中心 |
| sys.check.api-permission:overdue | Api方法已过期 | 请参考帮助中心 |
| sys.check.method-permission:authority | 无权操作此api | 确认是否有访问该方法权限 |
| sys.auth.vendor-request:errory | 无权操作此供应商 | 请确认供应商编码是否正确 |
| sys.controller.api-request:limit | Api请求受控 | 超过请求次数 |
| sys.check.app-time:error | 请求参数错误api请求时间误差大 | 参考帮助中心 |
| sys.check.request-params:error | 请求报文结构错误 | 参考帮助中心、日期格式等 |
| sys.check.starttime-format:error | 请求开始时间错误 | 参考帮助中心、日期格式等 |
| biz.handler.data-get:success | 业务数据查询成功 | 无 |
| biz.handler.data-get:fail | 业务数据查询失败 | 检查请求条件 |
| biz.handler.data-get:no-result | 业务数据结果为空 | 无 |
| sys.check.pageno-format:error | pageNo格式错误，只允许1到99999之间的整数 | 检查pageNo输入是否有误 |
| sys.check.pagesize-format:error | pageSize格式错误，只允许1到50之间的整数(订单相关是1到100) | 检查pageSize输入是否有误 |
| sys.check.page-param:error | pageNo或者pageSize不在要求范围内，pageNo只允许1到99999之间的整数，pageSize只允许1到50之间的整数(订单相关是1到100) | 检查pageNo和pageSize输入是否有误 |
| sys.check.miss-time:starttime | 不存在开始时间(节点) | 检查输入 |
| sys.check.miss-time:endtime | 不存在结束时间(节点) | 检查输入 |
| sys.check.starttime-value:null | 开始时间为空(值) | 检查输入 |
| sys.check.endtime-value:null | 结束时间为空(值) | 检查输入 |
| sys.check.starttime-format:error | 校验开始时间不合法，格式yyyy-MM-dd HH:mm:ss | 检查时间格式 |
| sys.check.endtime-format:error | 校验结束时间不合法，格式yyyy-MM-dd HH:mm:ss | 检查时间格式 |
| sys.check.query-time:error | 开始时间是否小于结束时间 | 检查开始和结束时间大小 |
| sys.check.query-time:outofrange | 时间查询是否超出指定范围 | 检查时间范围 |
| sys.check.app-sign:null | 签名信息为空 | 检查签名信息 |
| sys.check.app-sign:error | 签名信息错误 | 检查签名信息 |
| sys.check.missing-parameter:apiversion | API版本号未指定 | 检查API版本号 |
| sys.check.missing-parameter:appRequestTime | 请求时间丢失 | 检查请求时间 |
| sys.check.missing-nestElement:sn_body | 缺少sn_body节点 | 检查sn_body是否存在 |
| sys.check.user-permission:inexistence | 用户key不存在 | 检查用户key是否存在 |
| biz.handler.batch-handler:no-support | 非查询类API不支持批量操作 | 检查API类型 |
| biz.handler.request-message:error | 查询类API输入多个业务节点 | 检查业务节点 |
| sys.check.header-param:null | header参数为空 | 请检查header参数 |
| sys.controller.api-access:limit | 访问限制 | 无 |
| sys.controller.api-frequency:limit | 访问频率限制 | 无 |
| sys.error.network:failure | 网络异常 | 无 |
| sys.error.network-status:? | 响应失败 ?为状态码 | 无 |
| sys.check.snunionid.length.is.not:48 | 混淆会员编码长度不是48位 | 使用转换器转换混淆会员编码规定要求混淆会员编码48位 |
Q：商品退库预约信息批量查询接口如何使用？
A：通过此接口可商品退库预约信息批量查询