Waitrose API Capability

Product reviews

List public product reviews with verified offset paging, rating filter and sort.

Capability ID waitrose.product.reviews.list

Cost From $2.50 per 1,000 requests · 2 credits

Maximum runtime 45 seconds

# Product reviews

List public product reviews with verified offset paging, rating filter and sort.

- Platform: [Waitrose](https://docs.upscrape.com/docs/platforms/waitrose)
- Capability ID: `waitrose.product.reviews.list`
- Cost: 2 credits per request
- Maximum runtime: 45 seconds
- Execute endpoint: `POST https://data.upscrape.com/execute`

## Request

Use the exact public capability ID in the shared execute envelope.

```bash
curl --request POST \
  --url https://data.upscrape.com/execute \
  --header "Authorization: Bearer $UPSCRAPE_API_KEY" \
  --header "Content-Type: application/json" \
  --header "Prefer: wait=30" \
  --data '{
  "input": {
    "limit": 1,
    "offset": 0,
    "product_id": "053457-26759-26760",
    "sort": "recent"
  },
  "capability": "waitrose.product.reviews.list"
}'
```

## Input

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| `limit` | `integer` | No | Maximum number of results to return. From 1 to 50. |
| `offset` | `integer` | No | Zero-based number of results to skip. From 0 to 5000. |
| `product_id` | `string` | No | Product identifier. |
| `rating` | `integer` | No | From 1 to 5. |
| `sort` | `string` | No | Sort order for returned results. Allowed values: `recent`, `oldest`, `highest`, `lowest`, `helpful`. |
| `url` | `string` | No | Public URL of the page to fetch. |

### Example input

```json
{
  "limit": 1,
  "offset": 0,
  "product_id": "053457-26759-26760",
  "sort": "recent"
}
```

## Response

Successful output is returned in `results[0].data`. Raw platform output is intentionally open-ended and may evolve with the upstream source.

### Illustrative sample output

This redacted fixture is an example, not a fixed response schema.

```json
{
  "next_offset": 1,
  "offset": 0,
  "product_id": "053457-26759-26760",
  "rating_average": 4.655251141552512,
  "rating_count": 876,
  "rating_histogram": [
    {
      "count": 692,
      "rating": 5
    },
    {
      "count": 118,
      "rating": 4
    },
    {
      "count": 36,
      "rating": 3
    }
  ],
  "returned": 1,
  "review_count": 740,
  "reviews": [
    {
      "helpful_votes": 0,
      "id": "example-review",
      "rating": 5,
      "submitted_at": "2026-10-04T13:33:51.000+00:00",
      "text": "Example public review text",
      "title": "Example review"
    }
  ]
}
```
### Illustrative output fields

Derived from the sample above for orientation only. These fields are not a fixed response schema.

| Path | Observed type | Example |
| --- | --- | --- |
| `next_offset` | `integer` | 1 |
| `offset` | `integer` | 0 |
| `product_id` | `string` | 053457-26759-26760 |
| `rating_average` | `number` | 4.655251141552512 |
| `rating_count` | `integer` | 876 |
| `rating_histogram` | `array` | 3 items |
| `rating_histogram` | `array` | 3 items |
| `returned` | `integer` | 1 |
| `review_count` | `integer` | 740 |
| `reviews` | `array` | 1 items |
| `reviews` | `array` | 1 items |

## Execution behavior

A `200` response completed inline. A `202` response was queued; poll `GET /jobs/{id}` until the job reaches `completed` or `failed`. Use an `Idempotency-Key` when retrying must not create a duplicate logical job.

## Related documentation

- [Authentication](https://docs.upscrape.com/docs/api/authentication)
- [Jobs and results](https://docs.upscrape.com/docs/api/jobs)
- [Errors and retries](https://docs.upscrape.com/docs/api/errors)
- [Idempotency](https://docs.upscrape.com/docs/api/idempotency)

POST /execute Shared execution endpoint

Input parameters

limit integer optional

Maximum number of results to return. From 1 to 50.

Example 1

offset integer optional

Zero-based number of results to skip. From 0 to 5000.

Example 0

product_id string optional

Product identifier.

Example 053457-26759-26760

rating integer optional

From 1 to 5.

sort string optional

Sort order for returned results. Allowed values: `recent`, `oldest`, `highest`, `lowest`, `helpful`.

Example recent

Available values recentoldesthighestlowesthelpful

url string optional

Public URL of the page to fetch.

Response

Successful output is returned in results[0].data. Raw platform output is intentionally open-ended and may evolve with the upstream source.

Illustrative sample The full redacted fixture is shown in the response panel.

Illustrative output fields

Derived from the sample above for orientation only. These observed fields are not a fixed response schema.

Path	Observed type	Example
`next_offset`	`integer`	1
`offset`	`integer`	0
`product_id`	`string`	053457-26759-26760
`rating_average`	`number`	4.655251141552512
`rating_count`	`integer`	876
`rating_histogram`	`array`	3 items
`rating_histogram`	`array`	3 items
`returned`	`integer`	1
`review_count`	`integer`	740
`reviews`	`array`	1 items
`reviews`	`array`	1 items

Execution behavior

A 200 response completed inline. A 202 response was queued; poll GET /jobs/:id until the job reaches completed or failed.

curl --request POST \ --url https://data.upscrape.com/execute \ --header "Authorization: Bearer $UPSCRAPE_API_KEY" \ --header "Content-Type: application/json" \ --header "Prefer: wait=30" \ --data '{ "input": { "limit": 1, "offset": 0, "product_id": "053457-26759-26760", "sort": "recent" }, "capability": "waitrose.product.reviews.list" }'

import json import os import requests payload = json.loads(r'''{ "input": { "limit": 1, "offset": 0, "product_id": "053457-26759-26760", "sort": "recent" }, "capability": "waitrose.product.reviews.list" }''') response = requests.post( "https://data.upscrape.com/execute", headers={ "Authorization": f"Bearer {os.environ['UPSCRAPE_API_KEY']}", "Content-Type": "application/json", "Prefer": "wait=30", }, json=payload, ) response.raise_for_status() print(json.dumps(response.json(), indent=2))

{ "next_offset": 1, "offset": 0, "product_id": "053457-26759-26760", "rating_average": 4.655251141552512, "rating_count": 876, "rating_histogram": [ { "count": 692, "rating": 5 }, { "count": 118, "rating": 4 }, { "count": 36, "rating": 3 } ], "returned": 1, "review_count": 740, "reviews": [ { "helpful_votes": 0, "id": "example-review", "rating": 5, "submitted_at": "2026-10-04T13:33:51.000+00:00", "text": "Example public review text", "title": "Example review" } ] }