聚水潭订单查询_v1 API

Platform: 聚水潭
Type: WebAPI
Effect: QUERY
API Version: 0.1
Adapter: \Adapter\Jushuitan\JushuitanQueryAdapter
Auth Mode: OTHER
Help Link: https://open.jushuitan.com/document/2125.html
Doc Link: https://open.jushuitan.com/document/2125.html
Updated At: 2021-04-16

订单查询_v1

POSTorders.single.query

Factory

{
  "operation": {
    "method": "none"
  }
}

Request Parameters

No.	Field	Name	Type	Default	Required	Description
1	shop_id	shop_id	string	1	Optional	店铺编号
2	is_offline_shop	is_offline_shop	string	1	Optional	shop_id为0且is_offline_shop为true查询线下店铺单据
3	so_ids	so_ids	string	1	Optional	线上单号，最大限制20条
4	modified_begin	modified_begin	string	{{LAST_SYNC_TIME\|datetime}}	Optional	修改起始时间，和结束时间必须同时存在，时间间隔不能超过七天，与线上单号不能同时为空
5	modified_end	modified_end	string	{{CURRENT_TIME\|datetime}}	Optional	修改结束时间，和起始时间必须同时存在，时间间隔不能超过七天，与线上单号不能同时为空
6	status	status	string	Sent	Optional	待付款：WaitPay；发货中：Delivering；被合并：Merged；异常：Question；被拆分：Split；等供销商\|外仓发货：WaitOuterSent；已付款待审核：WaitConfirm；已客审待财审：WaitFConfirm；已发货：Sent；取消：Cancelled
7	page_index	page_index	string	1	Optional	第几页，从1开始
8	page_size	page_size	string	50	Optional	最每页多少条，最大50条

Response Parameters

No.	Field	Name	Type	Default	Required	Description
1	is_cod	is_cod	string	1	Optional	111
2	l_id	l_id	string	1	Optional	111
3	send_date	send_date	string	1	Optional	111
4	pay_date	pay_date	string	1	Optional	111
5	freight	freight	string	1	Optional	111
6	receiver_address	receiver_address	string	1	Optional	111
7	receiver_district	receiver_district	string	1	Optional	111
8	wms_co_id	wms_co_id	string	1	Optional	111
9	logistics_company	logistics_company	string	1	Optional	111
10	free_amount	free_amount	string	1	Optional	111
11	shop_name	shop_name	string	1	Optional	111
12	question_type	question_type	string	1	Optional	111
13	outer_pay_id	outer_pay_id	string	1	Optional	111
14	so_id	so_id	string	1	Optional	111
15	type	type	string	1	Optional	111
16	order_from	order_from	string	1	Optional	111
17	status	status	string	1	Optional	111
18	pay_amount	pay_amount	string	1	Optional	111
19	shop_buyer_id	shop_buyer_id	string	1	Optional	111
20	shop_status	shop_status	string	1	Optional	111
21	receiver_mobile	receiver_mobile	string	1	Optional	111
22	order_date	order_date	string	1	Optional	111
23	question_desc	question_desc	string	1	Optional	111
24	receiver_city	receiver_city	string	1	Optional	111
25	receiver_state	receiver_state	string	1	Optional	111
26	receiver_name	receiver_name	string	1	Optional	111
27	o_id	o_id	string	1	Optional	111
28	shop_id	shop_id	string	1	Optional	111
29	co_id	co_id	string	1	Optional	111
30	pays	pays	array	1	Optional	111
31	items	items	array	1	Optional	111
32	remark	remark	string	1	Optional	111
33	drp_co_id_from	drp_co_id_from	string	1	Optional	111
34	modified	modified	string	1	Optional	111
35	labels	labels	string	1	Optional	111
36	paid_amount	paid_amount	string	1	Optional	111
37	currency	currency	string	1	Optional	111
38	buyer_message	buyer_message	string	1	Optional	111
39	lc_id	lc_id	string	1	Optional	111
40	invoice_title	invoice_title	string	1	Optional	111
41	invoice_type	invoice_type	string	1	Optional	111
42	buyer_tax_no	buyer_tax_no	string	1	Optional	111
43	creator_name	creator_name	string	1	Optional	111
44	plan_delivery_date	plan_delivery_date	string	1	Optional	111
45	node	node	string	1	Optional	111
46	receiver_town	receiver_town	string	1	Optional	111
47	drp_co_id_to	drp_co_id_to	string	1	Optional	111
48	is_order_pay	is_order_pay	string	1	Optional	111
49	buyer_account	buyer_account	string	1	Optional	111
50	amount	amount	string	1	Optional	111
51	pay_date	pay_date	string	1	Optional	111
52	outer_pay_id	outer_pay_id	string	1	Optional	111
53	pay_id	pay_id	string	1	Optional	111
54	payment	payment	string	1	Optional	111
55	is_gift	is_gift	string	1	Optional	111
56	sku_id	sku_id	string	1	Optional	111
57	name	name	string	1	Optional	111
58	refund_status	refund_status	string	1	Optional	111
59	refund_id	refund_id	string	1	Optional	111
60	price	price	string	1	Optional	111
61	outer_oi_id	outer_oi_id	string	1	Optional	111
62	item_status	item_status	string	1	Optional	111
63	i_id	i_id	string	1	Optional	111
64	properties_value	properties_value	string	1	Optional	111
65	oi_id	oi_id	string	1	Optional	111
66	amount	amount	string	1	Optional	111
67	shop_sku_id	shop_sku_id	string	1	Optional	111
68	raw_so_id	raw_so_id	string	1	Optional	111
69	qty	qty	string	1	Optional	111
70	is_presale	is_presale	string	1	Optional	111
71	base_price	base_price	string	1	Optional	111
72	pic	pic	string	1	Optional	111
73	sku_type	sku_type	string	1	Optional	111

The 订单查询_v1 API (orders.single.query) of 聚水潭 is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 聚水潭 version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.