close

Sign in

To view secure documentation please login with EAN Service Desk, using the link below.

EAN service desk

No EAN Service Desk account?

Please contact your EAN representative

Login
Sign in
Rapid

Content Database Recommendations

Content provided in the Rapid Content API can be stored in your database for quick display retrieval.

The example below provides the SQL data types of the content fields as they appear in the Property Content File and Property Content API response and their recommended minimum storage lengths. The Property Catalog File provides a subset of these fields.

{
  "property_id": "INTEGER",
  "name": "STRING(70)",
  "address": {
    "line_1": "STRING(100)",
    "line_2": "STRING(100)",    
    "city": "STRING(100)",
    "state_province_code": "STRING(2)",
    "state_province_name": "STRING(256)",
    "postal_code": "STRING(15)",
    "country_code": "STRING(3)"
  },
  "ratings": {
    "property": {
      "rating": "STRING(4)",
      "type": "STRING(10)"
    },
    "tripadvisor": {
      "rating": "STRING(4)",
      "count": "INTEGER",
      "links": {
        "rating_image": {
          "method": "STRING(10)**",
          "href": "STRING(600)"
        }
      }
    }
  },
  "location": {
    "coordinates": {
      "latitude": "DECIMAL(9,6)",
      "longitude": "DECIMAL(9,6)"
    }
  },
  "phone": "STRING(20)",
  "fax": "STRING(20)",
  "category": {
    "id": "SMALLINT",
    "name": "STRING(100)**"
  },
  "rank": "INTEGER",
  "checkin": {
    "begin_time": "STRING(20)",
    "end_time": "STRING(20)",
    "instructions": "STRING(4000)*",
    "special_instructions": "STRING(10000)*",
    "min_age": "STRING(10)"
  },
  "checkout": {
    "time": "STRING(20)"
  },
  "fees": {
    "mandatory": "STRING(8000)*",
    "optional": "STRING(4000)*"
  },
  "policies": {
    "know_before_you_go": "STRING(8000)*"
  },
  "amenities": {
    "INTEGER": {
      "id": "INTEGER",
      "name": "STRING(400)"
    }
  },
  "images": [
    {
      "caption": "STRING(400)*",
      "hero_image": "BIT",
      "category": "INTEGER",
      "links": {
        "STRING(20)**": {
          "method": "STRING(10)**",
          "href": "STRING(600)"
        }
      }
    }
  ],
  "onsite_payments": {
    "currency": "STRING(3)",
    "types": {
      "INTEGER": {
        "id": "INTEGER",
        "name": "STRING(255)"
      }
    }
  },
  "rooms": {
    "STRING(10)": {
      "id": "STRING(10)",
      "name": "STRING(100)",
      "descriptions": {
        "overview": "STRING(7000)*"
      },
      "amenities": {
        "INTEGER": {
          "id": "INTEGER",
          "name": "STRING(500)"
        }
      },
      "images": [
        {
          "hero_image": "BIT",
          "category": "INTEGER",
          "links": {
            "STRING(20)**": {
              "method": "STRING(10)**",
              "href": "STRING(600)"
            }
          }
        }
      ],
      "bed_groups": {
        "STRING(100)" {
          "id": "STRING(100)",
          "description": "STRING(1000)",
          "configuration": [
            {
              "quantity": "TINYINT(1-255)",
              "size": "STRING(40)",
              "type": "STRING(200)"
            }
          ]
        }
      }
    }
  },
  "rates": {
    "STRING(10)": {
      "id": "STRING(10)",
      "amenities": {
        "INTEGER": {
          "id": "INTEGER",
          "name": "STRING(200)*"
        }
      }
    }
  },
  "date_entered": "DATETIME"
  "descriptions": {
    "amenities": "STRING(2000)*",
    "dining": "STRING(2000)*",
    "renovations": "STRING(2000)*",
    "national_ratings": "STRING(1000)*",
    "business_amenities": "STRING(2000)*",
    "rooms": "STRING(2000)*",
    "attractions": "STRING(4000)*",
    "location": "STRING(1000)*"
  }
}

* The source database can handle up to 2GB of text, but values will be much smaller. The max length specified is approximately double the longest string currently stored.

** These are enumerations and aren't stored in the database.

Previous API Documentation - New Location

Looking for docs for your V3 integration? Simply sign in to your account on support.ean.com to view all documentation for our previous V3 API.
Contact your EAN representative if you need assistance with your support.ean.com account - docs are not available without an account.