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 RecommendationsVersion 2

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.