GET

OpenTable URL to Restaurant ID API

Turn a full OpenTable /r/{slug} profile URL into the stable restaurant ID used by reviews and availability.

Overview

Exact match for any profile URL

Any valid OpenTable /r/{slug} profile URL resolves to its exact restaurant, including older URLs whose slug no longer matches the current restaurant name or location.

Use this endpoint when your input is an OpenTable restaurant URL instead of a numeric ID. The response also includes enough location context to verify the match before using restaurant_id with reviews, exact availability, or nearby slots.

Endpoint URL

GET https://api.stayapi.com/v1/opentable/restaurant/url-to-id

Query Parameter

Parameter	Type	Required	Description
url	string	Required	Full OpenTable restaurant profile URL in the form `https://www.opentable.com/r/{slug}`. Country domains such as `opentable.fr` and `opentable.co.uk` are supported.

Response Fields

Field	Description
restaurant_id	Positive numeric OpenTable restaurant ID.
name	Restaurant name returned by OpenTable.
country	Country associated with the matched restaurant.
macro	OpenTable's broader dining area, such as South West London.
neighborhood	OpenTable neighborhood when available.

Keep the ID

Store restaurant_id after the first resolution. Future review and availability calls can use it directly without repeating the URL lookup.

Error Responses

Errors follow RFC 7807 Problem Details with provider: "opentable" and product: "url-to-id".

400 Invalid URL

INVALID_URL when the value is not a supported OpenTable restaurant profile URL.

404 Restaurant not found

RESTAURANT_NOT_FOUND when no OpenTable restaurant exists at that profile URL.

502 Upstream error

UPSTREAM_ERROR when OpenTable can't be reached or doesn't return the restaurant profile.

Related Endpoints

Restaurant Menu

Fetch structured menus and prices with the resolved ID.

View Documentation →

Restaurant Reviews

Fetch newest, highest-rated, or lowest-rated reviews with the resolved ID.

View Documentation →

Exact Availability

Check one restaurant, date, time, and party size.

View Documentation →

Request

curl -G "https://api.stayapi.com/v1/opentable/restaurant/url-to-id" \
  --data-urlencode "url=https://www.opentable.com/r/the-ivy-victoria-brasserie-london-2" \
  -H "X-API-Key: YOUR_API_KEY"

const url = new URL('https://api.stayapi.com/v1/opentable/restaurant/url-to-id');
url.searchParams.set(
  'url',
  'https://www.opentable.com/r/the-ivy-victoria-brasserie-london-2'
);

const response = await fetch(url, {
  headers: { 'X-API-Key': 'YOUR_API_KEY' }
});
if (!response.ok) throw new Error(`Request failed: ${response.status}`);
console.log(await response.json());

import requests

response = requests.get(
    "https://api.stayapi.com/v1/opentable/restaurant/url-to-id",
    params={
        "url": "https://www.opentable.com/r/the-ivy-victoria-brasserie-london-2"
    },
    headers={"X-API-Key": "YOUR_API_KEY"},
)
response.raise_for_status()
print(response.json())

<?php
$url = 'https://api.stayapi.com/v1/opentable/restaurant/url-to-id?' . http_build_query([
    'url' => 'https://www.opentable.com/r/the-ivy-victoria-brasserie-london-2',
]);
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, ['X-API-Key: YOUR_API_KEY']);
echo curl_exec($ch);
curl_close($ch);

require 'net/http'
require 'json'

uri = URI('https://api.stayapi.com/v1/opentable/restaurant/url-to-id')
uri.query = URI.encode_www_form(
  url: 'https://www.opentable.com/r/the-ivy-victoria-brasserie-london-2'
)
request = Net::HTTP::Get.new(uri)
request['X-API-Key'] = 'YOUR_API_KEY'
response = Net::HTTP.start(uri.host, uri.port, use_ssl: true) { |http| http.request(request) }
puts JSON.pretty_generate(JSON.parse(response.body))

Response

{
  "success": true,
  "restaurant_id": 180654,
  "name": "The Ivy Victoria Brasserie",
  "country": "United Kingdom",
  "macro": "South West London",
  "neighborhood": "Victoria"
}

{
  "type": "https://api.stayapi.com/errors/invalid-url",
  "title": "Invalid OpenTable URL",
  "status": 400,
  "detail": "url must be a full OpenTable restaurant URL in the form https://www.opentable.com/r/{slug}.",
  "instance": "/v1/opentable/restaurant/url-to-id",
  "provider": "opentable",
  "product": "url-to-id",
  "error_code": "INVALID_URL",
  "correlation_id": "request-id"
}