The Data Warehouse Reservation Delivery (OTA_HotelResNotifRQ) API is used to deliver a near-real-time feed of a chain's reservation transactions for use by a customer's data warehouse.
Target Audience
Data Warehouse Integration
API Version
10.34
Authentication
Security Credentials
Service Action Code
OTA_HotelResNotifRQ
Sample Request
<OTA_HotelResNotifRQ xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" EchoToken="1cc6fb73-af86-4cbd-ae33-6c38c9f8a29d" TimeStamp="2019-06-27T16:56:30.5870837+00:00" Version="5.000" ResStatus="Commit" xmlns="http://www.opentravel.org/OTA/2003/05">
<POS>
<Source>
<RequestorID Type="22" ID="Synxis"/>
<BookingChannel Type="7" Primary="true">
<CompanyName Code="GC">Booking Engine</CompanyName>
</BookingChannel>
<TPA_Extensions>
<Template Name="HFLEX"/>
<Shell Name="DefaultChainShell"/>
</TPA_Extensions>
</Source>
</POS>
<HotelReservations>
<HotelReservation RoomStayReservation="true" CreateDateTime="2019-06-20T14:55:07" CreatorID="Synxis" ResStatus="Reserved">
<UniqueID Type="14" ID="CI3611X"/>
<RoomStays>
<RoomStay MarketCode="MARKSEGHOT1" SourceOfBusiness="MARKSOURCE1">
<RoomTypes>
<RoomType RoomTypeCode="RT-H REG3">
<RoomDescription>
<Text>RT-H REG3 RmType Name Long (HotLvlRmType)</Text>
</RoomDescription>
<AdditionalDetails>
<AdditionalDetail Type="Short Description">
<DetailDescription>
<Text>RT-H REG3 RmType Name Short (HotLvlRmType)</Text>
</DetailDescription>
</AdditionalDetail>
<AdditionalDetail Type="Name">
<DetailDescription>
<Text>RT-H REG3 RmType Name</Text>
</DetailDescription>
</AdditionalDetail>
<AdditionalDetail Type="CategoryCode">
<DetailDescription>
<Text>RC-H STD1</Text>
</DetailDescription>
</AdditionalDetail>
</AdditionalDetails>
</RoomType>
</RoomTypes>
<RatePlans>
<RatePlan RatePlanCode="DDCHCRate1" RatePlanType="13" IsCommissionable="true">
<RatePlanDescription>
<Text>DD CHC Rate1 - long</Text>
</RatePlanDescription>
<RatePlanInclusions TaxInclusive="false"/>
<Commission Percent="10"/>
<AdditionalDetails>
<AdditionalDetail Type="Short Description">
<DetailDescription>
<Text>DD CHC Rate1 - short update</Text>
</DetailDescription>
</AdditionalDetail>
<AdditionalDetail Type="14" Code="DDCHCRate1"/>
<AdditionalDetail Type="PMSCode" Code="DDCHCRate1"/>
</AdditionalDetails>
</RatePlan>
</RatePlans>
<RoomRates>
<RoomRate RoomTypeCode="RT-H REG3" NumberOfUnits="1" RatePlanCode="DDCHCRate1" RatePlanCategory="Rack Rates">
<Rates>
<Rate EffectiveDate="2019-07-22" ExpireDate="2019-07-23" RateTimeUnit="Day" UnitMultiplier="1">
<Base AmountBeforeTax="120" CurrencyCode="USD">
<Taxes Amount="44.90" CurrencyCode="USD"/>
</Base>
<TPA_Extensions>
<AwardRate RateQualification="false"/>
</TPA_Extensions>
</Rate>
</Rates>
</RoomRate>
</RoomRates>
<GuestCounts IsPerRoom="true">
<GuestCount AgeQualifyingCode="10" Count="2"/>
</GuestCounts>
<TimeSpan Start="2019-07-22" End="2019-07-23"/>
<DepositPayments>
<GuaranteePayment>
<AcceptedPayments>
<AcceptedPayment PaymentTransactionTypeCode="reserve">
<PaymentCard CardType="1" CardCode="VI" CardNumber="XXXXXXXXXXXX1111" ExpireDate="XXXX">
<CardHolderName>Dhara</CardHolderName>
</PaymentCard>
</AcceptedPayment>
</AcceptedPayments>
<AmountPercent Amount="17.891" CurrencyCode="USD"/>
<Deadline OffsetTimeUnit="Day" OffsetUnitMultiplier="0" OffsetDropTime="AfterBooking"/>
</GuaranteePayment>
</DepositPayments>
<Total AmountBeforeTax="120" CurrencyCode="USD">
<Taxes Amount="58.91" CurrencyCode="USD">
<Tax Code="27" Amount="2.50" EffectiveDate="2019-07-22" ExpireDate="2019-07-22" ChargeFrequency="1">
<TaxDescription Name="Name">
<Text>Miscellaneous Fee</Text>
</TaxDescription>
</Tax>
<Tax Code="28" Amount="20.40" EffectiveDate="2019-07-22" ExpireDate="2019-07-22" ChargeFrequency="1">
<TaxDescription Name="Name">
<Text>Room Tax</Text>
</TaxDescription>
</Tax>
<Tax Code="10" Amount="22" EffectiveDate="2019-07-22" ExpireDate="2019-07-22" ChargeFrequency="1">
<TaxDescription Name="Name">
<Text>Occupancy Tax</Text>
</TaxDescription>
</Tax>
<Tax Code="12" Amount="3.51" EffectiveDate="2019-07-22" ExpireDate="2019-07-22" ChargeFrequency="12">
<TaxDescription Name="Name">
<Text>Resort Fee</Text>
</TaxDescription>
</Tax>
<Tax Code="14" Amount="10.50" EffectiveDate="2019-07-22" ExpireDate="2019-07-22" ChargeFrequency="12">
<TaxDescription Name="Name">
<Text>Service Charge</Text>
</TaxDescription>
</Tax>
</Taxes>
</Total>
<BasicPropertyInfo ChainCode="MC_QA_ITI_1" BrandCode="DDLuxury" HotelCode="DD HT QA" HotelName="DD HT OXI QA NAME"/>
<ResGuestRPHs>
<ResGuestRPH RPH="1"/>
<ResGuestRPH RPH="2"/>
</ResGuestRPHs>
<Comments>
<Comment GuestViewable="true">
<Text/>
</Comment>
</Comments>
</RoomStay>
</RoomStays>
<ResGuests>
<ResGuest ResGuestRPH="1" PrimaryIndicator="true">
<TPA_Extensions>
<ResGuestInfo ID="CI3611V">
<PersonName>
<NamePrefix>Mr.</NamePrefix>
<GivenName>Test1</GivenName>
<Surname>Booking</Surname>
</PersonName>
<Telephone PhoneTechType="1" PhoneNumber="8764093382" FormattedInd="false" DefaultInd="true"/>
<Email>test1booking@abc.com</Email>
<Address FormattedInd="False" ShareSynchInd="Yes" ShareMarketInd="Yes" Type="1" Remark="Personal" DefaultInd="false" EffectiveDate="2019-06-27" ExpireDate="2019-06-27" ExpireDateExclusiveIndicator="false" ValidationStatus="SystemValidated" TransferAction="Automatic">
<StreetNmbr/>
<AddressLine>123 Main St</AddressLine>
<CityName>Dallas</CityName>
<StateProv StateCode="TX"/>
<CountryName Code="US"/>
<CompanyName/>
<AddressName/>
<CustArea>Americas</CustArea>
<CustRegion>North America</CustRegion>
</Address>
</ResGuestInfo>
</TPA_Extensions>
</ResGuest>
<ResGuest ResGuestRPH="2" PrimaryIndicator="false">
<TPA_Extensions>
<ResGuestInfo ID="CI3611W">
<PersonName>
<NamePrefix>Mrs.</NamePrefix>
<GivenName>RelatedFN1</GivenName>
<Surname>RelatedLN1</Surname>
</PersonName>
</ResGuestInfo>
</TPA_Extensions>
</ResGuest>
</ResGuests>
<ResGlobalInfo>
<CancelPenalties>
<CancelPenalty PolicyCode="C3D">
<Deadline OffsetTimeUnit="Day" OffsetUnitMultiplier="3" OffsetDropTime="BeforeArrival"/>
<AmountPercent TaxInclusive="false" Percent="0"/>
<PenaltyDescription>
<Text>Cancel Policy 3 Days</Text>
</PenaltyDescription>
</CancelPenalty>
</CancelPenalties>
<HotelReservationIDs>
<HotelReservationID ResID_Type="14" ResID_Value="CI3611X" ResID_Source="CRS" ForGuest="true"/>
<HotelReservationID ResID_Type="34" ResID_Value="14101B0002820" ResID_Source="CRS" ForGuest="true"/>
</HotelReservationIDs>
</ResGlobalInfo>
<TPA_Extensions>
<ConfirmDate ConfirmDateTime="2019-06-20T15:04:22"/>
<LastModifyingChannel Type="7">
<CompanyName Code="GC">Booking Engine</CompanyName>
</LastModifyingChannel>
<AdditionalPropertyInfo HotelID="60684" PMSHotelCode="60684"/>
<FaxCount Count="0"/>
<ExchangeRates USD="1" EUR="0.884645"/>
</TPA_Extensions>
</HotelReservation>
</HotelReservations>
</OTA_HotelResNotifRQ>
Sample Response
<OTA_HotelResNotifRS EchoToken="5e1f4840-79a7-4c4f-96dd-24bc9b7acd72" TimeStamp="2019-05-08T21:24:09" Version="1.003" xsi:schemaLocation="http://www.opentravel.org/OTA/2003/05 OTA_HotelResNotifRQ.xsd" xmlns="http://www.opentravel.org/OTA/2003/05" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Success/>
</OTA_HotelResNotifRS>