# Retrieve hotel reviews’ dump

URL: https://docs.emergingtravel.com/docs/b2b-api/static-content/retrieve-hotel-reviews-dump/

Tags: b2b

---



**Sandbox**

```
https://api-sandbox.worldota.net/api/b2b/v3/hotel/reviews/dump/
```

**Production**

```
https://api.worldota.net/api/b2b/v3/hotel/reviews/dump/
```




The call gets the [dump](/docs/glossary/#dump) with the hotels reviews of the ETG clients.

> [!NOTE]
> The dump should be updated every week.



The ETG generates <strong>each archive for a single language</strong>.

> [!WARNING]
> * The dump download link you receive from the API is temporary and will expire **1 hour after being issued**. To download the dump, you must call the API method each time to obtain a fresh, valid link.
> * The ETG can’t share the TripAdvisor reviews via the API.
> * <strong>Reviews indexing isn’t allowed.</strong>



## Sandbox limitations { #limitations }

> [!WARNING]
> Use only field values, IDs, API keys, and any static content from the sandbox environment within the sandbox. <strong>Do not use sandbox data in test or production environments, and do not mix data or configuration between different environments.</strong>




* The value of the `language` field is always set to `en`.
* The maximum number of items in the dump is `1000`.
* For all objects containing the `currency_code` field, its value is always `EUR`.

## Request example


**Sandbox**

```shell
curl --user '<KEY_ID>:<API_KEY>' 'https://api-sandbox.worldota.net/api/b2b/v3/hotel/reviews/dump/' \
--header 'Content-Type: application/json' \
--data '{
  "language": "en"
}'
```

**Production**

```shell
curl --user '<KEY_ID>:<API_KEY>' 'https://api.worldota.net/api/b2b/v3/hotel/reviews/dump/' \
--header 'Content-Type: application/json' \
--data '{
  "language": "en"
}'
```




## Request body



- **language** *(String, required)*

  <p>The language.</p>
  > [!NOTE]
  > The possible values:
  > * `ar` — Arabic.
  > * `bg` — Bulgarian.
  > * `cs` — Czech.
  > * `da` — Danish.
  > * `de` — German.
  > * `el` — Greek.
  > * `en` — English.
  > * `es` — Spanish.
  > * `fi` — Finnish.
  > * `fr` — French.
  > * `he` — Hebrew.
  > * `hu` — Hungarian.
  > * `it` — Italian.
  > * `ja` — Japanese.
  > * `kk` — Kazakh.
  > * `ko` — Korean.
  > * `nl` — Dutch.
  > * `no` — Norwegian Bokmål.
  > * `pl` — Polish.
  > * `pt` — Portuguese.
  > * `pt_PT` — European Portuguese.
  > * `ro` — Romanian.
  > * `ru` — Russian.
  > * `sq` — Albanian.
  > * `sr` — Serbian.
  > * `sv` — Swedish.
  > * `th` — Thai.
  > * `tr` — Turkish.
  > * `uk` — Ukrainian.
  > * `vi` — Vietnamese.
  > * `zh_CN` — Simplified Chinese.
  > * `zh_TW` — Traditional Chinese.





## Response



- **url** *(String)*

  <p>A direct link to download the dump file.</p>


- **last_update** *(DateTime)*

  <p>The date and time when this dump was last updated (in UTC, [ISO 8601 format](https://www.iso.org/iso-8601-date-and-time-format.html)
  
  ).</p>





## Response example

```json
{
  "data": {
    "last_update": "2020-07-01T00:38:13Z",
    "url": "https://.../partner_feed_v3_en.jsonl.zst?..." // link valid for 1 hour
  },
  "debug": null,
  "error": null,
  "status": "ok"
}
```

## Dump file structure

The dump is a [GZIP](https://www.gzip.org/) archive that contains a file with hotel IDs and objects with theirs reviews.

```json
{
  "corendon_vitality_hotel_amsterdam": {
    "rating": 9,
    "detailed_ratings": {
      "cleanness": 8.6,
      "location": 7.9,
      "price": 8.6,
      "services": 8.4,
      "room": 9.5,
      "meal": 10,
      "wifi": 10,
      "hygiene": null
    },
    "reviews": [
      {
        "review_plus": "It is near the metro m51 which is good for reaching any place of city. Breakfast is really good. Clean confortable and with great view",
        "review_minus": "Nothing all good",
        "created": "2022-05-17",
        "author": "Alban",
        "adults": 2,
        "children": 0,
        "room_name": "Standard Double room (full double bed) (bed type is subject to availability)",
        "nights": 2,
        "images": [],
        "detailed": {
          "cleanness": 10,
          "location": 10,
          "price": 8,
          "services": 10,
          "room": 10,
          "meal": 10,
          "wifi": "perfect",
          "hygiene": "unspecified"
        },
        "traveller_type": "couple",
        "trip_type": "leisure",
        "rating": 9
      }
    ]
  }
}
```

### Field details

The entire dump structure is described in the response of the [Retrieve hotels review by IDs](/docs/content-api/retrieve-hotels-review-by-ids/#review) call.

## Errors

The `error` field has the value specified in the headers below.

### `dump_not_ready`

The dump is in processing. Try to send the request later.