Endpoints

Orders

Returns orders placed on StyleHub. Each row is the latest state of an order, including its current status and total.

GEThttps://xqqpbuhqvbbgyevwmktp.supabase.co/functions/v1/stylehub-orders

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.
`status`	string (enum)	optional	Filter by order status. One of Cancelled, Complete, Processing, Returned, Shipped.
`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-orders?created_from=2026-10-01&status=Shipped" \
  -H "Authorization: Bearer stylehub_fsUPPpnCdz44Ld5fPQSfP0sTA3JaAjYn"

Example response#

JSON

{
  "data": [
    {
      "id": 18423,
      "user_id": 2291,
      "status": "Shipped",
      "total_amount": 84.97,
      "created_at": "2026-03-14T09:12:44Z",
      "updated_at": "2026-03-16T15:03:10Z"
    },
    {
      "id": 18424,
      "user_id": 507,
      "status": "Processing",
      "total_amount": 129.5,
      "created_at": "2026-03-14T09:20:03Z",
      "updated_at": "2026-03-14T09:20:03Z"
    }
  ],
  "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← Response format NextUsers →