Skip to content
Products
/
/
/
OR11 - List orders with p...

OR11 - List orders with pagination

Request

Description

Returns a 400 Bad Request response if the limit of commercialIds, customerIds, offerIds or productSkus is exceeded.
Pagination is enabled by default. For large requests, use asynchronous order export APIs OR13, OR14 and OR15 instead.

Call Frequency
Default:
Recommended usage:
- Asynchronous: every 5 minutes
- Synchronous: at each order page display
Maximum usage:
- Asynchronous: once per minute
- Synchronous: at each order page display
External Partner:
Recommended usage:
- Asynchronous: every 15 minutes
- Synchronous: at each order page display
Maximum usage:
- Asynchronous: every 15 minutes
- Synchronous: at each order page display
Read More
Pagination

This resource supports offset pagination (see documentation)

Sort fields

sort field can have the following values:

  • dateCreated (Default) - Sort by creation date, and then by order identifier (asc by default)

Localization

This resource supports locale parameter (see documentation)

Localized output fields will be highlighted with an icon:

Security
Front-Bearer-Token or OAuth-2
Query
commercial_idsstring, <= 100

A comma-separated list of order commercial's identifiers

customer_idsstring, <= 100

A comma-separated list of customer's identifiers

customer_organization_idsstring

A comma-separated list of customer organization's identifiers

offer_idsstring, <= 100

A comma-separated list of offer's identifiers

order_idsstring, <= 100

A comma-separated list of order's identifiers

shop_idsstring, <= 100

A comma-separated list of shop's identifiers

order_references_for_customerstring, <= 100

A comma-separated list of order references for customer

order_references_for_sellerstring, <= 100

A comma-separated list of order references for seller

product_skusstring, <= 100

A comma-separated list of product's skus

order_state_codesstring

A comma-separated list of order state's codes

Enum:"STAGING""WAITING_ACCEPTANCE""WAITING_DEBIT""WAITING_DEBIT_PAYMENT""SHIPPING""SHIPPED""TO_COLLECT""RECEIVED""CLOSED""REFUSED"
channel_codesstring, <= 100

A comma-separated list of channel codes

only_null_channelboolean

Return only orders without channel. If true, ignore the channel_codes

Default:false
start_datestring, (date-time)

Start creation date for filtering

end_datestring, (date-time)

End creation date for filtering

start_update_datestring, (date-time)

Start update date for filtering. Mirakl will subtract a time delta to ensure no orders are missed due to network and/or software latency.

end_update_datestring, (date-time)

End update date for filtering

customer_debitedboolean

Order paid by customer

payment_workflowstring

Payment workflow of an order

Enum:"PAY_ON_ACCEPTANCE""PAY_ON_DELIVERY""PAY_ON_DUE_DATE""PAY_ON_SHIPMENT""NO_CUSTOMER_PAYMENT_CONFIRMATION"
has_incidentboolean

If true returns only orders with incidents in progress, if false returns orders without incidents in progress. If not provided, all orders with or without incident will be returned

fulfillment_center_codeArray of strings, <= 100

Code of the fulfillment center

order_tax_modestring

Please note: If the taxes are not specified, the prices with mode TAX_EXCLUDED and with mode TAX_INCLUDED will return the same amounts.
Possible values:

  • TAX_EXCLUDED: the price fields (price, unit price, shipping price, cancellation amount, refund amount and order total prices) do not include taxes.
  • TAX_INCLUDED: the price fields include the tax amount.
  • If this query parameter is not specified, the default order tax mode of the platform is used.

    • Enum:"TAX_INCLUDED""TAX_EXCLUDED"
    commissionableboolean

    If true returns only orders with commission, if false returns orders without commission. Please note that this filter is available only when the platform is in mixed commission model

    waiting_tax_confirmationboolean

    If true returns only orders awaiting a tax confirmation, When false it does not impact the result.

    tax_recalculation_required_onlyboolean

    If true returns only orders for which taxes must be recalculated on at least one order line. When false it does not impact the result. Must be used with at least one date range filter: created or last updated date, of a maximum duration of one month.

    waiting_funding_confirmationboolean

    If true returns only orders awaiting a funding update. When false it does not impact the result.

    refund_state_codesstring

    A comma-separated list of refund state's codes.
    Must be used in combination with filters start_update_date and end_update_date, with a maximum of one month period.

    Enum:"WAITING_REFUND_TAX_CONFIRMATION""WAITING_REFUND""WAITING_REFUND_PAYMENT""REFUNDED"
    curl -i -X GET \
  'https://your-instance.mirakl.net/api/orders?commercial_ids=string&customer_ids=string&customer_organization_ids=string&offer_ids=string&order_ids=string&shop_ids=string&order_references_for_customer=string&order_references_for_seller=string&product_skus=string&order_state_codes=STAGING&channel_codes=string&only_null_channel=false&start_date=2019-08-24T14%3A15%3A22Z&end_date=2019-08-24T14%3A15%3A22Z&start_update_date=2019-08-24T14%3A15%3A22Z&end_update_date=2019-08-24T14%3A15%3A22Z&customer_debited=true&payment_workflow=PAY_ON_ACCEPTANCE&has_incident=true&fulfillment_center_code=string&order_tax_mode=TAX_INCLUDED&commissionable=true&waiting_tax_confirmation=true&tax_recalculation_required_only=true&waiting_funding_confirmation=true&refund_state_codes=WAITING_REFUND_TAX_CONFIRMATION' \
  -H 'Authorization: Bearer <YOUR_JWT_HERE>'

    Responses

    OK

    Bodyapplication/json
    ordersArray of objectsrequired

    List of orders

    total_countinteger, (int32)required

    Total count of orders

    Response
    {
  "orders": [
    { … }
  ],
  "total_count": 1
}