suning.fws.historyorder.query 批量查询订单记录接口
¥免费

通过此接口可查询指定服务的在线订购订单,可以通过服务代码,查询该服务在指定时间内所有收费项目的订单记录,或者通过服务代码、收费项目代码组合查询指定时间内该服务下某一具体收费项目的订单记录;

公共参数
请求参数
名称 类型 是否必须 示例值 描述
serverId String N S01234567890 服务市场的服务的代码
chargeId String N S01234567890 收费项目代码。服务的子项目的代码
startTime String Y 2015-01-01 00:00:00 开始时间。查询开始时间之后创建的订单,开始时间和结束时间必须成对出现,查询时间起止日期不能超过3个月
endTime String Y 2015-02-01 00:00:00 结束时间。查询结束时间之前创建的订单,开始时间和结束时间必须成对出现,查询时间起止日期不能超过3个月
orderCategory String N 1 服务市场订单类型:1新订;2续订;3升级;不输入,则查询所有类型;
pageNo String N 1 页码。取值范围:大于零的整数,最大值:99999;默认值为1,即返回第一页数据
pageSize String N 10 每页条数。取值范围:大于零的整数;最大值:100。默认值:10。
响应参数
名称 类型 示例值 描述
orderId String null 服务市场的订单号
orderCategory String null 服务市场订单类型:1新订;2续订;3升级;
shopName String null 商户名称
businessAccounts String null 商户账号
createTime String null 下单时间。成功购买服务时间;格式:yyyy-MM-dd hh:mm:ss
serverId String null 服务市场的服务的代码
serviceName String null 服务市场的服务名称
chargeId String null 收费项目代码。服务的子项目的代码
chargeName String null 收费项目名称。服务的子项目的名称
orderDetailId String null 订单行号。订单详情编号
orderQuantity String null 订购数量
basePrice String null 订购单价
effectiveTime String null 生效时间。购买服务生效时间;格式:yyyy-MM-dd hh:mm:ss
failureTime String null 失效时间。购买服务截止时间;格式:yyyy-MM-dd hh:mm:ss
originalCostTotal String null 订购总价。行订单的总价,购买数量*订购单价;例:30.00;单位元;整数10位,小数两位
realPaymentTotal String null 订购金额。行订单的订购金额,订购总价-行订单优惠金额;例:20.00;单位元;整数10位,小数两位
preferentialPriceTotal String null 优惠金额。折扣金额+减免金额;例:10.00;单位元;整数10位,小数两位
请求示例
  • XML示例
  • JSON示例
复制全部代码
                                <sn_request>
	<sn_body>
		<queryHistoryOrder>
			<serverId>S01234567890</serverId>
			<chargeId>S01234567890</chargeId>
			<startTime>2015-01-01 00:00:00</startTime>
			<endTime>2015-02-01 00:00:00</endTime>
			<orderCategory>1</orderCategory>
			<pageNo>1</pageNo>
			<pageSize>10</pageSize>
		</queryHistoryOrder>
	</sn_body>
</sn_request>
                                
                                {
	"sn_request": {
		"sn_body": {
			"queryHistoryOrder": {
				"serverId": "S01234567890",
				"chargeId": "S01234567890",
				"startTime": "2015-01-01 00:00:00",
				"endTime": "2015-02-01 00:00:00",
				"orderCategory": "1",
				"pageNo": "1",
				"pageSize": "10"
			}
		}
	}
}
                                
响应示例
  • XML示例
  • JSON示例
复制全部代码
                              <sn_responseContent>
	<sn_head>
		<pageTotal>1</pageTotal>
		<pageNo>1</pageNo>
		<pageSize>10</pageSize>
		<returnMessage>biz.handler.data-get:success</returnMessage>
	</sn_head>
	<sn_body>
		<queryHistoryOrder>
			<orderId>S01234567890</orderId>
			<orderCategory>1</orderCategory>
			<shopName>农夫山泉</shopName>
			<businessAccounts>Xx@qqqq.com</businessAccounts>
			<createTime>2015-01-10 00:00:00</createTime>
			<orderDetail>
				<serverId>S01234567890</serverId>
				<serviceName>饮料类检测</serviceName>
				<chargeId>S01234567890</chargeId>
				<chargeName>水质检测</chargeName>
				<orderDetailId>S01234567890</orderDetailId>
				<orderQuantity>20</orderQuantity>
				<basePrice>10</basePrice>
				<effectiveTime>2015-01-11 00:00:00</effectiveTime>
				<failureTime>2015-04-11 00:00:00</failureTime>
				<originalCostTotal>30</originalCostTotal>
				<realPaymentTotal>10</realPaymentTotal>
				<preferentialPriceTotal>20</preferentialPriceTotal>
			</orderDetail>
			<orderDetail>
				<serverId>S01234567890</serverId>
				<serviceName>饮料类检测</serviceName>
				<chargeId>S01234567890</chargeId>
				<chargeName>水质检测</chargeName>
				<orderDetailId>S01234567890</orderDetailId>
				<orderQuantity>20</orderQuantity>
				<basePrice>10</basePrice>
				<effectiveTime>2015-01-11 00:00:00</effectiveTime>
				<failureTime>2015-04-11 00:00:00</failureTime>
				<originalCostTotal>30</originalCostTotal>
				<realPaymentTotal>10</realPaymentTotal>
				<preferentialPriceTotal>20</preferentialPriceTotal>
			</orderDetail>
		</queryHistoryOrder>
		<queryHistoryOrder>
			<orderId>S01234567890</orderId>
			<orderCategory>1</orderCategory>
			<shopName>农夫山泉</shopName>
			<businessAccounts>Xx@qqqq.com</businessAccounts>
			<createTime>2015-01-10 00:00:00</createTime>
			<orderDetail>
				<serverId>S01234567890</serverId>
				<serviceName>饮料类检测</serviceName>
				<chargeId>S01234567890</chargeId>
				<chargeName>水质检测</chargeName>
				<orderDetailId>S01234567890</orderDetailId>
				<orderQuantity>20</orderQuantity>
				<basePrice>10</basePrice>
				<effectiveTime>2015-01-11 00:00:00</effectiveTime>
				<failureTime>2015-04-11 00:00:00</failureTime>
				<originalCostTotal>30</originalCostTotal>
				<realPaymentTotal>10</realPaymentTotal>
				<preferentialPriceTotal>20</preferentialPriceTotal>
			</orderDetail>
			<orderDetail>
				<serverId>S01234567890</serverId>
				<serviceName>饮料类检测</serviceName>
				<chargeId>S01234567890</chargeId>
				<chargeName>水质检测</chargeName>
				<orderDetailId>S01234567890</orderDetailId>
				<orderQuantity>20</orderQuantity>
				<basePrice>10</basePrice>
				<effectiveTime>2015-01-11 00:00:00</effectiveTime>
				<failureTime>2015-04-11 00:00:00</failureTime>
				<originalCostTotal>30</originalCostTotal>
				<realPaymentTotal>10</realPaymentTotal>
				<preferentialPriceTotal>20</preferentialPriceTotal>
			</orderDetail>
		</queryHistoryOrder>
	</sn_body>
</sn_responseContent>
                              
                              {
	"sn_responseContent": {
		"sn_head": {
			"pageTotal": "1",
			"pageNo": "1",
			"pageSize": "10",
			"returnMessage": "biz.handler.data-get:success"
		},
		"sn_body": {
			"queryHistoryOrder": [
			{
				"orderId": "S01234567890",
				"orderCategory": "1",
				"shopName": "农夫山泉",
				"businessAccounts": "Xx@qqqq.com",
				"createTime": "2015-01-10 00:00:00",
				"orderDetail": [
				{
					"serverId": "S01234567890",
					"serviceName": "饮料类检测",
					"chargeId": "S01234567890",
					"chargeName": "水质检测",
					"orderDetailId": "S01234567890",
					"orderQuantity": "20",
					"basePrice": "10",
					"effectiveTime": "2015-01-11 00:00:00",
					"failureTime": "2015-04-11 00:00:00",
					"originalCostTotal": "30",
					"realPaymentTotal": "10",
					"preferentialPriceTotal": "20"
				},
				{
					"serverId": "S01234567890",
					"serviceName": "饮料类检测",
					"chargeId": "S01234567890",
					"chargeName": "水质检测",
					"orderDetailId": "S01234567890",
					"orderQuantity": "20",
					"basePrice": "10",
					"effectiveTime": "2015-01-11 00:00:00",
					"failureTime": "2015-04-11 00:00:00",
					"originalCostTotal": "30",
					"realPaymentTotal": "10",
					"preferentialPriceTotal": "20"
				}]
			},
			{
				"orderId": "S01234567890",
				"orderCategory": "1",
				"shopName": "农夫山泉",
				"businessAccounts": "Xx@qqqq.com",
				"createTime": "2015-01-10 00:00:00",
				"orderDetail": [
				{
					"serverId": "S01234567890",
					"serviceName": "饮料类检测",
					"chargeId": "S01234567890",
					"chargeName": "水质检测",
					"orderDetailId": "S01234567890",
					"orderQuantity": "20",
					"basePrice": "10",
					"effectiveTime": "2015-01-11 00:00:00",
					"failureTime": "2015-04-11 00:00:00",
					"originalCostTotal": "30",
					"realPaymentTotal": "10",
					"preferentialPriceTotal": "20"
				},
				{
					"serverId": "S01234567890",
					"serviceName": "饮料类检测",
					"chargeId": "S01234567890",
					"chargeName": "水质检测",
					"orderDetailId": "S01234567890",
					"orderQuantity": "20",
					"basePrice": "10",
					"effectiveTime": "2015-01-11 00:00:00",
					"failureTime": "2015-04-11 00:00:00",
					"originalCostTotal": "30",
					"realPaymentTotal": "10",
					"preferentialPriceTotal": "20"
				}]
			}]
		}
	}
}
                              
异常示例
  • XML示例
  • JSON示例
复制全部代码

  
  	API异常码
  	异常码中文描述
  

                           	  
{
  "sn_responseContent": {
    "sn_error": {
      "error_code": "API异常码",
      "error_msg": "异常码中文描述"
    }
  }
}
                           		
业务异常码
异常码 错误描述 解决方案
biz.handler.data-get:no-result 查询无结果 请输入正确参数。
isp.sys.service.unavailable.fws 服务不可用(系统异常) 请联系苏宁技术人员。
biz.fws.queryhistoryorder.missing-parameter:startTime 开始时间为空(必填) 请输入正确参数。
biz.fws.queryhistoryorder.missing-parameter:endTime 结束时间为空(必填) 请输入正确参数。
公共异常码
API工具
FAQ

Q:批量查询订单记录接口接口如何使用?

A:通过此接口可查询指定服务的在线订购订单,可以通过服务代码,查询该服务在指定时间内所有收费项目的订单记录,或者通过服务代码、收费项目代码组合查询指定时间内该服务下某一具体收费项目的订单记录;