# Review products

Units a review is about

Endpoint: `https://api.bookingmood.com/v1/review_products`, supporting `GET`, `POST`, `DELETE`, `PATCH`. Authenticate with the header `Authorization: Bearer YOUR_API_KEY` (see [authentication](https://www.bookingmood.com/it-IT/api-reference/authentication.md)).

## The review product object

| Attribute | Type | Description |
| --- | --- | --- |
| `id` | `uuid` |  |
| `product_id` | `uuid` | Identifier of the related unit. References [`products.id`](https://www.bookingmood.com/it-IT/api-reference/products.md). |
| `review_id` | `uuid` | Identifier of the related review. References [`reviews.id`](https://www.bookingmood.com/it-IT/api-reference/reviews.md). |
| `created_at` | `timestamp with time zone` | Creation timestamp. Read-only: set by the database. |

```json
{
  "id": "00000000-0000-0000-0000-000000000000",
  "product_id": "00000000-0000-0000-0000-000000000000",
  "review_id": "00000000-0000-0000-0000-000000000000",
  "created_at": "2026-10-30T23:31:32.587Z"
}
```

### Related resources

Embed related resources with the [`select` parameter](https://www.bookingmood.com/it-IT/api-reference/selecting.md), e.g. `select=*,products(*)`. Resources related through more than one column need the column as a hint, like `table!column(*)`.

| Embed | Type | Description |
| --- | --- | --- |
| `products(*)` | `object \| null` | The [product](https://www.bookingmood.com/it-IT/api-reference/products.md) referenced by `product_id`. |
| `reviews(*)` | `object \| null` | The [review](https://www.bookingmood.com/it-IT/api-reference/reviews.md) referenced by `review_id`. |

## List review products

`GET /v1/review_products`

Filter on any attribute with `column=operator.value` (see [filtering](https://www.bookingmood.com/it-IT/api-reference/filtering.md)). Choose columns and embed related resources with `select` (see [selecting](https://www.bookingmood.com/it-IT/api-reference/selecting.md)), and sort and paginate with `order`, `limit` and `offset` (see [sorting and pagination](https://www.bookingmood.com/it-IT/api-reference/sorting-pagination.md)).

```bash
curl -X GET "https://api.bookingmood.com/v1/review_products?select=*&limit=10" \
  -H "Authorization: Bearer YOUR_API_KEY"
```

Responses:

- `200`: A list of review products with the selected columns. `206` when the list is a partial range.
- `400`: The request is malformed, for example an unknown column or an invalid filter.
- `401`: The API key is missing or invalid.

## Create review products

`POST /v1/review_products`

Insert one review product or an array of review products. The body is a `Partial` review product object, so columns with a default can be left out. Read-only attributes can't be written.

```bash
curl -X POST "https://api.bookingmood.com/v1/review_products" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "product_id": "00000000-0000-0000-0000-000000000000",
    "review_id": "00000000-0000-0000-0000-000000000000"
  }'
```

Responses:

- `201`: The newly created review products with the selected columns.
- `400`: The request is malformed, for example an unknown column, an invalid filter or an invalid body.
- `401`: The API key is missing or invalid.
- `403`: The API key has no permission for this change, for example when writing rows of another organization.
- `409`: The change conflicts with existing data, for example a duplicate key or a reference to a row that does not exist.

## Delete review products

`DELETE /v1/review_products`

Filter on any attribute with `column=operator.value` (see [filtering](https://www.bookingmood.com/it-IT/api-reference/filtering.md)). Without filters, this request deletes all review products you have access to. Always filter on at least one column, e.g. `id=eq.{id}`.

```bash
curl -X DELETE "https://api.bookingmood.com/v1/review_products?id=eq.00000000-0000-0000-0000-000000000000" \
  -H "Authorization: Bearer YOUR_API_KEY"
```

Responses:

- `200`: The deleted review products with the selected columns. `204` without a body when sending the header `Prefer: return=minimal`.
- `400`: The request is malformed, for example an unknown column or an invalid filter.
- `401`: The API key is missing or invalid.
- `403`: The API key has no permission for this change, for example when writing rows of another organization.

## Update review products

`PATCH /v1/review_products`

Filter on any attribute with `column=operator.value` (see [filtering](https://www.bookingmood.com/it-IT/api-reference/filtering.md)). Without filters, this request updates all review products you have access to. Always filter on at least one column, e.g. `id=eq.{id}`. The body holds the attributes to change.

```bash
curl -X PATCH "https://api.bookingmood.com/v1/review_products?id=eq.00000000-0000-0000-0000-000000000000" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{}'
```

Responses:

- `200`: The updated review products with the selected columns. `204` without a body when sending the header `Prefer: return=minimal`.
- `400`: The request is malformed, for example an unknown column, an invalid filter or an invalid body.
- `401`: The API key is missing or invalid.
- `403`: The API key has no permission for this change, for example when writing rows of another organization.
- `409`: The change conflicts with existing data, for example a duplicate key or a reference to a row that does not exist.

Errors have a JSON body with a `code`, `message`, `details` and `hint`. See the [introduction](https://www.bookingmood.com/it-IT/api-reference.md) for more on errors. The full API is described by the OpenAPI spec at https://api.bookingmood.com/v1/openapi.json.