Skip to main content

Data Warehouse Delivery - Reservations

10.34
Data Warehouse Delivery
Reservations
SOAP API
Data Warehouse Integration

Not Signed In.

Looks like you may not have access to all of the resources and documentation for this page.
Please log-in or contact your support desk team if you believe you should have access.

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>