Fake store customers API

800 customers from the Store API, a fake e-commerce API. People who buy. Addresses are nested objects; filter on them with a dotted name (?address.country=AR).

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/customers
One record: https://api.sondahub.com/v1/store/customers/{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/customers.json
MCP: https://api.sondahub.com/mcp · list_records

The first three customers

curl "https://api.sondahub.com/v1/store/customers?limit=3"

Sample records

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

[
  {
    "id": 1,
    "created_at": "2025-11-07T01:41:24Z",
    "updated_at": "2025-11-07T01:41:24Z",
    "name": "Matteo Silva",
    "email": "[email protected]",
    "phone": "+1-504-344-6004",
    "company": "Bright Logistics Pty Ltd",
    "address": {
      "line1": "6322 Park Rd",
      "city": "Stockholm",
      "region": "Stockholm",
      "postal_code": "5VMCN0",
      "country": "SE"
    },
    "tier": "gold",
    "marketing_opt_in": true,
    "orders_count": 4,
    "total_spent": 5419.75,
    "notes": null
  },
  {
    "id": 2,
    "created_at": "2026-02-11T08:08:32Z",
    "updated_at": "2026-02-11T08:08:32Z",
    "name": "Facundo Romero",
    "email": "[email protected]",
    "phone": "+1-956-568-6686",
    "company": "Vertex Motors LLC",
    "address": {
      "line1": "1744 Elm Ave",
      "city": "Zurich",
      "region": "Zurich",
      "postal_code": "X4YESJ",
      "country": "CH"
    },
    "tier": "standard",
    "marketing_opt_in": false,
    "orders_count": 4,
    "total_spent": 11795.61,
    "notes": null
  },
  {
    "id": 3,
    "created_at": "2025-09-20T13:44:43Z",
    "updated_at": "2025-09-20T13:44:43Z",
    "name": "Yuki Muller",
    "email": "[email protected]",
    "phone": "+1-317-366-3558",
    "company": null,
    "address": {
      "line1": "8675 Washington Ln",
      "city": "Rome",
      "region": "Lazio",
      "postal_code": "75NJHW",
      "country": "IT"
    },
    "tier": "standard",
    "marketing_opt_in": false,
    "orders_count": 5,
    "total_spent": 3138.05,
    "notes": null
  }
]

Fields

Field	Type	Notes
`id`read-only	int	Assigned by the server. Seed records keep their ids across restarts; records you create continue after the seed.
`created_at`read-only	datetime	When the record was created (ISO 8601, UTC).
`updated_at`read-only	datetime	When the record last changed.
`name`required	string
`email`required	string
`phone`	string
`company`	string
`address`	json { line1, line2?, city, region, postal_code, country }
`tier`	enum	`standard` `silver` `gold` `platinum`
`marketing_opt_in`	bool
`orders_count`read-only	int
`total_spent`read-only	float
`notes`	text

Relations: orders → the orders whose customer_id is this customer; reviews → the reviews whose customer_id is this customer. Use ?expand=orders,reviews to embed them, or the nested routes.

Endpoints

GET/v1/store/customersA page, with every filter, sort, search, field and expand option.

POST/v1/store/customersCreate 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/customers/{id}One record, with an ETag; If-None-Match earns a 304.

PATCH/v1/store/customers/{id}Change the fields you send.

PUT/v1/store/customers/{id}Replace the record; required fields must all be there.

DELETE/v1/store/customers/{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/customers/{id}/ordersIts orders, as a page with all the list options.

GET/v1/store/customers/{id}/reviewsIts reviews, as a page with all the list options.

Try it

List with a filter

curl "https://api.sondahub.com/v1/store/customers?tier=silver&limit=3"

One record

curl https://api.sondahub.com/v1/store/customers/1

Its orders

curl "https://api.sondahub.com/v1/store/customers/1/orders?limit=5"

Create

curl -i -X POST https://api.sondahub.com/v1/store/customers \
  -H "Content-Type: application/json" \
  -d '{"name":"Camila Fernandez","email":"[email protected]","tier":"standard"}'

Read it back: newest first (send the session token)

curl "https://api.sondahub.com/v1/store/customers?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/customers/1 \
  -H "Content-Type: application/json" \
  -d '{"tier":"silver"}'

Delete the one you created

curl -X DELETE https://api.sondahub.com/v1/store/customers/801 \
  -H "X-Sondahub-Session: THE_TOKEN_FROM_THE_CREATE"

Query recipes

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

What	Request
Page 2, 50 at a time (of 800)	/v1/store/customers?page=2&limit=50
Only tier = standard	/v1/store/customers?tier=standard
Newest first by created at	/v1/store/customers?sort=-created_at&limit=5
Name contains “matteo”	/v1/store/customers?name_like=matteo
Full-text search	/v1/store/customers?q=matteo
Only some fields	/v1/store/customers?fields=id,name&limit=5
Its orders (nested route)	/v1/store/customers/1/orders?limit=5
Just the count	/v1/store/customers?limit=1&fields=id

GraphQL

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

{
  customers(limit: 3, sort: "-id", filter: { tier: standard }) {
    total
    data {
      id name email phone
      orders(limit: 2) { id }
    }
  }
}

Run it

curl https://api.sondahub.com/v1/store/graphql -H "Content-Type: application/json" -d '{"query": "{ customers(limit: 3, sort: \"-id\", filter: { tier: standard }) { total data { id name email phone orders(limit: 2) { id } } } }"}'

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/customers.

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":"customers","filters":{"tier":"standard"},"limit":3}}}'

More in the Store API

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

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.