Skip to content

List orders

GET
/orders
curl --request GET \
--url 'https://api.connectato.com/v1/orders?sort=placed_at' \
--header 'Authorization: Bearer <token>'

Scope: read_orders.

Every order, whatever its status, newest placed first unless sorted otherwise; narrowed by the orders list’s own filters. A store app finds its own with filter[integration] (its store, caller.store on GET /organization) and filter[external_id] (its ids).

limit
integer
>= 1 <= 200

Items per page. Default: 50.

cursor
string

The previous page’s next_cursor, with the same filter, sort and updated_since.

sort
string
Allowed values: placed_at number total updated_at -placed_at -number -total -updated_at

The order; - before a key for descending. Default: -placed_at.

updated_since
string format: date-time

Only what changed at or after this moment (RFC 3339), read in sort=updated_at.

filter[status]
Array<string>
Allowed values: checking needs_attention to_process processed cancelled closed

One or more codes, comma-separated (filter[status]=a,b), or filter[status][is_not]=a,b for the others.

filter[vendor]
Array<string>
Allowed values: shopify woocommerce trendyol test_store app

One or more codes, comma-separated (filter[vendor]=a,b), or filter[vendor][is_not]=a,b for the others.

filter[integration]
Array<string>

One or more public ids (int_...), comma-separated (filter[integration]=a,b), or filter[integration][is_not]=a,b for the others.

filter[external_id]
Array<string>
>= 1 items <= 100 items

Exact values, matched as written: up to 100, comma-separated (filter[external_id]=a,b), or filter[external_id][is_not]=a,b for the others.

filter[payment_status]
Array<string>
Allowed values: pending authorized partially_paid paid partially_refunded refunded voided failed not_applicable

One or more codes, comma-separated (filter[payment_status]=a,b), or filter[payment_status][is_not]=a,b for the others.

filter[payment_method]
Array<string>
Allowed values: cod card bank_transfer cash gift_card store_credit other

One or more codes, comma-separated (filter[payment_method]=a,b), or filter[payment_method][is_not]=a,b for the others.

filter[fulfillment_status]
Array<string>
Allowed values: unfulfilled partial fulfilled shipped delivered returned restocked on_hold

One or more codes, comma-separated (filter[fulfillment_status]=a,b), or filter[fulfillment_status][is_not]=a,b for the others.

filter[returns]
Array<string>
Allowed values: in_store by_courier

One or more codes, comma-separated (filter[returns]=a,b), or filter[returns][is_not]=a,b for the others.

filter[printed]
Array<string>
Allowed values: printed not_printed

One or more codes, comma-separated (filter[printed]=a,b), or filter[printed][is_not]=a,b for the others.

filter[total]
string

A span: filter[total][min]= and/or filter[total][max]=; [is_not] for outside.

filter[placed_at]
string

Whole days in the organization’s zone: a period (today, last_7_days, last_30_days, last_90_days, last_12_months) or filter[placed_at][from]=Y-m-d&filter[placed_at][to]=Y-m-d; [is_not] for outside.

A page of the list.

Media typeapplication/json
object
data
required
Array<object>
OrderResource
object
id
required

The order’s public id (ord_...).

string
/^ord_[0-9a-z]{26}$/
number
required

The number the merchant and the buyer know, as the store shows it; null when the store gives none.

string | null
external_id
required

The store’s own id of the order.

string
integration_id
required

The store integration (int_..., see /integrations) it came from; null once that integration was removed.

string | null
/^int_[0-9a-z]{26}$/
vendor
required

The store’s vendor code: shopify, woocommerce, trendyol, test_store; app for a partner’s app that is a store (which one: integration_id). New values may appear: treat one you do not know as such.

string
status
required

Derived from the facts, never set by hand or by the store: checking, needs_attention, to_process, processed, cancelled, closed. New values may appear: treat one you do not know as such.

string
fulfillment_status
required

The store’s own fulfillment state (filter[fulfillment_status]): unfulfilled, partial, fulfilled, shipped, delivered, returned, restocked, on_hold; null when the store gives none. New values may appear: treat one you do not know as such.

string | null
returns
required

How the order came back (filter[returns]): in_store (marked returned in the store), by_courier (the parcel brought back, until the store restocks, cancels or closes the order). Empty when neither.

Array<string>
printed_at
required

When its AWB and invoice were last printed from the app; null while never printed (filter[printed]=printed or not_printed). An AWB undone clears it.

string | null format: date-time
issues
required

The open issues, blocking first; at most 250. Codes only: the app words them.

Array<object>
object
code
required

The exact problem, a stable snake_case code (phone_invalid). Order: address_missing, field_missing, field_too_long, phone_invalid, postal_code_invalid, region_not_found, locality_not_found, locality_sector_missing, payment_method_missing, payment_method_unmapped, pickup_point_missing, pickup_point_unidentified, correction_conflict, correction_conflict_emptied, delivery_service_released. AWB: route_unavailable, route_ (route_no_service_for_address, route_account_paused…), sender_address_unconfigured, weight_unconfigured, product_weight_missing, pickup_point_unknown, pickup_point_unplaced, pickup_point_closed, pickup_point_full, pickup_point_too_heavy, pickup_point_too_large, pickup_point_no_cod, pickup_point_email_missing, handover_point_full. Invoice: invoicer_unchosen, invoicing_settings_incomplete, invoice_data_invalid, billing_sector_missing. New codes may appear.

string
step
required

The step it holds: awb or invoice. New values may appear: treat one you do not know as such.

string
field
required

The field path (shipping.phone, order.total_weight); null for the order as a whole.

string | null
kind
required

Missing, invalid, not_found, mismatch, unconfigured, conflict, suspicious. New values may appear: treat one you do not know as such.

string
severity
required

Blocking (stops its step) or warning. New values may appear: treat one you do not know as such.

string
detected_at
required
string format: date-time
customer
required

Who placed it: the billing contact, else the shipping one.

object
name
required
string | null
email
required
string | null
phone
required
string | null
billing_address
required

The address the invoice is made out to; null when the store sent none.

object
name
required
string | null
first_name
required
string | null
last_name
required
string | null
company
required
string | null
email
required
string | null
phone
required
string | null
address_line_1
required
string | null
address_line_2
required
string | null
city
required
string | null
region
required
string | null
region_code
required
string | null
postal_code
required
string | null
country_code
required
string | null
locality_code
required
string | null
tax_id
required

The fiscal code (CUI, VAT number), for a company.

string | null
shipping_address
required

Where the parcel goes (for a pickup point, only the contact counts); null when the store sent none.

object
name
required
string | null
first_name
required
string | null
last_name
required
string | null
company
required
string | null
email
required
string | null
phone
required
string | null
address_line_1
required
string | null
address_line_2
required
string | null
city
required
string | null
region
required
string | null
region_code
required
string | null
postal_code
required
string | null
country_code
required
string | null
locality_code
required
string | null
tax_id
required

The fiscal code (CUI, VAT number), for a company.

string | null
line_items
required

In the store’s order; at most 250 (see line_items_count).

Array<object>
object
sku
required
string | null
name
required

The product’s name, as sold.

string | null
quantity
required

A decimal string, trailing zeros trimmed (2).

string
unit_price
required

One unit before discounts, in the store’s price convention (prices_include_tax).

object
amount
required
string
currency
required
string
discount
required

The line’s discount, its share of order discounts included.

object
amount
required
string
currency
required
string
tax_rate
required

A percentage (19.0000).

string | null
tax
required
object
amount
required
string
currency
required
string
total
required

The line after every discount, tax included.

object
amount
required
string
currency
required
string
line_items_count
required

Every line of the order, also those past the list’s bound.

integer
shipping_lines
required
Array<object>
object
code
required

The store’s own id of the shipping method.

string | null
title
required

The method’s name, as the buyer saw it.

string | null
price
required

Before discounts, in the store’s price convention.

object
amount
required
string
currency
required
string
discount
required
object
amount
required
string
currency
required
string
tax_rate
required
string | null
tax
required
object
amount
required
string
currency
required
string
total
required

After discounts, tax included.

object
amount
required
string
currency
required
string
fees
required
Array<object>
object
name
required
string | null
tax_rate
required
string | null
tax
required
object
amount
required
string
currency
required
string
total
required

Signed: a surcharge positive, an adjustment negative; tax included.

object
amount
required
string
currency
required
string
currency
required

ISO 4217; every amount of the order is in it.

string
prices_include_tax
required

Whether the store’s prices (unit prices, subtotal, shipping prices) include tax.

boolean
totals
required
object
subtotal
required
object
amount
required
string
currency
required
string
discount
required
object
amount
required
string
currency
required
string
shipping
required
object
amount
required
string
currency
required
string
tax
required
object
amount
required
string
currency
required
string
total
required
object
amount
required
string
currency
required
string
payment
required
object
method
required

Cod, card, bank_transfer, cash, gift_card, store_credit, other; null while the store’s gateway is not mapped. New values may appear: treat one you do not know as such.

string | null
status
required

Pending, authorized, partially_paid, paid, partially_refunded, refunded, voided, failed, not_applicable; null when the store gives none. New values may appear: treat one you do not know as such.

string | null
cod
required

Cash on delivery: what is left to collect from the buyer; null without.

object
amount
required
string
currency
required
string
delivery
required
object
method
required

What the buyer asked: address, pickup_point, store_pickup, mixed (a shipment’s delivery_method takes the first two). New values may appear: treat one you do not know as such.

string
carrier
required

The carrier the buyer picked at checkout for a delivery to the door; null for any or another type.

string | null
pickup_point
required

The point the buyer picked; null unless type is pickup_point.

object
external_id
required

The point’s id in its provider’s ids; null while the store named none.

string | null
provider
required

Whose ids the point’s id is in.

string | null
name
required
string | null
address
required
string | null
service
required

The courier service the AWB ships with; null until one is picked.

object
integration_id
required

The courier connection (int_...).

string | null
/^int_[0-9a-z]{26}$/
code
required

In that connection’s service codes.

string
selected_by
required

Manual (the merchant), rule (a delivery rule), fallback (the organization’s default). New values may appear: treat one you do not know as such.

string | null
selected_at
required
string | null format: date-time
total_weight_kg
required

The parcel’s weight in kilograms (the store’s, or the merchant’s correction).

string | null
placed_at
required

When the buyer placed it, as the store says.

string | null format: date-time
source_updated_at
required

When it last changed at its store, as the store says (a store app’s updated_at, to the microsecond): the version held, which a store app compares with its own.

string | null format: date-time
created_at
required
string format: date-time
updated_at
required
string format: date-time
next_cursor
required

The next page’s cursor; null on the last page.

string | null

Example generated

{
"data": [
{
"id": "example",
"number": "example",
"external_id": "example",
"integration_id": "example",
"vendor": "example",
"status": "example",
"fulfillment_status": "example",
"returns": [
"example"
],
"printed_at": "2026-04-15T12:00:00Z",
"issues": [
{
"code": "example",
"step": "example",
"field": "example",
"kind": "example",
"severity": "example",
"detected_at": "2026-04-15T12:00:00Z"
}
],
"customer": {
"name": "example",
"email": "example",
"phone": "example"
},
"billing_address": {
"name": "example",
"first_name": "example",
"last_name": "example",
"company": "example",
"email": "example",
"phone": "example",
"address_line_1": "example",
"address_line_2": "example",
"city": "example",
"region": "example",
"region_code": "example",
"postal_code": "example",
"country_code": "example",
"locality_code": "example",
"tax_id": "example"
},
"shipping_address": {
"name": "example",
"first_name": "example",
"last_name": "example",
"company": "example",
"email": "example",
"phone": "example",
"address_line_1": "example",
"address_line_2": "example",
"city": "example",
"region": "example",
"region_code": "example",
"postal_code": "example",
"country_code": "example",
"locality_code": "example",
"tax_id": "example"
},
"line_items": [
{
"sku": "example",
"name": "example",
"quantity": "example",
"unit_price": {
"amount": "example",
"currency": "example"
},
"discount": {
"amount": "example",
"currency": "example"
},
"tax_rate": "example",
"tax": {
"amount": "example",
"currency": "example"
},
"total": {
"amount": "example",
"currency": "example"
}
}
],
"line_items_count": 1,
"shipping_lines": [
{
"code": "example",
"title": "example",
"price": {
"amount": "example",
"currency": "example"
},
"discount": {
"amount": "example",
"currency": "example"
},
"tax_rate": "example",
"tax": {
"amount": "example",
"currency": "example"
},
"total": {
"amount": "example",
"currency": "example"
}
}
],
"fees": [
{
"name": "example",
"tax_rate": "example",
"tax": {
"amount": "example",
"currency": "example"
},
"total": {
"amount": "example",
"currency": "example"
}
}
],
"currency": "example",
"prices_include_tax": true,
"totals": {
"subtotal": {
"amount": "example",
"currency": "example"
},
"discount": {
"amount": "example",
"currency": "example"
},
"shipping": {
"amount": "example",
"currency": "example"
},
"tax": {
"amount": "example",
"currency": "example"
},
"total": {
"amount": "example",
"currency": "example"
}
},
"payment": {
"method": "example",
"status": "example",
"cod": {
"amount": "example",
"currency": "example"
}
},
"delivery": {
"method": "example",
"carrier": "example",
"pickup_point": {
"external_id": "example",
"provider": "example",
"name": "example",
"address": "example"
},
"service": {
"integration_id": "example",
"code": "example",
"selected_by": "example",
"selected_at": "2026-04-15T12:00:00Z"
}
},
"total_weight_kg": "example",
"placed_at": "2026-04-15T12:00:00Z",
"source_updated_at": "2026-04-15T12:00:00Z",
"created_at": "2026-04-15T12:00:00Z",
"updated_at": "2026-04-15T12:00:00Z"
}
],
"next_cursor": "example"
}
X-RateLimit-Limit
integer

Requests allowed per minute (per caller; before authentication, failed attempts per address).

X-RateLimit-Remaining
integer

Requests left in the current minute.

No valid access token.

Media typeapplication/problem+json
Problem
object
type
required

The documentation URL of the code.

string format: uri
title
required

A short summary of the error, in English.

string
status
required

The HTTP status, repeated.

integer
code
required

The stable code: one of bad_request, unauthenticated, insufficient_scope, forbidden, not_found, method_not_allowed, payload_too_large, validation_failed, idempotency_key_required, idempotency_key_invalid, idempotency_key_reused, idempotency_in_progress, conflict, rate_limited, server_error, unavailable, or the code an endpoint declares for a refused action.

string
detail

The explanation for this case, in English.

string
errors

Validation only: the messages per field.

object
key
additional properties
Array<string>

Example generated

{
"type": "https://example.com",
"title": "example",
"status": 1,
"code": "example",
"detail": "example",
"errors": {
"additionalProperty": [
"example"
]
}
}
X-RateLimit-Limit
integer

Requests allowed per minute (per caller; before authentication, failed attempts per address).

X-RateLimit-Remaining
integer

Requests left in the current minute.

WWW-Authenticate
string

Bearer: send an access token as a Bearer token.

The app was not granted the scope (insufficient_scope).

Media typeapplication/problem+json
Problem
object
type
required

The documentation URL of the code.

string format: uri
title
required

A short summary of the error, in English.

string
status
required

The HTTP status, repeated.

integer
code
required

The stable code: one of bad_request, unauthenticated, insufficient_scope, forbidden, not_found, method_not_allowed, payload_too_large, validation_failed, idempotency_key_required, idempotency_key_invalid, idempotency_key_reused, idempotency_in_progress, conflict, rate_limited, server_error, unavailable, or the code an endpoint declares for a refused action.

string
detail

The explanation for this case, in English.

string
errors

Validation only: the messages per field.

object
key
additional properties
Array<string>

Example generated

{
"type": "https://example.com",
"title": "example",
"status": 1,
"code": "example",
"detail": "example",
"errors": {
"additionalProperty": [
"example"
]
}
}
X-RateLimit-Limit
integer

Requests allowed per minute (per caller; before authentication, failed attempts per address).

X-RateLimit-Remaining
integer

Requests left in the current minute.

Validation failed (validation_failed, errors per field): an unknown filter, value or sort, a limit out of range, a malformed updated_since, or a cursor of another query.

Media typeapplication/problem+json
Problem
object
type
required

The documentation URL of the code.

string format: uri
title
required

A short summary of the error, in English.

string
status
required

The HTTP status, repeated.

integer
code
required

The stable code: one of bad_request, unauthenticated, insufficient_scope, forbidden, not_found, method_not_allowed, payload_too_large, validation_failed, idempotency_key_required, idempotency_key_invalid, idempotency_key_reused, idempotency_in_progress, conflict, rate_limited, server_error, unavailable, or the code an endpoint declares for a refused action.

string
detail

The explanation for this case, in English.

string
errors

Validation only: the messages per field.

object
key
additional properties
Array<string>

Example generated

{
"type": "https://example.com",
"title": "example",
"status": 1,
"code": "example",
"detail": "example",
"errors": {
"additionalProperty": [
"example"
]
}
}
X-RateLimit-Limit
integer

Requests allowed per minute (per caller; before authentication, failed attempts per address).

X-RateLimit-Remaining
integer

Requests left in the current minute.

Too many requests: retry after Retry-After seconds.

Media typeapplication/problem+json
Problem
object
type
required

The documentation URL of the code.

string format: uri
title
required

A short summary of the error, in English.

string
status
required

The HTTP status, repeated.

integer
code
required

The stable code: one of bad_request, unauthenticated, insufficient_scope, forbidden, not_found, method_not_allowed, payload_too_large, validation_failed, idempotency_key_required, idempotency_key_invalid, idempotency_key_reused, idempotency_in_progress, conflict, rate_limited, server_error, unavailable, or the code an endpoint declares for a refused action.

string
detail

The explanation for this case, in English.

string
errors

Validation only: the messages per field.

object
key
additional properties
Array<string>

Example generated

{
"type": "https://example.com",
"title": "example",
"status": 1,
"code": "example",
"detail": "example",
"errors": {
"additionalProperty": [
"example"
]
}
}
X-RateLimit-Limit
integer

Requests allowed per minute (per caller; before authentication, failed attempts per address).

X-RateLimit-Remaining
integer

Requests left in the current minute.

Retry-After
integer

Seconds to wait before retrying.