Search

A comprehensive list of the search query keys and allowed fields values for the order resource

To perform a search query on the order resource send a POST request to the /orders/search endpoint specifying in the payload the query keys and filter parameters like in the generic example below:

{
  "search": {
    "limit": ...,
    "sort": "...",
    "sort_by": "...",
    "interval": "...",
    "fields": [ "...", "...", ... ],
    "cursor": "..."
  },
  "filter": { ... }
}

Please find more information on how search queries work here.

Query keys

These are the keys you need to set when performing a search query:

Key	Type	Required	Description	Values
limit	Integer		The maximum number of records shown in the response.	Default is 50, max is 100.
sort	String		The way you want the results of the query to be sorted.	One of asc or desc (default is desc).
sort_by	String		The date field you want the results of the query sorted by.	Here the full list of valid values for this key. Default is order.current_date.
fields	Array		The list of fields you want to be returned for each record in the response.	Here the full list of valid values for this key. Cannot be empty. Use the .* syntax to request all the attribute for a specific field.
cursor	String		The cursor pointing to a specific page in the paginated search results.	Every time you perform a search query you get the cursor to the next page in the pagination object.

sort_by values

These are the valid values you can specify for the sort_by key of the search query:

• order.approved_at

• order.archived_at

• order.cancelled_at

• order.created_at

• order.current_date

• order.fulfillment_updated_at

• order.payment_updated_at

• order.placed_at

• order.updated_at

field values

These are the valid values you can specify for the field key of the search query:

• billing_address.*

• billing_address.business

• billing_address.city

• billing_address.company

• billing_address.country_code

• billing_address.first_name

• billing_address.geocoded

• billing_address.last_name

• billing_address.localized

• billing_address.state_code

• billing_address.zip_code

• customer.*

• customer.email

• customer.group_name

• customer.id

• line_items.*

• line_items.code

• line_items.discount

• line_items.id

• line_items.item_id

• line_items.item_type

• line_items.name

• line_items.options.*

• line_items.options.id

• line_items.options.name

• line_items.options.quantity

• line_items.options.total_amount

• line_items.options.unit_amount

• line_items.options_amount

• line_items.quantity

• line_items.tax_amount

• line_items.tax_rate

• line_items.total_amount

• line_items.unit_amount

• line_items.updated_at

• market.*

• market.id

• market.name

• market.number

• order.*

• order.adjustment_amount

• order.adjustment_tax_amount

• order.adjustment_taxable_amount

• order.aggregated_details

• order.approved_at

• order.archived

• order.archived_at

• order.cancelled_at

• order.country_code

• order.coupon

• order.coupon_code

• order.created_at

• order.currency_code

• order.current_date

• order.discount_amount

• order.discounted

• order.duty_amount

• order.freight_taxable

• order.fulfillment_status

• order.fulfillment_updated_at

• order.gift_card

• order.gift_card_amount

• order.gift_card_code

• order.guest

• order.id

• order.language_code

• order.line_item_options_count

• order.number

• order.options

• order.payment_method_amount

• order.payment_method_tax_amount

• order.payment_method_taxable_amount

• order.payment_status

• order.payment_updated_at

• order.placed_at

• order.placed_day_of_week

• order.reference

• order.reference_origin

• order.refunded

• order.refunds_total_amount_with_taxes

• order.returned

• order.seconds_in_approved

• order.seconds_in_draft

• order.seconds_in_placed

• order.shipments_count

• order.shipping_amount

• order.shipping_taxable_amount

• order.skus_count

• order.status

• order.subtotal_amount

• order.subtotal_tax_amount

• order.subtotal_taxable_amount

• order.tax_included

• order.total_amount

• order.total_amount_with_taxes

• order.total_amount_with_taxes_net_of_refunds

• order.total_tax_amount

• order.total_taxable_amount

• order.updated_at

• payment_method.*

• payment_method.card_type

• payment_method.id

• payment_method.issuer

• payment_method.issuer_type

• payment_method.moto

• payment_method.name

• payment_method.source_type

• refunds.*

• refunds.amount

• refunds.id

• refunds.number

• shipments.*

• shipments.cancelled_at

• shipments.created_at

• shipments.id

• shipments.number

• shipments.on_hold_at

• shipments.packing_at

• shipments.picking_at

• shipments.ready_to_ship_at

• shipments.reference

• shipments.reference_origin

• shipments.seconds_in_picking

• shipments.seconds_in_ready_to_ship

• shipments.shipped_at

• shipments.shipping_category.*

• shipments.shipping_category.id

• shipments.shipping_category.name

• shipments.shipping_category.reference

• shipments.shipping_category.reference_origin

• shipments.shipping_method.*

• shipments.shipping_method.currency_code

• shipments.shipping_method.id

• shipments.shipping_method.name

• shipments.shipping_method.reference

• shipments.shipping_method.reference_origin

• shipments.status

• shipments.stock_location.*

• shipments.stock_location.id

• shipments.stock_location.name

• shipments.stock_location.reference

• shipments.stock_location.reference_origin

• shipments.tags.*

• shipments.tags.id

• shipments.tags.name

• shipments.updated_at

• shipping_address.*

• shipping_address.business

• shipping_address.city

• shipping_address.country_code

• shipping_address.geocoded

• shipping_address.localized

• shipping_address.state_code

• shipping_address.zip_code

• tags.*

• tags.id

• tags.name