Ctrip BigQuery

Get Ctrip 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.

Ctrip Ctrip

Ctrip adds China-focused hotel inventory, Chinese-language guest reviews, and public advertised room pricing for portfolios that need stronger mainland coverage. Below, those nightly rates land in BigQuery as sortable rows.

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. In this guide it reads Ctrip rates straight from the StayAPI endpoint.

The call

One endpoint returns Ctrip rates.

The Ctrip Hotel Rooms and Lowest Price endpoint returns clean JSON for one hotel. Send your key in the X-API-Key header. See the endpoint docs for every parameter.

GET Ctrip Hotel Rooms and Lowest Price /v1/ctrip/hotel/rooms/{hotel_id} https://api.stayapi.com/v1/ctrip/hotel/rooms/18078321
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 杭州临平万丽酒店 id. Swap in your hotel id and your API key.

load.py 
import requests, psycopg2

URL = "https://api.stayapi.com/v1/ctrip/hotel/rooms/18078321"
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 (check_in, check_out, nights, adults) VALUES (%s, %s, %s, %s)",
        (r.get("check_in"), r.get("check_out"), r.get("nights"), r.get("adults")),
    )
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 Ctrip Hotel Rooms and Lowest Price response, and a suggested column name.

Response field Column
hotel_id hotel_id
check_in check_in
check_out check_out
nights nights
adults adults
children_ages children_ages
rooms_requested rooms_requested
currency currency
available available
lowest_price lowest_price
amount amount
basis basis
room_prices_included room_prices_included
room_price_limitation room_price_limitation
room_types room_types
price_visibility price_visibility
total_room_types total_room_types
total_rate_plans total_rate_plans
Result

What it looks like in BigQuery.

The fields from the mapping above land as columns: hotel_id, check_in, check_out, nights. Refreshed on the schedule you set.

The columns you get

Every row is one hotel record from the Ctrip Hotel Rooms and Lowest Price response. These fields become columns:

  • hotel_id
  • check_in
  • check_out
  • nights
  • adults
  • children_ages
Keep going

More Ctrip pipelines.

Other destinations
Ctrip rates to Google Sheets Ctrip rates to Looker Studio Ctrip rates to Power BI
More Ctrip pipelines
Ctrip reviews to Google Sheets Ctrip reviews to Looker Studio Ctrip reviews to Power BI Ctrip reviews to BigQuery
Build with the API
Ctrip Hotel Rooms and Lowest Price endpoint docs The full Ctrip API

Get your key.

Sign up, copy your key into the snippet above, and pull live Ctrip rates 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