Skip to content
Scrappa Get API key
OpenTable API 1 credit/request

OpenTable Restaurant Reviews API Documentation

GET https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2

Retrieve public OpenTable reviews for a restaurant by id or profile URL, up to 100 per page. Each review has the text, overall, food, service, ambience and value ratings, a noise level, the diner nickname, review count and VIP status, helpfulness votes, the owner reply with content and date, the dined and submitted dates and photos. The response also carries the ratings summary with the star distribution and the page count. Sort by newest, highest or lowest and search the review text. A page beyond the last page returns 422. Costs 1 credit.

OpenTable Restaurant Reviews API Documentation 1 credit/request

Endpoint

Request preview
GET
https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2
Auth header
x-api-key
Cost
1 credit/request
Response preview
200 OK
{
    "success": true,
    "data": {
        "restaurant": {
            "id": 489,
            "name": "Mon Ami Gabi",
            "url": "https://www.opentable.com/restaurant/profile/489"
        },
        "ratings_summary": {
            "overall": 4.8,
            "count": 763,
            "food": 4.8,
            "service": 4.7,
            "ambience": 4.8,
...

Parameters

Start with the required fields, then add optional filters only when your use case needs them.

Runnable path

This endpoint has no required query parameters.

7 optional filters available.

restaurant_id integer Optional

Numeric OpenTable restaurant id from the search endpoint, e.g. 489. Send this or url.

Example value 489
url string Optional
Open example

OpenTable profile URL containing /restaurant/profile/. Send this or restaurant_id.

Example value https://example.com/product
country string Optional

OpenTable site of the restaurant: us (default), gb, ca, de, au or ie. A url sets it automatically.

Example value us
sort string Optional

newest (default), highest or lowest.

Example value newest
page integer Optional

1-based page number. A page after the last page returns 422.

Example value 1
per_page integer Optional

Reviews per page, 1 to 100.

Example value 2
query string Optional

Only return reviews that contain this text.

Example value coffee shops

Request Examples

PHP
<?php

$curl = curl_init();

curl_setopt_array($curl, [
    CURLOPT_URL => "https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2",
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_ENCODING => "",
    CURLOPT_MAXREDIRS => 10,
    CURLOPT_TIMEOUT => 30,
    CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
    CURLOPT_CUSTOMREQUEST => "GET",
    CURLOPT_HTTPHEADER => [
        "x-api-key: YOUR_API_KEY_HERE"
    ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
    echo "cURL Error #:" . $err;
} else {
    echo $response;
}
PHP
<?php

use Illuminate\Support\Facades\Http;

$response = Http::timeout(30)
    ->withHeaders(['x-api-key' => 'YOUR_API_KEY_HERE'])
    ->get('https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2');

if ($response->successful()) {
    echo $response->body();
} else {
    echo "Error: " . $response->status();
}
JavaScript
const options = {
    method: 'GET',
    headers: {
        'x-api-key': 'YOUR_API_KEY_HERE'
    }
};

fetch('https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2', options)
    .then(response => {
        if (!response.ok) {
            throw new Error(`HTTP error! status: ${response.status}`);
        }
        return response.text();
    })
    .then(data => console.log(data))
    .catch(error => console.error('Error:', error));
JavaScript
const axios = require('axios');

const options = {
    method: 'GET',
    url: 'https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2',
    headers: {
        x-api-key: 'YOUR_API_KEY_HERE',
    }
};

try {
    const response = await axios(options);
    console.log(response.data);
} catch (error) {
    console.error('Error:', error.message);
}
Ruby
require 'net/http'
require 'uri'

uri = URI.parse("https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2")
http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = uri.scheme == 'https'

request = Net::HTTP::Get.new(uri.request_uri)
request['x-api-key'] = 'YOUR_API_KEY_HERE'

begin
    response = http.request(request)
    puts response.body
rescue => e
    puts "Error: #{e.message}"
end
Python
import http.client
import json

conn = http.client.HTTPSConnection("scrappa.co")

headers = {
    'x-api-key': 'YOUR_API_KEY_HERE',
}

try:
    conn.request("GET", "/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2", headers=headers)
    res = conn.getresponse()
    data = res.read()
    print(data.decode("utf-8"))
except Exception as e:
    print(f"Error: {e}")
finally:
    conn.close()
Python
import requests

headers = {
    'x-api-key': 'YOUR_API_KEY_HERE',
}

try:
    response = requests.get('https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2', headers=headers)
    response.raise_for_status()
    print(response.text)
except requests.exceptions.RequestException as e:
    print(f"Error: {e}")
Java
import okhttp3.OkHttpClient;
import okhttp3.Request;
import okhttp3.Response;
import java.io.IOException;

public class ApiExample {
    public static void main(String[] args) {
        OkHttpClient client = new OkHttpClient();

        Request request = new Request.Builder()
            .url("https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2")
        .addHeader("x-api-key", "YOUR_API_KEY_HERE")
            .build();

        try (Response response = client.newCall(request).execute()) {
            if (response.isSuccessful()) {
                System.out.println(response.body().string());
            } else {
                System.out.println("Error: " + response.code());
            }
        } catch (IOException e) {
            System.out.println("Error: " + e.getMessage());
        }
    }
}
Go
package main

import (
    "fmt"
    "net/http"
    "io/ioutil"
)

func main() {
    client := &http.Client{}
    req, err := http.NewRequest("GET", "https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2", nil)
    if err != nil {
        fmt.Println("Error creating request:", err)
        return
    }
    req.Header.Set("x-api-key", "YOUR_API_KEY_HERE")

    resp, err := client.Do(req)
    if err != nil {
        fmt.Println("Error making request:", err)
        return
    }
    defer resp.Body.Close()

    body, err := ioutil.ReadAll(resp.Body)
    if err != nil {
        fmt.Println("Error reading response:", err)
        return
    }

    fmt.Println(string(body))
}
Terminal
#!/bin/bash

curl -X GET \
    -H "x-api-key: YOUR_API_KEY_HERE" \
    "https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2"
C#
using System;
using System.Net.Http;
using System.Threading.Tasks;

class Program
{
    static async Task Main()
    {
        using var client = new HttpClient();
        client.DefaultRequestHeaders.Add("x-api-key", "YOUR_API_KEY_HERE");

        try
        {
            var response = await client.SendAsync(new HttpRequestMessage(HttpMethod.Get, "https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2"));
            var content = await response.Content.ReadAsStringAsync();
            Console.WriteLine(content);
        }
        catch (Exception ex)
        {
            Console.WriteLine($"Error: {ex.Message}");
        }
    }
}
TypeScript
import axios from 'axios';

async function run(): Promise<void> {
    try {
        const response = await axios({
            method: 'GET',
            url: 'https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2',
            headers: {
        'x-api-key': 'YOUR_API_KEY_HERE',
            },
        });

        console.log(response.data);
    } catch (error) {
        console.error('Error:', error);
    }
}

void run();
RUST
use reqwest::Client;

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let client = Client::new();

    let response = client
        .get("https://scrappa.co/api/opentable/reviews?restaurant_id=489&sort=newest&per_page=2")
        .header("x-api-key", "YOUR_API_KEY_HERE")
        .send()
        .await?;

    println!("{}", response.text().await?);

    Ok(())
}

Response Schema

Example response fields are illustrative; inspect the JSON before integrating.

Example response fields

Scan these fields before integrating.

success data meta
JSON Response
200 OK
{
    "success": true,
    "data": {
        "restaurant": {
            "id": 489,
            "name": "Mon Ami Gabi",
            "url": "https://www.opentable.com/restaurant/profile/489"
        },
        "ratings_summary": {
            "overall": 4.8,
            "count": 763,
            "food": 4.8,
            "service": 4.7,
            "ambience": 4.8,
            "value": 4.5,
            "noise": 2,
            "ratings": [
                {
                    "stars": 1,
                    "count": 5
                },
                {
                    "stars": 2,
                    "count": 7
                },
                {
                    "stars": 3,
                    "count": 18
                },
                {
                    "stars": 4,
                    "count": 58
                },
                {
                    "stars": 5,
                    "count": 675
                }
            ]
        },
        "sort": "newest",
        "reviews": [
            {
                "id": "OT-489-2110613123-110016704381",
                "text": "This is one of my favorite spots for a special occasion dinner.",
                "ratings": {
                    "overall": 3,
                    "food": 5,
                    "service": 1,
                    "ambience": 5,
                    "value": 4,
                    "noise": "energetic"
                },
                "user": {
                    "nickname": "Jacqueline",
                    "initials": "J",
                    "review_count": 25,
                    "is_vip": true,
                    "location": "Chicago"
                },
                "helpfulness": {
                    "up": 0,
                    "down": 0,
                    "score": 0
                },
                "response": {
                    "content": "Dear Jacqueline, I am so sorry to hear of your recent experience.",
                    "date": "2026-11-03T16:34:46Z"
                },
                "submitted_at": "2026-11-02T19:44:14Z",
                "dined_at": "2026-11-01T18:15:00-06:00",
                "verified": true
            }
        ],
        "pagination": {
            "page": 1,
            "per_page": 2,
            "total_pages": 4533,
            "total_count": 9066,
            "has_more": true
        }
    },
    "meta": {
        "endpoint_family": "reviews",
        "billable": true
    }
}

Errors

Handle these documented responses before retrying or showing customer-facing failures.

422

Validation Error

A required query parameter is missing or invalid. This response is not billable.

{
    "errors": {
        "restaurant_id": [
            "A restaurant_id or a restaurant profile url is required."
        ]
    },
    "message": "The request validation failed"
}
404

Not Found

The requested OpenTable restaurant was not found. This response is not billable.

{
    "error": {
        "code": "NOT_FOUND",
        "message": "The requested OpenTable restaurant was not found."
    },
    "success": false
}
422

Page Out Of Range

The page is after the last page of reviews. Use the total_pages value of an earlier response. This response is not billable.

{
    "error": {
        "code": "PAGE_OUT_OF_RANGE",
        "message": "The requested page is beyond the last page of reviews. Use a smaller page number."
    },
    "success": false
}
502

Invalid Source Response

The upstream answered with a shape that no longer matches the documented contract. This response is not billable.

{
    "error": {
        "code": "PARSER_DRIFT",
        "message": "The OpenTable API is temporarily unavailable. Please retry."
    },
    "success": false
}
503

Service Unavailable

The upstream service is temporarily unavailable. Please retry shortly.

{
    "error": {
        "code": "UPSTREAM_UNAVAILABLE",
        "message": "The OpenTable API is temporarily unavailable. Please retry."
    },
    "success": false
}

Generate Code with AI

Copy a ready-made prompt with all the endpoint details, parameters, and example responses. Paste it into ChatGPT, Claude, or any AI assistant to instantly generate working code.

Try It Live

Test this endpoint in our interactive playground with real data.