Pull Historical Bookings

This API provides you all historical bookings information based on reservation dates of both past and future as per your needs. The API can return data in XML formats. The web service responds to HTTP POST requests.

End Point URL

Header

Content-Type: application/xml

Parameter

NameData TypeDescriptionExample
Request_Type *VARCHAR(250)Use Keyword “Booking”
HotelCode *INT(11)Unique Hotel codeXXXX
AuthCode *VARCHAR(300)Unique Authentication codeXXXXXXXXXXXXXXXXX
FromDate *DATETo send a from date2020-07-05
ToDate *DATETo send a to date2020-07-06
Note – The difference between the start date and end date should not be more than 2 days.

Request 

<RES_Request>   
<Request_Type>Booking</Request_Type>
    <Authentication>
       <HotelCode>xxxx</HotelCode>
       <AuthCode>xxxxxxxxxx</AuthCode>
    </Authentication>
    <FromDate>2020-03-05</FromDate>
    <ToDate>2020-03-06</ToDate>
</RES_Request>

Response

NameData TypeDescriptionExample
LocationIdINT(11)Hotel codexxxx
UniqueIDVARCHAR(255)Unique Booking id10125, 86436, B4525 etc
BookedByVARCHAR(255)Information regarding Booked byBooking.com etc
Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email.VARCHAR(255)Here * denotes guest information likeSalutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email.shown in JSON response below.
BusinessSourceVARCHAR(100)Business Source Name
SourceVARCHAR(1000)Booking generated sourceBooking.com etc
IsChannelBookingINT(1)Is booking comes from channel [0 or 1]1 : Booking from the channel.0: Booking not from the channel.0 or 1
BookingTran. SubBookingIdVARCHAR(255)Sub booking Id138
BookingTran. TransactionIdINT(20)Booking Transaction ID112500000000000163
BookingTran.CreatedatetimeDATETIMEBooking created date time2020-03-16 12:00:58
BookingTran.ModifydatetimeDATETIMEBooking modified date time2020-03-16 12:00:58
BookingTran. StatusVARCHAR(1000)Booking StatusNew or Modify.
BookingTran.IsConfirmedINT(1)Booking Confirmation Flag. [1 or 0]
1 : Confirmed0 : Not Confirmed
1 or 0.
BookingTran.CurrentStatusVARCHAR(100)Booking Current Status
EX : Confirm, Check-In, Check-Out, etc
Check-In
BookingTran. VoucherNoVARCHAR(255)Booking Voucher No10203049/8512
BookingTran. PackageCodeINT(20)Package Code112500000000000001
BookingTran. PackageNameVARCHAR(1000)Package NameEuropean Plan etc
BookingTran. RateplanCodeINT(20)Unique RatePlan Code112500000000000006
BookingTran. RateplanNameSTRING(1000)RatePlan NameGrand Sea View Junior Suite
BookingTran. eZeePMSRoomidINT(20)eZee PMS Room Id106
BookingTran. RoomTypeCodeINT(20)Unique RoomType Code112500000000000006
BookingTran. RoomTypeNameSTRING(1000)RoomType NameGarden View Studio Room
BookingTran. StartDATETIMECheck-in date
[Format : yyyy-mm-dd]
2017-12-25
BookingTran. EndDATETIMECheck-out date [Format : yyyy-mm-dd]2017-12-27
BookingTran. CurrencyCodeVARCHAR(255)Currency codeINR
BookingTran.TotalRateDECIMAL(19,4)Rate on room in amount1500.43
BookingTran.TotalAmountAfterTaxDECIMAL(19,4)Total amount after tax1500.43
BookingTran.TotalAmountBeforeTaxDECIMAL(19,4)Total amount before tax1200
BookingTran.TotalTaxDECIMAL(19,4)Total tax300.43
BookingTran. TotalDiscountDECIMAL(19,4)Discount on room in amount500
BookingTran. TotalExtraChargeDECIMAL(19,4)Extra charges in amount(if any)300
BookingTran. TotalPaymentDECIMAL(19,4)Payment for room in amount2500.54
BookingTran.*Here * denotes guest informations likeSalutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,IdentityType,
IdentityNo, ExpiryDate.
BookingTran. TransportationModeVARCHAR(100)Mode of transportationBus, car etc
BookingTran. VehicleVARCHAR(255)Detail of vehicle
BookingTran. PickupDateDATETIMEPickup date
[Format : yyyy-mm-dd]
2017-12-25 etc
BookingTran. PickupTimeDATETIMEPickup time
BookingTran. SourceVARCHAR(1000)Booking generated sourceBooking.com
BookingTran. CommentVARCHAR(1000)Additional Information or comment.
BookingTran. AffiliateNameVARCHAR(1000)Booking Affiliate Name
BookingTran.AffiliateCodeVARCHAR(1000)Booking Affiliate Code
BookingTran.*Here * denotes information like Credit Card Informations likeCCLink, CCNo, CCType,CardHolderName, CCExpiryDate,
BookingTran.ExtraCharge .*here * denotes ChargeDate,ChargeCode,
ChargeName,
ChargeDesc,Remark,Quantity,
AmountBeforeTax,Amount
BookingTran.RentalInfo.EffectiveDateDATETIMEBooking details for particular effective date2017-12-25 etc
BookingTran.RentalInfo.PackageCodeINT(20)Package code112500000000000001
BookingTran.RentalInfo.PackageNameVARCHAR(1000)Package NameEuropean Plan
BookingTran.RentalInfo.R oomTypeCodeINT(20)Unique RoomType Code112500000000000006
BookingTran.RentalInfo.R oomTypeNameSTRING(1000)RoomType NameGrand Sea View Junior Suite
BookingTran.RentalInfo.AdultINT(11)No. of Adults2,3,4 etc
BookingTran. RentalInfo.ChildINT(11)No. of Childs2,3,4 etc
BookingTran. RentalInfo.RentDECIMAL(19,4)Room rental amount1500.43
BookingTran. RentalInfo.DiscountDECIMAL(19,4)Discount on rental room in amount500
BookingTran. Sharer. *Here * denotes informations likeSalutation,
FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth,
WeddingAnniversary, Nationality,
Address, City, State,
Country, Zip Code, Phone, Mobile, Fax, Email,IdentityType,
IdentityNo, ExpiryDate.
Errors.ErrorCodeResponse Error Code104, 404 etc
Errors.ErrorMessageGenerate Response MessageUnauthorized Request. etc

Success

<?xml version="1.0" encoding="UTF-8"?><RES_Response>
    <Reservations>
        <Reservation>
            <BookByInfo>
                <LocationId>8943</LocationId>
                <UniqueID>11</UniqueID>
                <BookedBy>Joy Smith</BookedBy>
                <Salutation>Mr.</Salutation>
                <FirstName>Joy</FirstName>
                <LastName>Smith</LastName>
                <Gender>Male</Gender>
                <Address></Address>
                <City></City>
                <State></State>
                <Country>India</Country>
                <Zipcode></Zipcode>
                <Phone></Phone>
                <Mobile></Mobile>
                <Fax></Fax>
                <Email></Email>
                <BusinessSource>Booking.com</BusinessSource>
                <Source>PMS</Source>
                <IsChannelBooking>0</IsChannelBooking>
                <BookingTran>
                    <SubBookingId>11</SubBookingId>
                    <TransactionId>894300000000000010</TransactionId>
                    <Createdatetime>2020-03-05 12:00:58</Createdatetime>
                    <Modifydatetime>2020-03-16 12:00:58</Modifydatetime>
                    <Status>New</Status>
                    <IsConfirmed>1</IsConfirmed>
                    <CurrentStatus>Check-In</CurrentStatus>
                    <VoucherNo></VoucherNo>
                    <PackageCode>894300000000000002</PackageCode>
                    <PackageName>All Inclusive</PackageName>
                    <RateplanCode>894300000000000013</RateplanCode>
                    <RateplanName>Studio All Inclusive</RateplanName>
                    <eZeePMSRoomid>106</eZeePMSRoomid>
                    <RoomTypeCode>894300000000000001</RoomTypeCode>
                    <RoomTypeName>Studio</RoomTypeName>
                    <Start>2020-03-17</Start>
                    <End>2020-03-20</End>
                    <CurrencyCode>INR</CurrencyCode>
                    <TotalRate>8850.00</TotalRate>
                    <TotalAmountAfterTax>8850.00</TotalAmountAfterTax>
                    <TotalAmountBeforeTax>7500.00</TotalAmountBeforeTax>
                    <TotalTax>1350.00</TotalTax>
                    <TotalDiscount>0.00</TotalDiscount>
                    <TotalExtraCharge>15.00</TotalExtraCharge>
                    <TotalPayment>8865.00</TotalPayment>
                    <PayAtHotel>false</PayAtHotel>
                    <TACommision>0.00</TACommision>
                    <Salutation>Mr.</Salutation>
                    <FirstName>Joy</FirstName>
                    <LastName>Smith</LastName>
                    <Gender>Male</Gender>
                    <DateOfBirth></DateOfBirth>
                    <SpouseDateOfBirth></SpouseDateOfBirth>
                    <WeddingAnniversary></WeddingAnniversary>
                    <Nationality></Nationality>
                    <Address></Address>
                    <City></City>
                    <State></State>
                    <Country>India</Country>
                    <Zipcode></Zipcode>
                    <Phone></Phone>
                    <Mobile></Mobile>
                    <Fax></Fax>
                    <Email></Email>
                    <IdentiyType>Aadhar card</IdentiyType>
                    <IdentityNo>12315346546</IdentityNo>
                    <ExpiryDate></ExpiryDate>
                    <TransportationMode></TransportationMode>
                    <Vehicle></Vehicle>
                    <PickupDate></PickupDate>
                    <PickupTime></PickupTime>
                    <Source>PMS</Source>
                    <Comment></Comment>
                    <AffiliateName></AffiliateName>
                    <AffiliateCode></AffiliateCode>
                    <CCLink></CCLink>
                    <CCNo></CCNo>
                    <CCType></CCType>
                    <CCExpiryDate></CCExpiryDate>
                    <CardHoldersName></CardHoldersName>
                    <ExtraCharge>
                        <ChargeDate>2020-03-18</ChargeDate>
                        <ChargeCode></ChargeCode>
                        <ChargeName>Call Charges</ChargeName>
                        <ChargeDesc></ChargeDesc>
                        <Remark></Remark>
                        <Quantity>15</Quantity>
                        <AmountBeforeTax>15.00</AmountBeforeTax>
                        <Amount>15.00</Amount>
                    </ExtraCharge>
                    <RentalInfo>
                        <EffectiveDate>2020-03-18</EffectiveDate>
                        <PackageCode>894300000000000002</PackageCode>
                        <PackageName>All Inclusive</PackageName>
                        <RoomTypeCode>894300000000000001</RoomTypeCode>
                        <RoomTypeName>Studio</RoomTypeName>
                        <Adult>2</Adult>
                        <Child>2</Child>
                        <Rent>2950.00</Rent>
                        <RentBeforeTax>2500.00</RentBeforeTax>
                        <Discount>0.00</Discount>
                    </RentalInfo>
                    <RentalInfo>
                        <EffectiveDate>2020-03-19</EffectiveDate>
                        <PackageCode>894300000000000002</PackageCode>
                        <PackageName>All Inclusive</PackageName>
                        <RoomTypeCode>894300000000000001</RoomTypeCode>
                        <RoomTypeName>Studio</RoomTypeName>
                        <Adult>2</Adult>
                        <Child>2</Child>
                        <Rent>2950.00</Rent>
                        <RentBeforeTax>2500.00</RentBeforeTax>
                        <Discount>0.00</Discount>
                    </RentalInfo>
                    <Sharer>
                        <Salutation>Mam.</Salutation>
                        <FirstName>Maya</FirstName>
                        <LastName></LastName>
                        <Gender>Female</Gender>
                        <DateOfBirth></DateOfBirth>
                        <SpouseDateOfBirth></SpouseDateOfBirth>
                        <WeddingAnniversary></WeddingAnniversary>
                        <Nationality>India</Nationality>
                        <Address></Address>
                        <City></City>
                        <State></State>
                        <Country>India</Country>
                        <Zipcode></Zipcode>
                        <Phone></Phone>
                        <Mobile></Mobile>
                        <Fax></Fax>
                        <Email></Email>
                        <IdentiyType>Aadhar card</IdentiyType>
                        <IdentityNo>789456123</IdentityNo>
                        <ExpiryDate></ExpiryDate>
                    </Sharer>
                </BookingTran>
            </BookByInfo>
        </Reservation>
        <CancelReservation>
             <LocationId>8943</LocationId>
             <UniqueID>206-1</UniqueID>
             <Remark>Cancel,Guest want to cancel reservation through Agoda</Remark>
             <VoucherNo>12314986/1</VoucherNo>
        </CancelReservation>
        <CancelReservation>
             <LocationId>8943</LocationId>
             <UniqueID>206-2</UniqueID>
             <Remark>Cancel,Guest want to cancel reservation through Agoda</Remark>
             <VoucherNo>12314944/2</VoucherNo>
         </CancelReservation>
         <CancelReservation>
              <LocationId>8943</LocationId>
              <UniqueID>207</UniqueID>
              <Remark>Cancel,Guest want to cancel reservation through Agoda</Remark>
              <VoucherNo>123149844/1</VoucherNo>
         </CancelReservation>
         <CancelReservation>
              <LocationId>8943</LocationId>
              <UniqueID>200</UniqueID>
              <Remark>Cancel,Guest want to cancel reservation through Agoda</Remark>
              <VoucherNo>123149444</VoucherNo>
          </CancelReservation>
    </Reservations>
    <Errors>
        <ErrorCode>0</ErrorCode>
        <ErrorMessage>Success</ErrorMessage>
    </Errors>
</RES_Response>

Error Codes

Error CodeError Name
114Missing from date in some request
115Missing to date in some request
117From Date is not valid date
118To Date is not valid date
119Please check From and To date. To Date should be greater than From Date
113Missing roomtype id in some request
400Invalid Request Format
302Authentication failed
303Auth Code is inactive.
301Unauthorized request. Request is not valid for this hotel code
202Unauthorized request. Hotel code is not active
111Invalid Request
204Duplicate request. Please try again after 1 minute.

Click here to Register