Filters

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

To filter the results of a query on the cart 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 cart 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": ["..."]

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 created_at updated_at Default is current_date.
discounted	Boolean	One of: true false
gift_card	Boolean	One of: true false
coupon	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": [...]
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
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": [...]
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": ["..."]
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

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": ["..."]

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": ["..."]