Endpoints

Order Items

Returns the individual line items that make up each order: which product, at what sale price, and how many.

GEThttps://xqqpbuhqvbbgyevwmktp.supabase.co/functions/v1/stylehub-order-items

Query parameters#

Parameter	Type	Required	Description
`created_from`	string (YYYY-MM-DD)	one of four*	Return rows whose created_at is on or after this date.
`created_to`	string (YYYY-MM-DD)	one of four*	Return rows whose created_at is on or before this date.
`updated_from`	string (YYYY-MM-DD)	one of four*	Return rows whose updated_at is on or after this date.
`updated_to`	string (YYYY-MM-DD)	one of four*	Return rows whose updated_at is on or before this date.
`order_id`	integer	optional	Positive integer. Return only the line items belonging to this order.
`page`	integer	optional	Zero-indexed page number. Default: `0`.
`page_size`	integer	optional	Rows per page. Maximum 1000. Default: `1000`.

* At least one date parameter is required — see Date filtering. Parameters combine with AND.

Example request#

Requires an API key sent as a Bearer token — see Authentication.

curl -s "https://xqqpbuhqvbbgyevwmktp.supabase.co/functions/v1/stylehub-order-items?updated_from=2026-10-01&order_id=18423" \
  -H "Authorization: Bearer stylehub_fsUPPpnCdz44Ld5fPQSfP0sTA3JaAjYn"

Example response#

JSON

{
  "data": [
    {
      "id": 51207,
      "order_id": 18423,
      "product_id": 10231,
      "sale_price": 49.99,
      "quantity": 1,
      "amount": 49.99,
      "created_at": "2026-03-14T09:12:44Z",
      "updated_at": "2026-03-14T09:12:44Z"
    },
    {
      "id": 51208,
      "order_id": 18423,
      "product_id": 10232,
      "sale_price": 17.49,
      "quantity": 2,
      "amount": 34.98,
      "created_at": "2026-03-14T09:12:44Z",
      "updated_at": "2026-03-14T09:12:44Z"
    }
  ],
  "meta": {
    "page": 0,
    "page_size": 1000,
    "count": 1234,
    "has_more": true
  }
}

Abbreviated: data holds up to page_size rows. See Response format and Errors.

Previous← Products NextShipments →