sondahub

sondahub / Store API / Reviews

Fake reviews API

2,500 reviews from the Store API, a fake e-commerce API. Customer reviews, 1–5 stars.

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/reviews
One record
https://api.sondahub.com/v1/store/reviews/{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/reviews.json
MCP
https://api.sondahub.com/mcp · list_records
The first three reviews
curl "https://api.sondahub.com/v1/store/reviews?limit=3"

Sample records

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

[
  {
    "id": 1,
    "created_at": "2026-01-11T12:48:43Z",
    "updated_at": "2026-01-11T12:48:43Z",
    "product_id": 1771,
    "customer_id": 308,
    "rating": 5,
    "title": "Solid, no complaints",
    "body": "Customer support answered within a day when I had a question. Setup took five minutes and it has worked every day since. Heavier than I expected, which is actually a good sign here.",
    "verified_purchase": true,
    "helpful_votes": 0
  },
  {
    "id": 2,
    "created_at": "2025-12-03T16:54:22Z",
    "updated_at": "2025-12-03T16:54:22Z",
    "product_id": 927,
    "customer_id": 368,
    "rating": 5,
    "title": "Solid, no complaints",
    "body": "The build quality is noticeably better than the last one I owned. Worth the price, though not by a wide margin. The instructions were unclear but the product itself is fine.",
    "verified_purchase": true,
    "helpful_votes": 0
  },
  {
    "id": 3,
    "created_at": "2026-06-17T14:11:20Z",
    "updated_at": "2026-06-17T14:11:20Z",
    "product_id": 1854,
    "customer_id": 441,
    "rating": 2,
    "title": "Great value",
    "body": "Customer support answered within a day when I had a question. Battery life matches the listing, which is rare.",
    "verified_purchase": true,
    "helpful_votes": 0
  }
]

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.
product_idrequiredint → products
customer_idrequiredint → customers
ratingrequiredintmin 1, max 5
titlestring
bodytext
verified_purchasebool
helpful_votesintmin 0

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

Endpoints

POST recomputes the product’s rating and review_count — in the answer’s world, which ends with the answer.
GET/v1/store/reviewsA page, with every filter, sort, search, field and expand option.
POST/v1/store/reviewsCreate 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/reviews/{id}One record, with an ETag; If-None-Match earns a 304.
PATCH/v1/store/reviews/{id}Change the fields you send.
PUT/v1/store/reviews/{id}Replace the record; required fields must all be there.
DELETE/v1/store/reviews/{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/reviews/{id}/productThe product this record points at.
GET/v1/store/reviews/{id}/customerThe customer this record points at.

Try it

List with a filter
curl "https://api.sondahub.com/v1/store/reviews?rating_gte=1&expand=product&limit=3"
One record
curl https://api.sondahub.com/v1/store/reviews/1?expand=product
Create
curl -i -X POST https://api.sondahub.com/v1/store/reviews \
  -H "Content-Type: application/json" \
  -d '{"product_id":1,"customer_id":1,"rating":1}'
Read it back: newest first (send the session token)
curl "https://api.sondahub.com/v1/store/reviews?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/reviews/1 \
  -H "Content-Type: application/json" \
  -d '{"rating":2}'
Delete the one you created
curl -X DELETE https://api.sondahub.com/v1/store/reviews/2501 \
  -H "X-Sondahub-Session: THE_TOKEN_FROM_THE_CREATE"

Query recipes

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

WhatRequest
Page 2, 50 at a time (of 2,500)/v1/store/reviews?page=2&limit=50
Rating between two values, largest first/v1/store/reviews?rating_gte=1&rating_lte=500&sort=-rating
Newest first by created at/v1/store/reviews?sort=-created_at&limit=5
Title contains “solid,”/v1/store/reviews?title_like=solid%2C
Full-text search/v1/store/reviews?q=solid%2C
Only some fields/v1/store/reviews?fields=id,title&limit=5
Embed the product/v1/store/reviews/1?expand=product
Just the count/v1/store/reviews?limit=1&fields=id

GraphQL

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

{
  reviews(limit: 3, sort: "-id") {
    total
    data {
      id product_id customer_id rating
      product { sku }
    }
  }
}
Run it
curl https://api.sondahub.com/v1/store/graphql -H "Content-Type: application/json" -d '{"query": "{ reviews(limit: 3, sort: \"-id\") { total data { id product_id customer_id rating product { sku } } } }"}'

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

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":"reviews","limit":3}}}'

More in the Store API

categories (8) · products (2,000) · customers (800) · orders (3,000) · order items (6,219) · 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.