Get TripAdvisor rates into BigQuery.

One endpoint call, the BigQuery setup steps, and a field-to-column map. Then keep it refreshing on a schedule.

Start free with 50 requests

50 free requests on signup No credit card

Trusted by hospitality teams at

The pieces

One source, one destination.

TripAdvisor

TripAdvisor pairs bubble ratings and review text with multi-provider nightly prices, so one source covers both reputation and rate comparison. On this page those prices feed BigQuery, one row per date.

BigQuery

BigQuery wants rows, not API calls. A small scheduled job fetches the JSON, flattens the fields you care about, and appends them to a table, so history accumulates and SQL does the rest. Here it becomes the front end for live TripAdvisor rates.

The call

One endpoint returns TripAdvisor rates.

The TripAdvisor Hotel Prices endpoint returns clean JSON for one hotel. Send your key in the X-API-Key header. See the endpoint docs for every parameter.

GET TripAdvisor Hotel Prices /v1/tripadvisor/hotel/prices/{location_id} https://api.stayapi.com/v1/tripadvisor/hotel/prices/305165?check_in=2026-05-01&check_out=2026-05-03

Setup

Wire BigQuery to the endpoint.

01

Create a StayAPI account and copy your API key from the dashboard.
02

Create a dataset and table with the schema below.
03

Run the Python script below on a schedule (Cloud Run jobs and Cloud Scheduler work well).
04

Query the table or point your BI layer at it.

Config

Python: fetch and insert.

This uses the real endpoint URL with the example The Siam id. Swap in your hotel id and your API key.

load.py

import requests, psycopg2

URL = "https://api.stayapi.com/v1/tripadvisor/hotel/prices/305165?check_in=2026-05-01&check_out=2026-05-03"
HEADERS = {"X-API-Key": "YOUR_API_KEY"}

resp = requests.get(URL, headers=HEADERS, timeout=30)
resp.raise_for_status()
body = resp.json()
records = body.get("data", {}).get("reviews") or body.get("reviews") or body.get("rooms") or []

conn = psycopg2.connect(dsn="YOUR_CONNECTION_STRING")
cur = conn.cursor()
for r in records:
    cur.execute(
        "INSERT INTO stay_data (lowest_price, has_member_rates, provider, price_per_night) VALUES (%s, %s, %s, %s)",
        (r.get("lowest_price"), r.get("has_member_rates"), r.get("provider"), r.get("price_per_night")),
    )
conn.commit()
cur.close()
conn.close()