Skip to content
docs
Guides
ES
OrdersOrders
order:read

Get order spreadsheet

GET/v1/orders/spreadsheet/{id}

Get order spreadsheet. A successful request returns HTTP 200 with the documented response body.

Authorization

bearerAuth
AuthorizationBearer <token>

OAuth2 access token issued by Ecomiq Auth.

In: header

Path Parameters

id*string

Unique identifier of the resource.

Query Parameters

limit?integer

Maximum number of results to return.

Formatint32
cursor?string

Opaque cursor from the previous response. Omit it on the first page.

search?string

Free-text filter. Which fields it covers depends on the resource.

sortBy?string

Field to sort by. Accepted values depend on the resource.

sortDirection?string

Sort direction: asc or desc.

Value in

  • "asc"
  • "desc"

Header Parameters

x-Store-Id?string

Store the request acts on. Not needed when the token is bound to a store.

Authorization*string

OAuth 2.0 bearer token.

Response Body

application/json

application/problem+json

application/problem+json

application/problem+json

application/problem+json

application/problem+json

curl -X GET "https://example.com/v1/orders/spreadsheet/7204558912004325301" \  -H "x-Store-Id: <store-id>" \  -H "Authorization: Bearer <token>"
{  "data": [    {      "id": "7204558912004325301",      "orderId": "7204558912004325301",      "storeId": "7204558912004325301",      "customerId": "7204558912004325301",      "orderNumber": "ORD-2026-0001",      "orderShortId": "7204558912004325301",      "orderGroup": "example",      "source": "example",      "email": "andrea@example.com",      "phone": "+51987654321",      "firstName": "Andrea",      "lastName": "Ramos",      "entityName": "Comercial Lima SAC",      "orderStatus": "new",      "state": "open",      "fulfillmentStatus": "unfulfilled",      "returnStatus": "none",      "orderDate": "2026-08-01T15:30:00Z",      "currencyCode": "PEN",      "productId": "7204558912004325301",      "variantId": "7204558912004325301",      "skuId": "7204558912004325301",      "sku": "SKU-001",      "title": "Example title",      "subtitle": "Example title",      "thumbnail": "example",      "variantTitle": "Example title",      "brand": "example",      "category": "example",      "quantity": 1,      "quantityToDispatch": 1,      "quantityDispatched": 1,      "quantityDelivered": 1,      "quantityReturned": 1,      "total": 1,      "invoiceNumber": "example",      "invoiceLink": "example",      "trackingNumber": "example",      "trackingLink": "example",      "itemStatus": "new",      "createdOn": "2026-08-01T15:30:00Z",      "updatedOn": "2026-08-01T15:30:00Z"    }  ],  "hasNextPage": false,  "nextCursor": "example",  "totalCount": 1}