Get Open Orders with filters set to:
Order with no Tags assigned
entriesPerPage=100&pageNumber=1&filters={"ListFields": [{"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":1}, {"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":2}, {"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":3}, {"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":4}, {"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":5}, {"FieldCode":"GENERAL_INFO_TAG","Type":1,"Value":6}]}&sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=
Get Open Orders with filters set to:
Order Tracking number: 1234567
entriesPerPage=100&pageNumber=1&filters= {"TextFields": [{"FieldCode":"SHIPPING_INFORMATION_TRACKING_NUMBER","Type":0,"Text":"1234567"}]}&sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=
Get Open Orders with filters set to:
Only Linked items in the order
entriesPerPage=100&pageNumber=1&filters={"ListFields": [{"FieldCode":"STOCK_LEVEL","Value":-1,"Type":1}]}&sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=
Get Open Orders with filters set to:
Order Locked: No
Order Status: Paid
Order Shipping Service: RM 24 - CRL
Default Location (Empty Guid)
entriesPerPage=100&pageNumber=1& filters={"BooleanFields":[{"FieldCode":"GENERAL_INFO_LOCKED","Value":"false"}], "ListFields":[{"FieldCode":"GENERAL_INFO_STATUS","Value":1}, {"FieldCode":"SHIPPING_INFORMATION_SERVICE","Value":"RM 24 - CRL"}]}& sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=
Get Open Orders with filters set to:
Customer Address Line 1 equals to: 22 George St
Customer Address Line 2 contains: Mayfair Court
Customer Address Line 3 starts with: Sunshine
Customer Company Name ends with: Views
entriesPerPage=100&pageNumber=1& filters={"TextFields":[{"FieldCode":"CUSTOMER_ADDRESS_ADDRESS1","Type":0,"Text":"22 George St"}, {"FieldCode":"CUSTOMER_ADDRESS_ADDRESS2","Type":1,"Text":"Mayfair Court"}, {"FieldCode":"CUSTOMER_ADDRESS_ADDRESS3","Type":2,"Text":"Sunshine"}, {"FieldCode":"CUSTOMER_ADDRESS_COMPANY","Type":3,"Text":"Views"}]} &sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=
Get Open Orders within date range:
entriesPerPage=100&pageNumber=1& filters={"DateFields":[{"FieldCode":"GENERAL_INFO_DATE","Type":"Range","DateFrom":"2016-08-16T23:00:00.000Z","DateTo":"2016-08-20T23:00:00.000Z"}]} &sorting=[]&fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=
Get Open Order with filters and sorting set to:
Order Status: Paid
Sort Ascending By: Order Items Quantity
entriesPerPage=100&pageNumber=1& filters={"ListFields":[{"FieldCode":"GENERAL_INFO_STATUS","Type":0,"Value":1}]}& sorting=[{"Direction":0,"FieldCode":"ITEMS_QUANTITY"}]& fulfilmentCenter=00000000-0000-0000-0000-000000000000&additionalFilter=
BooleanFields codes:
GENERAL_INFO_LABEL_PRINTED
GENERAL_INFO_INVOICE_PRINTED
GENERAL_INFO_PICK_LIST_PRINTED
GENERAL_INFO_PART_SHIPPED
GENERAL_INFO_LOCKED
GENERAL_INFO_PARKED
ITEMS_IMAGE
BooleanFields values:
true
false
ListFields codes:
GENERAL_INFO_SOURCE
GENERAL_INFO_SUBSOURCE
GENERAL_INFO_STATUS
GENERAL_INFO_TAG
SHIPPING_INFORMATION_SERVICE_ID
SHIPPING_INFORMATION_VENDOR
SHIPPING_INFORMATION_SERVICE
SHIPPING_INFORMATION_PACKAGING_GROUP
CUSTOMER_ADDRESS_COUNTRY
CUSTOMER_ADDRESS_COUNTRY_ZONE
TOTALS_CURRENCY
TOTALS_PAYMENT_METHOD
FOLDER
ITEMS_CATEGORY
STOCK_LEVEL
TextFields codes:
GENERAL_INFO_ORDER_ID
GENERAL_INFO_REFERENCE_NUMBER
GENERAL_INFO_EXTERNAL_REFERENCE_NUMBER
SHIPPING_INFORMATION_TRACKING_NUMBER
CUSTOMER_ADDRESS_ADDRESS1
CUSTOMER_ADDRESS_ADDRESS2
CUSTOMER_ADDRESS_ADDRESS3
CUSTOMER_ADDRESS_COMPANY
CUSTOMER_ADDRESS_FULL_NAME
CUSTOMER_ADDRESS_POSTCODE
CUSTOMER_ADDRESS_TOWN
CUSTOMER_ADDRESS_COUNTY
CUSTOMER_EMAIL
CUSTOMER_PHONE
ITEMS_SKU
ITEMS_ORIGINAL_SKU
ITEMS_TITLE
ITEMS_ORIGINAL_TITLE
ITEMS_BINRACK
TextFields Type:
Equals: 0
Contains: 1
Starts With: 2
Ends With: 3
Numeric Field Type:
Equal: 0
Greater: 1
Lower: 2
ListFields Type:
IS (equals): 0
IS NOT (not equal): 1
DateTimeField Type:
Range: 0,
OlderThan: 1
LastDays: 2
IntegerField codes:
GENERAL_INFO_NOTES
GENERAL_INFO_ITEMS_COUNT
Sorting Direction:
Ascending: 0
Descending: 1
ListFields Values:
STOCK_LEVELUnlinked: -1
Insufficient to fulfill all orders: 1
Reaching Minimum Level: 2
Out-of-stock: 3
Awaiting Stock: 4
Awaiting Stock - Oversold: 5
Approaching Minimum Level: 6
Sufficient Stock Level: 7
Optimal Stock Level: 8
Potentially Overstocking: 9
Overstocking: 10
No Minimum Level: 11
Unpaid: 0
Paid: 1
Return: 2
Payment Pending: 3
Resend: 4
Locked: 5
Parked: 6