Trip.com BigQuery

Get Trip.com reviews 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.

Trip.com Trip.com

Trip.com reviews skew toward Chinese and APAC travelers, a segment most Western OTAs underrepresent. This guide points those reviews at BigQuery, refreshed on your schedule.

BigQuery 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. Below you wire it to the Trip.com reviews endpoint in a few steps.

The call

One endpoint returns Trip.com reviews.

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

GET Trip.com Hotel Reviews /v1/tripcom/hotel/reviews/{hotel_id} https://api.stayapi.com/v1/tripcom/hotel/reviews/702258
Setup

Wire BigQuery to the endpoint.

  1. 01

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

  2. 02

    Create a dataset and table with the schema below.

  3. 03

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

  4. 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 hotel id. Swap in your hotel id and your API key.

load.py 
import requests, psycopg2

URL = "https://api.stayapi.com/v1/tripcom/hotel/reviews/702258"
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 (id, rating, title, text) VALUES (%s, %s, %s, %s)",
        (r.get("id"), r.get("rating"), r.get("title"), r.get("text")),
    )
conn.commit()
cur.close()
conn.close()
Grab your API key

50 free requests on signup, no card.

Field mapping

Response fields to columns.

Each field from the Trip.com Hotel Reviews response, and a suggested column name.

Response field Column
hotel_id hotel_id
total_reviews total_reviews
id id
rating rating
title title
text text
date date
stay_date stay_date
reviewer_name reviewer_name
room_type room_type
travel_type travel_type
Result

What it looks like in BigQuery.

The fields from the mapping above land as columns: hotel_id, total_reviews, id, rating. Refreshed on the schedule you set.

The columns you get

Every row is one hotel record from the Trip.com Hotel Reviews response. These fields become columns:

  • hotel_id
  • total_reviews
  • id
  • rating
  • title
  • text
BigQuery showing Trip.com reviews
Keep going

More Trip.com pipelines.

Other destinations
Trip.com reviews to Google Sheets Trip.com reviews to Looker Studio Trip.com reviews to Power BI
Build with the API
Trip.com Hotel Reviews endpoint docs The full Trip.com API

Get your key.

Sign up, copy your key into the snippet above, and pull live Trip.com reviews into BigQuery.

01 · the fast path

Try it free

50 free requests on signup. Fastest way to see if the schema fits.

Start free
  • Live API key in 30 seconds
  • No credit card required
  • Same schema as paid
02 · talk to us

Talk through your pipeline

15 minutes. Volume, endpoint mix, and where the data lands. Walk out with a quote.

Book a demo
  • Quote on the call, not after
  • Engineering, not sales
  • No deck, no slides