Get Ctrip rates into Looker Studio.

function refreshData() {
  var url = "https://api.stayapi.com/v1/ctrip/hotel/rooms/18078321";
  var response = UrlFetchApp.fetch(url, {
    method: "get",
    headers: { "X-API-Key": "YOUR_API_KEY" },
    muteHttpExceptions: true
  });

  var body = JSON.parse(response.getContentText());
  var records = (body.data && body.data.reviews) || body.reviews || body.rooms || [];

  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.clear();
  sheet.appendRow(["retrieved_at", "check_in", "check_out", "nights", "adults"]);

  var now = new Date();
  records.forEach(function (r) {
    sheet.appendRow([now, r.check_in, r.check_out, r.nights, r.adults]);
  });
}