sondahub

sondahub / Store API / Carts

Fake carts API

200 carts from the Store API, a fake e-commerce API. Open shopping carts; items are a nested array, so a cart is one document.

Reads with filters, sorting, search and relations; writes that answer like a real server and stay in your session token. Same ids on every build. Free, no key, CORS open.

Connect

List
https://api.sondahub.com/v1/store/carts
One record
https://api.sondahub.com/v1/store/carts/{id}
OpenAPI 3
https://api.sondahub.com/v1/store/openapi.json
GraphQL
https://api.sondahub.com/v1/store/graphql
JSON file
https://api.sondahub.com/data/store/carts.json
MCP
https://api.sondahub.com/mcp · list_records
The first three carts
curl "https://api.sondahub.com/v1/store/carts?limit=3"

Sample records

Records 1 to 3 of 200, exactly as GET /v1/store/carts/{id} answers them. The data file holds all of them.

[
  {
    "id": 1,
    "created_at": "2026-08-12T17:12:20Z",
    "updated_at": "2026-08-12T20:42:20Z",
    "customer_id": 694,
    "session_id": null,
    "status": "abandoned",
    "items": [
      {
        "product_id": 133,
        "sku": "OUT-PAQFTD",
        "name": "Trailhead Alpine Water Bottle Graphite",
        "quantity": 3,
        "unit_price": 254.58
      },
      {
        "product_id": 874,
        "sku": "HOM-5PGR2U",
        "name": "Tessel Cast-iron Kettle Graphite",
        "quantity": 2,
        "unit_price": 13.95
      }
    ],
    "item_count": 5,
    "subtotal": 791.64,
    "coupon": null,
    "last_activity_at": "2026-08-12T20:42:20Z"
  },
  {
    "id": 2,
    "created_at": "2026-08-27T03:37:17Z",
    "updated_at": "2026-08-27T05:06:17Z",
    "customer_id": null,
    "session_id": "sess_qozu5hlmylatfp4w",
    "status": "open",
    "items": [
      {
        "product_id": 483,
        "sku": "FIT-XYPT59",
        "name": "Motive Adjustable Kettlebell",
        "quantity": 1,
        "unit_price": 138.24
      },
      {
        "product_id": 80,
        "sku": "GAR-2G6TYM",
        "name": "Pebble Cordless Pruner",
        "quantity": 2,
        "unit_price": 368.27
      }
    ],
    "item_count": 3,
    "subtotal": 874.78,
    "coupon": null,
    "last_activity_at": "2026-08-27T05:06:17Z"
  },
  {
    "id": 3,
    "created_at": "2026-08-28T06:39:12Z",
    "updated_at": "2026-08-28T07:23:12Z",
    "customer_id": 495,
    "session_id": null,
    "status": "open",
    "items": [
      {
        "product_id": 1114,
        "sku": "COM-PNLV8B",
        "name": "Northlight Rugged Keyboard",
        "quantity": 1,
        "unit_price": 1730.42
      },
      {
        "product_id": 465,
        "sku": "OUT-9X3WNR",
        "name": "Basalt Waterproof Backpack Slate",
        "quantity": 1,
        "unit_price": 77.53
      },
      {
        "product_id": 1362,
        "sku": "FIT-927UGZ",
        "name": "Granite Resistance Jump Rope Navy",
        "quantity": 1,
        "unit_price": 630.88
      },
      {
        "product_id": 1009,
        "sku": "AUD-QDD8KS",
        "name": "Vantablack Reference Speaker",
        "quantity": 1,
        "unit_price": 442.23
      }
    ],
    "item_count": 4,
    "subtotal": 2881.06,
    "coupon": null,
    "last_activity_at": "2026-08-28T07:23:12Z"
  }
]

Fields

FieldTypeNotes
idread-onlyintAssigned by the server. Seed records keep their ids across restarts; records you create continue after the seed.
created_atread-onlydatetimeWhen the record was created (ISO 8601, UTC).
updated_atread-onlydatetimeWhen the record last changed.
customer_idint → customers
session_idstringFor anonymous carts.
statusenumopen abandoned converted
itemsjson { product_id, sku, name, quantity, unit_price }[]
item_countintmin 0
subtotalfloatmin 0
couponstring
last_activity_atdatetime

Relations: customer → one customer through customer_id. Use ?expand=customer to embed them, or the nested routes.

Endpoints

GET/v1/store/cartsA page, with every filter, sort, search, field and expand option.
POST/v1/store/cartsCreate one: 201 with the record, its id, a Location header and the session token that keeps it; 422 names each field that is wrong.
GET/v1/store/carts/{id}One record, with an ETag; If-None-Match earns a 304.
PATCH/v1/store/carts/{id}Change the fields you send.
PUT/v1/store/carts/{id}Replace the record; required fields must all be there.
DELETE/v1/store/carts/{id}Answers 200 with what was removed (a real server’s 204 lives at /v1/utils/status/204); gone for the session.
GET/v1/store/carts/{id}/customerThe customer this record points at.

Try it

List with a filter
curl "https://api.sondahub.com/v1/store/carts?status=abandoned&item_count_gte=1&expand=customer&limit=3"
One record
curl https://api.sondahub.com/v1/store/carts/1?expand=customer
Create
curl -i -X POST https://api.sondahub.com/v1/store/carts \
  -H "Content-Type: application/json" \
  -d '{"status":"open"}'
Read it back: newest first (send the session token)
curl "https://api.sondahub.com/v1/store/carts?sort=-id&limit=3" \
  -H "X-Sondahub-Session: THE_TOKEN_FROM_THE_CREATE"
Change one field
curl -X PATCH https://api.sondahub.com/v1/store/carts/1 \
  -H "Content-Type: application/json" \
  -d '{"status":"abandoned"}'
Delete the one you created
curl -X DELETE https://api.sondahub.com/v1/store/carts/201 \
  -H "X-Sondahub-Session: THE_TOKEN_FROM_THE_CREATE"

Query recipes

Every list option works on carts; these are ready to paste. All the options.

WhatRequest
Page 2, 50 at a time (of 200)/v1/store/carts?page=2&limit=50
Only status = open/v1/store/carts?status=open
Item count between two values, largest first/v1/store/carts?item_count_gte=1&item_count_lte=500&sort=-item_count
Newest first by created at/v1/store/carts?sort=-created_at&limit=5
Session id contains “a”/v1/store/carts?session_id_like=a
Full-text search/v1/store/carts?q=a
Only some fields/v1/store/carts?fields=id,session_id&limit=5
Embed the customer/v1/store/carts/1?expand=customer
Just the count/v1/store/carts?limit=1&fields=id

GraphQL

The same carts as the carts query on https://api.sondahub.com/v1/store/graphql, and one cart as cart(id: 1). Introspection is on. More on the GraphQL API.

{
  carts(limit: 3, sort: "-id", filter: { status: open }) {
    total
    data {
      id customer_id session_id status
      customer { name }
    }
  }
}
Run it
curl https://api.sondahub.com/v1/store/graphql -H "Content-Type: application/json" -d '{"query": "{ carts(limit: 3, sort: \"-id\", filter: { status: open }) { total data { id customer_id session_id status customer { name } } } }"}'

From an AI agent (MCP)

The MCP server reaches the same rows with list_records, get_record, create_record, update_record and delete_record, and as the resource sondahub://store/carts.

tools/call
curl https://api.sondahub.com/mcp \
  -H "Content-Type: application/json" \
  -H "Accept: application/json, text/event-stream" \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"list_records","arguments":{"api":"store","collection":"carts","filters":{"status":"open"},"limit":3}}}'

More in the Store API

categories (8) · products (2,000) · customers (800) · orders (3,000) · order items (6,219) · reviews (2,500) · warehouses (3) · inventory (6,000)

The live streams, and the whole API on one page: Store API. Other worlds: fake IoT API, fake banking API, fake social media API, fake helpdesk API, fake flight booking API, fake user directory API.