Filters

A comprehensive list of the allowed fields values you can use to filter the results of the queries on the order resource

To filter the results of a query on the order resource add the filter object to the request payload specifying the fields (and related attributes) you want to filter by and the operators you want to apply on each of them (see the related tables for the full list), like in the generic example below:

{
  "{{query_type}}": { ... },
  "filter": {
    "order": {
      "date_from": "...",
      "date_to": "...",
      "date_field": "...",
      "total_amount_with_taxes": {
        "gte": ...
      }

      // ...

    },
    "line_items": {
      "types": {
        "in": [
          "...",
          "..."

          // ...

        ]
      },
      "codes": {
        "in": [
          "...",
          "..."

          // ...

        ]
      },
      "options": {
        "names": {
          "in": [
            "...",
            "..."

            // ...

          ]
        },

        // ...

      }
    },
    "customer": {
      "email": {
        "not_in": [
          "...",
          "..."

          // ...

        ]
      }

      // ...

    }

    // ...

  }
}

Please find more information on how filters work here.

Filterable fields and allowed operators

Please find below the full list of the fields (and related attributes) you can filter the results of the queries on the order resource by, and the associated allowed values and valid operators.

billing_address field

Attribute	Type	Values
business	Boolean	One of: true false
cities	Object	One of: "in": ["..."] "not_in": ["..."]
country_codes	Object	One of: "in": ["..."] "not_in": ["..."]
geocoded	Boolean	One of: true false
localized	Boolean	One of: true false
state_codes	Object	One of: "in": ["..."] "not_in": ["..."]
zip_codes	Object	One of: "in": ["..."] "not_in": ["..."]
companies	Object	One of: "in": ["..."] "not_in": ["..."]
first_names	Object	One of: "in": ["..."] "not_in": ["..."]
last_names	Object	One of: "in": ["..."] "not_in": ["..."]

customer field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
emails	Object	One of: "in": ["..."] "not_in": ["..."]
group_names	Object	One of: "in": ["..."] "not_in": ["..."]

line_items field

Attribute	Type	Values
codes	Object	One of: "in": ["..."] "not_in": ["..."]
discount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
ids	Object	One of: "in": ["..."] "not_in": ["..."]
item_ids	Object	One of: "in": ["..."] "not_in": ["..."]
types	Object	One of: "in": ["..."] "not_in": ["..."]
names	Object	One of: "in": ["..."] "not_in": ["..."]
options_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
quantity	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
tax_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
tax_rate	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
total_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
unit_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
updated_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
options	Object	The line item options (see the related table for all the single option objects attributes).

Line item options field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
names	Object	One of: "in": ["..."] "not_in": ["..."]
quantity	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
total_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
unit_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]

market field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
names	Object	One of: "in": ["..."] "not_in": ["..."]
numbers	Object	One of: "in": [...] "not_in": [...]

order field

Attribute	Type	Values
date_from	String	e.g.: 2022-07-06T21:41:03Z No more than 365 days before date_to. Default is 30 day before the current day, beginning of day.
date_to	String	e.g.: 2022-07-06T21:41:03Z No more than 365 days after date_from. Default is the current day, end of day.
date_field	String	One of: current_date approved_at cancelled_at created_at placed_at archived_at updated_at fulfillment_updated_at payment_updated_at Default is current_date.
discounted	Boolean	One of: true false
refunded	Boolean	One of: true false
gift_card	Boolean	One of: true false
coupon	Boolean	One of: true false
returned	Boolean	One of: true false
options	Boolean	One of: true false
adjustment_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
adjustment_tax_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
adjustment_taxable_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
approved_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
archived_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
archived	Boolean	One of: true false
cancelled_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
country_codes	Object	One of: "in": ["..."] "not_in": ["..."]
coupon_codes	Object	One of: "in": ["..."] "not_in": ["..."]
created_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
currency_codes	Object	One of: "in": ["..."] "not_in": ["..."]
discount_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
duty_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
freight_taxable	Boolean	One of: true false
fulfillment_statuses	Object	One of: "in": ["..."] "not_in": ["..."]
fulfillment_updated_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
gift_card_codes	Object	One of: "in": ["..."] "not_in": ["..."]
gift_card_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
guest	Boolean	One of: true false
ids	Object	One of: "in": ["..."] "not_in": ["..."]
language_codes	Object	One of: "in": ["..."] "not_in": ["..."]
line_item_options_count	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
numbers	Object	One of: "in": [...] "not_in": [...]
payment_method_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
payment_method_tax_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
payment_method_taxable_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
payment_statuses	Object	One of: "in": ["..."] "not_in": ["..."]
payment_updated_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
placed_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
references	Object	One of: "in": ["..."] "not_in": ["..."]
reference_origins	Object	One of: "in": ["..."] "not_in": ["..."]
shipments_count	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
shipping_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
shipping_taxable_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
skus_count	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
statuses	Object	One of: "in": ["..."] "not_in": ["..."]
subtotal_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
subtotal_tax_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
subtotal_taxable_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
tax_included	Boolean	One of: true false
total_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
total_amount_with_taxes	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
total_tax_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
total_taxable_amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
updated_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
current_date	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
seconds_in_draft	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
seconds_in_approved	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
seconds_in_placed	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
placed_day_of_week	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
refunds_total_amount_with_taxes	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
total_amount_with_taxes_net_of_refunds	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
aggregated_details	Object	"query": "..."
link_ids	Object	One of: "in": ["..."] "not_in": ["..."]
user_ids	Object	One of: "in": ["..."] "not_in": ["..."]
store_ids	Object	One of: "in": ["..."] "not_in": ["..."]
affiliate_codes	Object	One of: "in": ["..."] "not_in": ["..."]

payment_method field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
source_types	Object	One of: "in": ["..."] "not_in": ["..."]
names	Object	One of: "in": ["..."] "not_in": ["..."]
moto	Boolean	One of: true false
issuer	Object	One of: "in": ["..."] "not_in": ["..."]
issuer_type	Object	One of: "in": ["..."] "not_in": ["..."]
card_type	Object	One of: "in": ["..."] "not_in": ["..."]

refunds field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
amount	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
numbers	Object	One of: "in": ["..."] "not_in": ["..."]

shipping_address field

Attribute	Type	Values
business	Boolean	One of: true false
cities	Object	One of: "in": ["..."] "not_in": ["..."]
country_codes	Object	One of: "in": ["..."] "not_in": ["..."]
geocoded	Boolean	One of: true false
localized	Boolean	One of: true false
state_codes	Object	One of: "in": ["..."] "not_in": ["..."]
zip_codes	Object	One of: "in": ["..."] "not_in": ["..."]

shipments field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
numbers	Object	One of: "in": ["..."] "not_in": ["..."]
statuses	Object	One of: "in": ["..."] "not_in": ["..."]
cancelled_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
on_hold_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
picking_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
packing_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
ready_to_ship_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
shipped_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
created_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
updated_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
references	Object	One of: "in": ["..."] "not_in": ["..."]
reference_origins	Object	One of: "in": ["..."] "not_in": ["..."]
seconds_in_picking	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]
seconds_in_ready_to_ship	Object	One of: "eq": ... "ne": ... "gt": ... "gte": ... "lt": ... "lte": ... "gt_lt": [...] "gte_lte": [...] "gte_lt": [...] "gt_lte": [...]

Shipment stock_location field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
names	Object	One of: "in": ["..."] "not_in": ["..."]
references	Object	One of: "in": ["..."] "not_in": ["..."]
reference_origins	Object	One of: "in": ["..."] "not_in": ["..."]

Shipment shipping_method field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
names	Object	One of: "in": ["..."] "not_in": ["..."]
references	Object	One of: "in": ["..."] "not_in": ["..."]
reference_origins	Object	One of: "in": ["..."] "not_in": ["..."]
currency_codes	Object	One of: "in": ["..."] "not_in": ["..."]

Shipment shipping_category field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
names	Object	One of: "in": ["..."] "not_in": ["..."]
references	Object	One of: "in": ["..."] "not_in": ["..."]
reference_origins	Object	One of: "in": ["..."] "not_in": ["..."]

Shipment tags field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
names	Object	One of: "in": ["..."] "not_in": ["..."]

tags field

Attribute	Type	Values
ids	Object	One of: "in": ["..."] "not_in": ["..."]
names	Object	One of: "in": ["..."] "not_in": ["..."]

resource_errors field

Attribute	Type	Values
codes	Object	One of: "in": ["..."] "not_in": ["..."]
names	Object	One of: "in": ["..."] "not_in": ["..."]
ids	Object	One of: "in": ["..."] "not_in": ["..."]
messages	Object	One of: "in": ["..."] "not_in": ["..."]
created_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]
updated_at	Object	One of: "eq": "..." "ne": "..." "gt": "..." "gte": "..." "lt": "..." "lte": "..." "gt_lt": ["..."] "gte_lte": ["..."] "gte_lt": ["..."] "gt_lte": ["..."]