OpenTable Reviews API | Restaurant Review Intelligence

Scrape OpenTable restaurant reviews as clean structured JSON. Give the API a restaurant and get its reviews, each with the full review text, the dates the diner visited and posted, the diner's public profile, and the complete rating breakdown: overall, food, service, ambience, value, and noise. It is review intelligence for hospitality analytics, restaurant competitive research, and food-media sentiment analysis.

If you need to book a table, use a booking Actor. If you need the review data for analytics, this is the one: it returns the same reviews your competitors are reading, as structured JSON for AI agents.

What you get

One row per review:

• content: the full review text
• rating: the breakdown (overall, food, service, ambience, value, noise)
• dined_at and submitted_at timestamps
• user: the diner's name, review count, and location
• review_id and the restaurant_id it belongs to

Enable includeRestaurantSummary to also get one restaurant-level row with the aggregate ratings and total counts.

Use cases

• Track sentiment and ratings for a restaurant or a chain over time
• Benchmark a restaurant against competitors on food, service, and ambience
• Mine reviews for menu, pricing, and experience feedback
• Power restaurant analytics dashboards and food-media research
• Feed an AI agent a restaurant's reviews to summarize themes and complaints

Input

Field	Type	Description
restaurantId	string	A single restaurant, given as either the OpenTable URL slug (e.g. r/central-park-boathouse-new-york-2) or the full restaurant page URL (e.g. https://www.opentable.com/r/central-park-boathouse-new-york-2). The slug is detected and extracted automatically. Provide this, restaurantIds, or both.
restaurantIds	array of strings	A batch of restaurants to fetch in one run, each a slug or a full URL. Merged with restaurantId and de-duplicated. All restaurants are fetched in parallel.
maxResultsPerRestaurant	integer	Reviews per restaurant. Default 30, maximum 500.
includeRestaurantSummary	boolean	Also return a restaurant-summary row with aggregate ratings. Charged once per restaurant. Default off.

To find a restaurant, open it on OpenTable and either copy the r/... slug from the URL or just paste the whole page URL - either works.

Example input

{
  "restaurantId": "r/central-park-boathouse-new-york-2",
  "maxResultsPerRestaurant": 50,
  "includeRestaurantSummary": true
}

Sample output

{
  "result_type": "review",
  "restaurant_id": "r/central-park-boathouse-new-york-2",
  "position": 1,
  "review_id": "OT-1294132-168206-130084588143",
  "content": "Beautiful restaurant, lovely setting and great service ...",
  "dined_at": "2026-04-01T20:30:00Z",
  "submitted_at": "2026-04-02T17:43:04Z",
  "rating": { "overall": 5, "food": 4, "service": 5, "ambience": 5, "value": 4, "noise": "Moderate" },
  "user": { "name": "PAULINA", "number_of_reviews": 28, "location": "New York Area" }
}

Pricing

Pay-per-result: a flat $0.008 per review returned. The optional restaurant summary is $0.005 once per restaurant, only when you enable it. No setup fee, no per-run fee, no monthly minimum.

How to get started

1. Open OpenTable Reviews API on the Apify Store.
2. Enter a restaurantId (or a restaurantIds list of OpenTable slugs).
3. Set maxResultsPerRestaurant, then run the Actor.
4. Export the dataset as JSON, CSV, or Excel, or pull it from the API.

Prefer code? See the OpenTable Reviews API example repo for a Python quick-start and MCP setup guides.

Run from the API

curl -X POST "https://api.apify.com/v2/acts/johnvc~opentable-reviews-api/run-sync-get-dataset-items?token=YOUR_APIFY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"restaurantId":"r/central-park-boathouse-new-york-2","maxResultsPerRestaurant":30}'

🔌 Use this API from Claude (MCP)

This Actor is compatible with the Model Context Protocol (MCP), so AI agents can call it as a tool. Add it through the hosted Apify MCP server using this Actor-specific URL:

https://mcp.apify.com/?tools=actors,docs,johnvc/opentable-reviews-api

If you run agents from Claude Code (free trial) or Claude Cowork (free trial), add the Apify MCP server and ask it to "pull this restaurant's reviews and summarize the common complaints."

Setup walkthrough:

Apify MCP integration docs: https://docs.apify.com/platform/integrations/mcp

MCP setup, step by step

Visual setup guides for each client (source and more assets: ApifyPublicData on GitHub):

Claude Cowork Desktop

Claude Code

Claude (website)

Cursor

ChatGPT

FAQ

What is a restaurant ID? It is the OpenTable URL slug, the r/... path for the restaurant. Open the restaurant on OpenTable and copy it from the URL. A full URL also works.

How many reviews come back? Up to maxResultsPerRestaurant (default 30). The Actor paginates a restaurant's reviews for you.

Does it book tables? No. This Actor is for review data and analytics. For reservations, use a dedicated OpenTable booking Actor.

Can I research several restaurants at once? Yes. Pass a restaurantIds list; each is fetched independently and tagged with its restaurant ID.

Featured Tasks

Ready-to-run examples that show this API solving a specific problem. Each opens its own setup so you can run it on your account in one click.

• Monitor OpenTable reviews for a list of restaurants - Watch a fixed list of restaurants and pull recent reviews for every venue in one run.
• Monitor OpenTable reviews for San Francisco restaurants - Track a watchlist of San Francisco venues, with review text, dined date, diner profile, and the full rating breakdown.
• Monitor OpenTable reviews for Los Angeles restaurants - Keep tabs on a list of Los Angeles restaurants and their latest reviews.
• Monitor OpenTable reviews for Chicago restaurants - Monitor reviews across a set of Chicago restaurants in a single run.
• Monitor OpenTable reviews for Houston restaurants - Follow a watchlist of Houston restaurants and pull each venue's recent reviews.
• Monitor OpenTable reviews for London restaurants - Track London restaurants and their reviews, with the full per-review rating breakdown.
• Monitor OpenTable reviews for Dubai restaurants - Monitor a list of Dubai restaurants and pull recent reviews for each venue at once.

Last Updated: 2026.06.09