Mapping API Response Data to the Database Catalogs

API Response API Element Relational Database File
hotel list response <hotelId> ActivePropertyList
<name> ActivePropertyList
<address1> ActivePropertyList
<city> ActivePropertyList
<stateProvinceCode> ActivePropertyList
<postalCode> ActivePropertyList
<countryCode> ActivePropertyList
<airportCode> ActivePropertyList
<supplierType> ActivePropertyList
<hotelRating> ActivePropertyList
<confidenceRating> ActivePropertyList
<amenityMask> n/a
<tripAdvisorRating> not available
<tripAdvisorReviewCount> not available
<tripAdvisorRatingUrl> not available
<locationDescription> ActivePropertyList
<shortDescription> PropertyDescriptionList
<highRate> ActivePropertyList
<lowRate> ActivePropertyList
<rateCurrencyCode> ActivePropertyList
<latitude> ActivePropertyList
<longitude> ActivePropertyList
<thumbNailUrl> HotelImageList
<roomTypeCode> RoomTypeList
<rateCode> n/a
<maxRoomOccupancy> n/a
<quotedRoomOccupancy> n/a
<minGuestAge> n/a
<roomDescription> RoomTypeList
<promoId> n/a
<promoDescription> n/a
hotel info response <HotelDetails>
<numberOfRooms> PropertyAttributeLink
<numberOfFloors> PropertyAttributeLink
<checkInTime> ActivePropertyList
<propertyInformation> AttributeList - Policy - any (checkin/out, pets, etc)
<areaInformation> AreaAttractionsList
<propertyDescription> PropertyDescriptionList
<knowBeforeYouGoDescription> PolicyDescriptionList
<nationalRatingsDescription> PolicyDescriptionList
<roomInformation> PolicyDescriptionList
<drivingDirections> n/a
<checkInInstructions> AttributeList - Policy - Checkin/out
<Supplier chainCode> ChainList
<RoomTypes>
<roomTypeId> RoomTypeList
<description> RoomTypeList
<descriptionLong> RoomTypeList
<roomAmenities> AttributeList
<RoomAmenity amenityId> AttributeList
<HotelImage>
<hotelImageId> HotelImageList
<name> HotelImageList
<category> not available
<type> not available
<caption> HotelImageList
<url> HotelImageList
<thumbnailUrl> HotelImageList
<supplierId> HotelImageList
<width> HotelImageList
<height> HotelImageList
<byteSize> HotelImageList
hotel room availability response <hotelId> ActivePropertyList
<hotelName> ActivePropertyList
<hotelAddress> ActivePropertyList
<hotelCity> ActivePropertyList
<hotelStateProvince> ActivePropertyList
<hotelCountry> ActivePropertyList
<checkInInstructions> PolicyDescriptionList
<tripAdvisorRating> n/a
<HotelRoomResponse>
<cancellationPolicy> n/a, returned as part of rate and availability
<roomTypeCode> RoomTypeList
<roomTypeDescription> RoomTypeList
<supplierType> ActivePropertyList
<taxRate> n/a, returned as part of rate and availability
<rateChange> n/a, returned as part of rate and availability
<nonRefundable> n/a, returned as part of rate and availability
<guaranteeRequired> n/a, returned as part of rate and availability
<depositRequired> n/a, returned as part of rate and availability
<immediateChargeRequired> n/a, returned as part of rate and availability
<propertyId>25033</propertyId> n/a, returned as part of rate and availability
<promoId> n/a, returned as part of rate and availability
<promoDescription> n/a, returned as part of rate and availability
<BedTypes> n/a, returned as part of rate and availability