Order Item Id or Collection of Order Item Ids (comma separated)
Example: 1,2,3
Order Id or Collection of Order Ids (comma separated)
Example: 1,2,3
Order Number or Collection of Order Numbers (comma separated)
Example: 1,2,3
Order Item Type or Collection of Order Item Types (comma separated)
Example: 1,2,3
Fulfilment Outlet or Collection of Fulfilment Outlets (comma separated)
Example: 1,2,3
Source Outlet or Collection of Source Outlets (comma separated)
Example: 1,2,3
Created since
Modified since
Filter by.
Available field name values: id, order_id, order_number, order_item_type, return_reason_id, return_reason_name, original_order_item_id, notes, fulfil_outlet, source_outlet, created_on, modified_on, serial_number.
In string values: ‘|’ and ‘,’ characters have to be escaped with slash, i.e. ‘\,’ ‘\|’
For operators that support multiple values (in, notin): multiple values are delimited using ‘|’ character
Available operators:
eq - Equal
neq - Not equals
lt - Less
lte - Less or equal
gt - Greater
gte - Greater or equal
in - In
notin - Not In
contains - Contains
isnull - Is Null
isnullorempty - Is Null Or Empty
isnotnull - Is Not Null
startswith - Starts with
endswith - Ends with
doesnotcontain - Does not contain
For non-nullable fields operators isnull and isnotnull are unavailable
For dates operators: contains, startswith, endswith, doesnotcontain, isnullorempty are unavailable
For strings operators: lt, lte, gt, gte are unavailable
Example: created_on:gte:2021-06-03T05:48:09+10:00,id:in:2|3
Order by.
Available field name values: id, order_id, order_number, order_item_type, return_reason_name, notes, fulfil_outlet, source_outlet, created_on, modified_on.
Available direction values: asc, desc.
Example: order_id asc, order_number desc
>= 1<= 100000
>= 1<= 2147483647