Open
Bookings
Retrieve Transaction Details
This API helps you to fetch booking details for specific transaction unique ID based on Room No, Guest, Identity No, Guest Email, Guest Mobile No, Guest Registration No. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
Request_Type* | VARCHAR(100) | Request Type | GetTransactionDetails |
TranunkId* | VARCHAR(100) | Transaction Id single/multiple (comma separated) | xxxxx0000000000400 |
RoomNo | VARCHAR(500) | Room No (It is Optional) | 101 |
Guest | VARCHAR(100) | Guest Name (It is Optional) | test |
IdentityNo | VARCHAR(255) | Identity No (It is Optional) | ASD43543 |
GuestEmail | VARCHAR(255) | Guest Email (It is Optional) | abc@gmail.com |
GuestMobileNo | VARCHAR(255) | Guest Mobile No (It is Optional) | XXXXXXXXXX |
GuestRegistrationNo | VARCHAR(255) | Guest Registration No (It is Optional) | XXXXXX |
HotelCode* | INT(11) | Unique Hotel code | xxxx |
AuthCode* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
Request
{ "RES_Request": { "Request_Type": "GetTransactionDetails," . "TranunkId": "xxxxx0000000000400", "RoomNo": "101", "Guest": "Joy T. Mnewy", "IdentityNo": "ASD43543", "GuestEmail": "XXXXXX@gmail.com", "GuestMobileNo": "XXXXXXXXXX", "GuestRegistrationNo": "XXXXXX", "Authentication": { "HotelCode": "XXXX", "AuthCode": "XXXXXXXXXXXXXXXXXXX" } } }
Response
Name | Data Type | Description | Example |
LocationId | INT(11) | Hotel code | xxxx |
UniqueID | VARCHAR(255) | Unique Booking id/ Reservation No | 10125, 86436, B4525 etc |
BookedBy | VARCHAR(255) | Information regarding Booked by | Booking.com etc |
Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo. | VARCHAR(255) | Here * denotes guest information like Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo. | shown in JSON response below. |
Source | VARCHAR(1000) | Booking generated source | Booking.com etc |
PaymentMethod | VARCHAR(255) | Payment Mode selected by guest | Cash, Credit, CityLedger etc |
IsChannelBooking | INT(1) | Is booking comes from channel [0 or 1]1 : Booking from the channel.0: Booking not from the channel. | 0 or 1 |
BookingTran. SubBookingId | VARCHAR(255) | Sub booking Id | 138 |
BookingTran. TransactionId | INT(20) | Booking Transaction ID | 112500000000000163 |
BookingTran. Status | VARCHAR(100) | Booking Status | New or Modify or Cancel. |
BookingTran.IsConfirmed | INT(1) | Booking Confirmation Flag. [1 or 0]1 : Confirmed0 : Not Confirmed | 1 or 0. |
BookingTran.CurrentStatus | VARCHAR(100) | Booking Current Status | Arrived, Checked Out, Cancel, Void, etc |
BookingTran.VoucherNo | VARCHAR(255) | Booking Voucher No | 10203049/8512 |
BookingTran. PackageCode | INT(20) | Package Code | 112500000000000001 |
BookingTran. PackageName | VARCHAR(1000) | Package Name | European Plan etc |
BookingTran. RateplanCode | INT(20) | Unique RatePlan Code | 112500000000000006 |
BookingTran. RateplanName | STRING(1000) | RatePlan Name | Grand Sea View Junior Suite |
BookingTran. RoomTypeCode | INT(20) | Unique RoomType Code | 112500000000000006 |
BookingTran. RoomTypeName | STRING(1000) | RoomType Name | Garden View Studio Room |
BookingTran.RoomID | INT(20) | Unique RoomID | 112500000000000001 |
BookingTran. RoomName | STRING(1000) | Room Name | 101 |
BookingTran. Start | DATE | Check-in date[Format : yyyy-mm-dd] | 2017-12-25 |
BookingTran. End | DATE | Check-out date [Format : yyyy-mm-dd] | 2017-12-27 |
BookingTran.TotalRate | DECIMAL(19,4) | Rate on room in amount | 1500.43 |
BookingTran.TotalDiscount | DECIMAL(19,4) | Discount on room in amount | 500 |
BookingTran. TotalExtraCharge | DECIMAL(19,4) | Extra charges in amount(if any) | 300 |
BookingTran.* | – | Here * denotes guest informations like Salutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo,IdentityType, IdentityNo, ExpiryDate. | |
BookingTran. TransportationMode | VARCHAR(100) | Mode of transportation | Bus, car etc |
BookingTran. Vehicle | VARCHAR(255) | Detail of vehicle | |
BookingTran. PickupDate | DATE | Pickup date[Format : yyyy-mm-dd] | 2017-12-25 etc |
BookingTran. PickupTime | TIME | Pickup time | |
BookingTran. Source | VARCHAR(1000) | Booking generated source | Booking.com |
BookingTran. Comment | VARCHAR(1000) | Additional Information or comment. | |
BookingTran. AffiliateName | VARCHAR(1000) | Booking Affiliate Name | |
BookingTran.AffiliateCode | VARCHAR(1000) | Booking Affiliate Code | |
BookingTran.* | – | Here * denotes Credit Card Informations like CCLink, CCNo, CCType, CardHolderName, CCExpiryDate, | CCLink in encoded with base64_encode. |
BookingTran.RentalInfo.RoomID | INT(20) | Unique RoomID | 112500000000000001 |
BookingTran.RentalInfo. RoomName | STRING(1000) | Room Name | 101 |
BookingTran.RentalInfo.EffectiveDate | DATETIME | Booking details for particular effective date | 2017-12-25 etc |
BookingTran.RentalInfo.PackageCode | INT(20) | Package code | 112500000000000001 |
BookingTran.RentalInfo.PackageName | VARCHAR(1000) | Package Name | European Plan |
BookingTran.RentalInfo.RoomTypeCode | INT(20) | Unique RoomType Code | 112500000000000006 |
BookingTran.RentalInfo.RoomTypeName | STRING(1000) | RoomType Name | Grand Sea View Junior Suite |
BookingTran.RentalInfo.Adult | INT(11) | No. of Adults | 2,3,4 etc |
BookingTran. RentalInfo.Child | INT(11) | No. of Child | 2,3,4 etc |
BookingTran. RentalInfo.Rent | DECIMAL(19,4) | Room rental amount | 1500.43 |
BookingTran. RentalInfo.Discount | DECIMAL(19,4) | Discount on rental room in amount | 500 |
BookingTran.Sharer.* | – | Here * denotes Sharer informations like Salutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Nationality,Zip Code, Phone, Mobile, Fax, Email,RegistrationNo,IdentityTypeID, IdentityNo, ExpiryDate. | |
Errors.ErrorCode | – | Response Error Code | 104, 404 etc |
Errors.ErrorMessage | – | Generate Response Message | Unauthorized Request. etc |
Success
{ "Reservations": { "Reservation": [ { "BookingTran": [ { "SubBookingId": "11241254", "TransactionId": "112400000000001902", "Createdatetime": "2019-09-04 11:40:30", "Modifydatetime": "2019-09-04 11:40:30", "Status": "New", "IsConfirmed": "1", "CurrentStatus": "Arrived", "VoucherNo": "single1276/1", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RateplanCode": "112400000000000001", "RateplanName": "Sea View Deluxe Room", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "RoomID": "112400000000000001", "RoomName": "101", "Start": "2019-09-26", "End": "2019-09-28", "ArrivalTime": "12:00:00", "DepartureTime": "11:00:00", "CurrencyCode": "USD", "TotalAmountAfterTax": "976.00", "TotalAmountBeforeTax": "800.00", "TotalTax": "176.00", "TotalDiscount": "0.00", "TotalExtraCharge": "0.00", "TotalPayment": "0.00", "TACommision": "0.00", "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", “RegistrationNo” : "", "IdentityType": "Pan card", "IdentityNo": "12345667765", "ExpiryDate": "", "TransportationMode": "", "Vehicle": "car", "PickupDate": "", "PickupTime": "", "Source": "BookingEye", "Comment": "", "AffiliateName": "", "AffiliateCode": "", "CCLink": "", "CCNo": "", "CCType": "", "CCExpiryDate": "", "CardHoldersName": "", "TaxDeatil": [ { "TaxCode": "AA", "TaxName": "VAT @ 12%", "TaxAmount": "96.0000" }, { "TaxCode": "LT", "TaxName": "Luxury @ 10%", "TaxAmount": "80.0000" } ], "RentalInfo": [ { "RoomID": "112400000000000001", "RoomName": "101", "EffectiveDate": "2019-09-26", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "4", "Child": "2", "RentPreTax": "550.00", "Rent": "671.00", "Discount": "0.00" }, { "RoomID": "112400000000000001", "RoomName": "101", "EffectiveDate": "2019-09-27", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "4", "Child": "2", "RentPreTax": "250.00", "Rent": "305.00", "Discount": "0.00" } ], "Sharer": [ { "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "RegistrationNo" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", }, { "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "Registration No" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", } ] } ], "LocationId": "1124", "UniqueID": "11241254", "BookedBy": "BookingEye", "Salutation": "Ms.", "FirstName": "Larry", "LastName": "Forney", "Gender": "Female", "Address": "", "City": "Brockway", "State": "CA", "Country": "USA", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "Source": "BookingEye", "PaymentMethod": "Cash", "IsChannelBooking": "1" } ] } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters. |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
201 | Unauthorized request. (Request Type) the request is not valid for this hotel code OR OpenAPI platform is deactive |
202 | Unauthorized request. Hotel code is not active |
203 | Missing Parameter OR Invalid Parameter: TranunkId |
301 | Unauthorized Request. Please check hotel code and authentication code |
303 | Auth Code is inactive. |
500 | Error occurred during processing |
502 | Request Type is missing |
503 | No Reservation Found. |
Configuration
Retrieve Available Room List
This API will fetch the available room data between check-in and check-out date. Also, you can add Room Unique Id or Roomtype Unique Id, If you will need particular room data. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
HotelCode* | INT(11) | Unique Hotel code | xxxx |
AuthCode* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
Request_Type* | VARCHAR(100) | Request Type | RoomAvailability |
RoomData->from_date* | DATE | Check-In Date | 2021-12-05 |
RoomData->to_date* | DATE | Check-Out Date | 2021-12-06 |
RoomData->RoomID | INT(11) | Room Unique ID (Optional) | 123400000000000002 |
RoomData->RoomtypeID | INT(11) | Room Type Unique ID (Optional) | 123400000000000002 |
Request
{ "RES_Request": { "Request_Type": "RoomAvailability", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxxxxxxxxxxxxxxxx" }, "RoomData": { "RoomtypeID": "123400000000000002", (Optional) "RoomID": "123400000000000002", (Optional) "from_date": "2021-11-30", "to_date": "2021-12-10" } } }
Response
Name | Data Type | Description | Example |
RoomList-> RoomtypeID | Integer | Roomtype Unique ID | 123400000000000001 |
RoomList-> RoomtypeName | Varchar | Roomtype Name | Deluxe Room |
RoomList-> RoomData-> RoomID | Integer | Room Unique ID | 123400000000000001 |
RoomList-> RoomData-> RoomName | Varchar | Room Name/No | 105 |
Success
{ "Success": { "RoomList": [ { "RoomtypeID": "123400000000000002", "RoomtypeName": "Deluxe Room", "RoomData": [ { "RoomID": "123400000000000011", "RoomName": "101" }, { "RoomID": "123400000000000012", "RoomName": "102" }, ] }, { "RoomtypeID": "1234700000000000003", "RoomtypeName": "Sea View Room", "RoomData": [ { "RoomID": "123400000000000015", "RoomName": "105" }, ] } ] }, "Errors": { "ErrorCode": "0", "ErrorMessage": "Success" } }
Error
{ "Error": [ { "ErrorCode": "121", "ErrorMessage": "Invalid Value. Please check with RoomType Data" } ] }
Error Codes
Error Code | Error Name |
500 | Error occurred during processing |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
105 | From Date is missing |
106 | Date – From Date is not a valid date |
107 | To Date is missing |
108 | Date – To Date is not a valid date |
109 | From Date: <Date> To Date : <Date> – Please check From and To date. To Date should be greater than fromdate |
111 | Missing Parameter OR Invalid Parameter : RoomData |
112 | Invalid Parameter |
113 | Invalid Value |
121 | Invalid Value. Please check with RoomType Data |
122 | Invalid Value. Please check with Room Data |
301 | No Data Found |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
Bookings
Retrieve List of Bills
This API will fetch the folio related billing information for particular reservation no. like folio no, due amount, total amount, total paid amount, guest name, billing person name The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
HotelCode* | INT(11) | Unique Hotel code | xxxx |
AuthCode* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
Request_Type* | VARCHAR(100) | Request Type | RetrieveListofBills |
BookingId* | VARCHAR(100) | Reservation No. | 11-1 or 12 |
Request
{ "RES_Request": { "Request_Type": "RetrieveListofBills", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxxxxxx", "BookingId": "7" } } }
Response
Name | Data Type | Description | Example |
FolioList->foliono | Integer | Folio no | 302 |
FolioList->BillToContact | varchar | Name of billing person | Baiju |
FolioList->GuestName | varchar | Name of guest who booked reservation | Winsent Lobo |
FolioList->CurrencyCode | varchar | Currency Code | INR |
FolioList->TotalCharges | float | Total charges of folio | 500.00 |
FolioList->PaidAmo | float | Total paid amount of folio | 200.00 |
FolioList->DueAmount | float | Total due amount of folio | 300.00 |
Success
{ "Success": { "FolioList": [ { "foliono": "297", "BillToContact": "max", "GuestName": "max", "CurrencyCode": "INR", "TotalCharges": "500.00", "PaidAmount": "-200.00", "DueAmount": "300.00" }, { "foliono": "298", "BillToContact": "max", "GuestName": "max", "CurrencyCode": "INR", "TotalCharges": "600.00", "PaidAmount": "-200.00", "DueAmount": "400.00" } ] }, "Errors":{ "ErrorCode": "0", "ErrorMessage": "Success" } }
Error
{ "Errors": { "ErrorCode": "203", "ErrorMessage": "Reservation is not found for booking 25" } }
Error Codes
Error Code | Error Name |
100 | Missing required parameter – BookingId |
500 | Error occurred during processing |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
103 | Booking ID is missing |
104 | Invalid parameter for bookingId |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive. |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
203 | Reservation is not found for booking |
204 | Reservation is cancelled, noshow or void for booking |
Bookings
Guest Check Out
This API helps you to check out your reservation. The API can return data in JSON formats. The web service responds to HTTP POST requests.
Note: Maximum Five checkout will be allowed at a time.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
HotelCode* | INT(11) | Unique Hotel code | xxxx |
AuthCode* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
Request_Type* | VARCHAR(100) | Request Type | GuestCheckOut |
Reservation-> BookingId* | VARCHAR(150) | Unique Booking Id/Reservation No | 456 or RES-456 |
Request
1.For Single Booking Request
{ "RES_Request": { "Request_Type": "GuestCheckOut", "Authentication": { "HotelCode": "xxxxx", "AuthCode": "xxxxxxxxxxxxxxxxxxxxxxx" }, "Reservation": [ { "BookingId": "575" } ] } }
2.For Multiple Booking Request
{ "RES_Request": { "Request_Type": "GuestCheckOut", "Authentication": { "HotelCode": "xxxxx", "AuthCode": "xxxxxxxxxxxxxxxxxxxxxxx" }, "Reservation": [ { "BookingId": "575" }, { "BookingId": "576" }, ] } }
Response
Name | Data Type | Description | Example |
Success-> SuccessMsg | String | Success Message | Successfully Done |
Success-> Invoices-> BookingId | String | Booking Id | 575 |
Success-> Invoices-> InvoiceNo | String | Invoice Number | 65 |
Errors->ErrorCode | integer | Error Code | 0 |
Errors->ErrorMessage | String | Error Message | Success |
Success
1.Full operation is successfully completed { "Success": { "SuccessMsg": "Guest Check Out is successfully done for Booking 575", "Invoices": [ { "BookingId": "575", "InvoiceNo": "65" } ] }, "Errors": [ { "ErrorCode": "0", "ErrorMessage": "Success" } ] } 2.Full operation is successfully completed for multiple booking { "Success": { "SuccessMsg": "Guest Check Out is successfully done for Booking 575,576", "Invoices": [ { "BookingId": "575", "InvoiceNo": "65" }, { "BookingId": "576", "InvoiceNo": "66" } ] }, "Errors": [ { "ErrorCode": "0", "ErrorMessage": "Success" } ] } 3.In case some bookings are successfully checked out and some have errors for multiple bookings { "Success": { "SuccessMsg": "Guest Check Out is successfully done for Booking 575,576", "Invoices": [ { "BookingId": "575", "InvoiceNo": "65" }, { "BookingId": "576", "InvoiceNo": "66" } ] }, "Error": [ { "ErrorCode": 118, "ErrorMessage": "Booking status has been checked out for Booking 524" } ] }
Error
{ "Error": [ { "ErrorCode": 100, "ErrorMessage": "Missing required parameters." } ] }
Error Codes
Error Code | Error Name |
100 | Missing required parameters. |
500 | Error occurred during processing |
501 | Error occurred during CheckIn processing |
502 | Request Type is missing |
600 | Something went wrong! |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive. |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
110 | Booking ID is missing in Reservation block |
113 | We don’t find this reservation in our system. So guest check out not performed for booking. |
114 | Folio pending on reservation. So guest check out is not performed for Booking |
115 | Reservation is not yet checked in. So guest check out is not performed for Booking |
116 | Today is not a check out date. So guest check out is not performed for Booking |
117 | Booking status has been cancelled, noshow or void. So guest check out is not performed for Booking |
118 | Booking status has been checked out for Booking |
129 | You are not allowed to check out for more than five bookings |
Bookings
Room Assignment
This API helps you to Assign Room to your reservation. The API can return data in JSON formats. The web service responds to HTTP POST requests.
Note: Maximum Five bookings will be processed at a time.
End Point URL
Header
Name | Data Type | Description | Example |
HotelCode* | INT(11) | Unique Hotel code | xxxx |
AuthCode* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxxxx |
Request_Type* | VARCHAR(100) | Request Type | AssignRoom |
RoomAssign->BookingId* | VARCHAR(100) | Reservation No. | RES101,RES112-1 |
RoomAssign->RoomTypeID* | BIGINT(20) | Unique RoomType ID | 1234500000000000001 Please check API Retrieve Room Information to get RoomTypeID https://api.ezeetechnosys.com/?#519 |
RoomAssign->RoomID* | BIGINT(20) | Unique Room ID | 1234500000000000001 Please check API Retrieve Room Information to get RoomID https://api.ezeetechnosys.com/?#519 |
Request
{ "RES_Request": { "Request_Type": "AssignRoom", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" }, "RoomAssign": [{ "BookingId": "RES101", "RoomTypeID": "1234500000000000001", "RoomID": "1234500000000000001" }, { "BookingId": "RES112-1", "RoomTypeID": "1234500000000000002", "RoomID": "1234500000000000002" }] } }
Response
Name | Data Type | Description | Example |
Success->SuccessMsg | String | Success Message | Successfully Done |
Errors->ErrorCode | Integer | Error Code | 100 |
Errors->ErrorMessage | String | Error Message | Success |
Success
{ "Success": { "SuccessMsg": "Room Assignment is successfully done for Booking RES101,RES112-1. " }, "Errors": { "ErrorCode": "0", "ErrorMessage": "Success" } }
Only 1 Room Assigned Success
{ "Success": { "SuccessMsg": "Room Assignment is successfully done for Booking RES101" }, "Errors": { "ErrorCode": "111", "ErrorMessage": "Room ID does not belongs to Room Type ID for Booking RES112-1 " } }
Error
{ "Errors": { "ErrorCode": "301", "ErrorMessage": "Unauthorized Request. Please check hotel code and authentication code" } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
108 | Booking ID is missing |
110 | Room ID is missing for Booking |
111 | Room ID does not belongs to Room Type ID for Booking |
112 | You are not allowed to room assign for more than five |
113 | Booking Id does not exist OR Booking status is void/ cancel/ noshow |
114 | Room Type ID is missing for Booking |
115 | Room Type ID does not exist for Booking |
116 | Room Type ID is not matching with Booking |
118 | Invalid Parameter for Booking |
127 | Booking Status is not confirmed. so, there is not possible to assign room to Booking |
129 | Room has already assigned to Booking |
130 | Booking status is checked out. so, there is not possible to assign room to Booking |
131 | Room has been already assigned to other booking. So, room assignment is not possible on Booking |
Bookings
Guest Check In
This API helps you to check in to your reservation. The API can return data in JSON formats. The web service responds to HTTP POST requests.
Note: Maximum Five bookings will be processed at a time.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
HotelCode* | INT(11) | Unique Hotel code | xxxx |
AuthCode* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
Request_Type* | VARCHAR(100) | Request Type | GuestCheckIn |
Reservation-> BookingId* | VARCHAR(150) | Unique Booking Id/Reservation No | 456 or RES-456 |
Reservation-> GuestName * | VARCHAR(250) | Guest Name (same as booking Guest Name) | Yasir P Wayde |
Reservation-> Email * | VARCHAR(250) | Guest Email (same as booking Guest Email) | xxxxxx@example.com |
Reservation-> Address * | VARCHAR(250) | Guest Address | Street – 5, Sector-10, Main road, Mumbai |
Reservation-> Phone * | VARCHAR(25) | Guest Phone number | 91XXXXXXXXXX |
Reservation-> Mobile * | VARCHAR(25) | Guest Mobile number | 91XXXXXXXXXX |
Reservation-> IdentityTypeID | BIGINT(20) | Identity Unique Id | 1234500000000000001 (To get this ID, please check API [Retrieve Identity Type]) https://api.ezeetechnosys.com/#2059 |
Reservation-> IdentityNo | VARCHAR(25) | Identity type number | 123456789 |
Reservation-> IdentityImage | TEXT | Identity image (Encoded Image String) | iVBORw0KGgoAAAANSUhEUgAAABMAAAAWCAIAAACt/zAoAAAAA3NCSVQICAjb4U/gAAAAEHRFWHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQAAAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg== |
Reservation-> GuestImage | TEXT | Guest image (Encoded Image String) | iVBORw0KGgoAAAANSUhEUgAAABMAAAAWCAIAAACt/zAoAAAAA3NCSVQICAjb4U/gAAAAEHRFWHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQAAAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg== |
Reservation-> GuestSignature | TEXT | Guest Signature image (Encoded Image String) | iVBORw0KGgoAAAANSUhEUgAAABMAAAAWCAIAAACt/zAoAAAAA3NCSVQICAjb4U/gAAAAEHRFWHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQAAAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg== |
Reservation-> TaxationId | VARCHAR(155) | Registration number | 123456789 |
Request
1.For Single Booking Request
{ "RES_Request": { "Request_Type": "GuestCheckIn", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxxxxxxxxxxxxx" }, "Reservation": [ { "BookingId": "331", "GuestName": "XXXXXXXXX", "Email": "xxxxxx@example.com", "Address": "XXXXX road", "Phone": "xxxxxxxxx", "Mobile": "xxxxxxxxx", "IdentityTypeID": "1234500000000000001", "IdentityNo": "xxxxxx", "IdentityImage": "iVBORw0KGgoAAAANSUhEUgAAABMAAAAWCAIAAACt/zAoAAAAA 3NCSVQICAjb4U/gAAAAEHRF WHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQA AAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg==", "GuestImage": "iVBORw0KGgoAAAANSUhEUgAAABMAAA AWCAIAAACt/zAoAAAAA3NCSVQICAjb4U/gAAAAEHRFWHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQAAAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg==", "GuestSignature": "iVBORw0KGgoAAAANSUhEUgAAABMAAAAWCAIAAACt/zAoAAAAA3NC SVQICAjb4U/gAAAAEHRFWHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQAAAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg==", "TaxationId": "xxxxx" } ] } }
2.For Multiple Booking Request
{ "RES_Request": { "Request_Type": "GuestCheckIn", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxxxxxxxxxxxxx" }, "Reservation": [ { "BookingId": "333-1", "GuestName": "XXXXXXXXX", "Email": "xxxxxx@example.com", "Address": "XXXXX road", "Phone": "xxxxxxxxx", "Mobile": "xxxxxxxxx", "IdentityTypeID": "1234500000000000001", "IdentityNo": "xxxxxx", "IdentityImage": "iVBORw0KGgoAAAANSUhEUgAAABMAAAAWCAIAAACt/zAoAAAAA 3NCSVQICAjb4U/gAAAAEHRF WHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQA AAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg==", "GuestImage": "iVBORw0KGgoAAAANSUhEUgAAABMAAA AWCAIAAACt/zAoAAAAA3NCSVQICAjb4U/gAAAAEHRFWHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQAAAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg==", "GuestSignature": "iVBORw0KGgoAAAANSUhEUgAAABMAAAAWCAIAAACt/zAoAAAAA3NC SVQICAjb4U/gAAAAEHRFWHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQAAAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg==", "TaxationId": "xxxxx" }, { "BookingId": "333-2", "GuestName": "XXXXXXXXX", "Email": "xxxxxx@example.com", "Address": "XXXXXXXXX road", "Phone": "xxxxxxxxx", "Mobile": "xxxxxxxxx", "IdentityTypeID": "1234500000000000001", "IdentityNo": "xxxxxx", "IdentityImage": "iVBORw0KGgoAAAANSUhEUgAAABMAAAAWCAIAAACt/zAoAAAAA 3NCSVQICAjb4U/gAAAAEHRF WHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQA AAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg==", "GuestImage": "iVBORw0KGgoAAAANSUhEUgAAABMAAA AWCAIAAACt/zAoAAAAA3NCSVQICAjb4U/gAAAAEHRFWHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQAAAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg==", "GuestSignature": "iVBORw0KGgoAAAANSUhEUgAAABMAAAAWCAIAAACt/zAoAAAAA3NC SVQICAjb4U/gAAAAEHRFWHRTb2Z0d2FyZQBTaHV0dGVyY4LQCQAAAFRJREFUOMtj/Pr1KwNZgImBXDBSdLLglz5268P0PY+fvf/1+ccfYnX+/fd/xt4nCw89I9m15x98xqMNn85Fh5+RGUK3nn8lU+e7r39G09CoTtrqBAB1MiHSwHyEmgAAAABJRU5ErkJggg==", "TaxationId": "xxxxx" } ] } }
Response
Name | Data Type | Description | Example |
Success-> SuccessMsg | String | Success Message | Successfully Done |
Success-> GuestRegistrationCards-> BookingId | String | Booking Id | 331 |
Success-> GuestRegistrationCards-> GRCardNo | String | GR Card Number | 34 |
Errors->ErrorCode | integer | Error Code | 0 |
Errors->ErrorMessage | String | Error Message | Success |
Success
1.Full operation is successfully completed { "Success": { "SuccessMsg": "Guest Check In successfully for Booking 331", "GuestRegistrationCards": [ { "BookingId": "331", "GRCardNo": "34" } ] }, "Errors": [ { "ErrorCode": "0", "ErrorMessage": "Success" } ] } 2.Full operation is successfully completed for multiple booking { "Success": { "SuccessMsg": "Guest Check In successfully for Booking 333-1,333-2", "GuestRegistrationCards": [ { "BookingId": "333-1", "GRCardNo": "34" }, { "BookingId": "333-2", "GRCardNo": "35" } ] }, "Errors": [ { "ErrorCode": "0", "ErrorMessage": "Success" } ] } 3.In case some bookings are successfully checked in and some have errors for multiple bookings { "Success": { "SuccessMsg": "Guest Check In successfully for Booking 331-2,332", "GuestRegistrationCards": [ { "BookingId": "331-2", "GRCardNo": "34" }, { "BookingId": "332", "GRCardNo": "35" } ] }, "Error": [ { "ErrorCode": 128, "ErrorMessage": "Guest has already checked in. So guest check in not performed for Booking 331-1" } ] }
Error
{ "Error": [ { "ErrorCode": 100, "ErrorMessage": "Missing required parameters." } ] }
Error Codes
Error Code | Error Name |
100 | Missing required parameters. |
500 | Error occurred during processing |
501 | Error occurred during CheckIn processing |
502 | Request Type is missing |
600 | Something went wrong! |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive. |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
110 | Booking ID is missing in Reservation block |
111 | Identity Image string should be in base64_encoded format, So Identity Image not uploaded for booking |
112 | Booking Details : GuestName, Address, Email, Phone, Mobile is mandatory to process your checkin request. So guest check in not performed for booking |
113 | We don’t find this reservation in our system. So guest check in not performed for booking. |
114 | Guest Image string should be in base64_encoded format, So Guest Image not uploaded for booking |
115 | Guest Signature string should be in base64_encoded format, So Guest Signature not uploaded for booking |
116 | Room is not assigned, so guest check in not performed for booking |
117 | Room is dirty, so guest check in not performed for booking |
118 | Invalid Fields |
119 | Invalid Email address For Booking |
120 | <Fields> – Compulsory Fields in order to process for check in |
121 | Guest Data is not updated For Booking |
122 | The IdentityTypeID is not matching with Hotel Data for Booking |
123 | Guest Identity Image is not uploaded For Booking |
124 | Guest Image is not uploaded For Booking |
125 | Guest Signature is not uploaded For Booking |
126 | Today is not a check in date. So guest check in not performed for Booking |
127 | Booking Status is not confirmed. So guest check in not performed for Booking |
128 | Guest has already checked in. So guest check in not performed for Booking |
129 | You are not allowed to check in for more than five bookings. |
130 | Booking status is check out. So guest check in not performed for Booking |
133 | Room is occupied or not checked-out |
Bookings
Add Guest Profile to Bookings
This API helps you to Add Sharer data (name, phone, mobile, email, etc). The API can return data in JSON formats. The web service responds to HTTP POST requests.
Note : Maximum Five sharers will only be processed at a time.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
HotelCode* | INT(11) | Unique Hotel code | xxxx |
AuthCode* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
Request_Type* | VARCHAR(100) | Request Type | AddSharer |
Sharers->BookingId* | VARCHAR(255) | Unique Booking Id/Reservation No | 456 |
Sharers->Salutation | VARCHAR(100) | Salutation | Mr. |
Sharers->FirstName* | VARCHAR(500) | First Name | xxxxxx |
Sharers->LastName* | VARCHAR(500) | Last Name | xxxxxx |
Sharers->Gender* | VARCHAR(25) | Male/Female | Male/Female |
Sharers->Type* | VARCHAR(25) | For Update Type (Adult/Child) | Adult |
Sharers->DateOfBirth | DATE | Date Of Birthformat: YYYY-MM-DD | 1985-05-05 |
Sharers->SpouseDateOfBirth | DATE | Spouse date of birthformat: YYYY-MM-DD | 1987-01-25 |
Sharers->WeddingAnniversary | DATE | Wedding anniversary dateformat: YYYY-MM-DD | 1987-10-05 |
Sharers->Address | VARCHAR(1000) | Address | 500 Kingston |
Sharers->City | VARCHAR(100) | Name of city | Toronto |
Sharers->State | VARCHAR(100) | State name | Ontario |
Sharers->Country | VARCHAR(100) | Country name | Canada (for country https://api.ezeetechnosys.com/#589 |
Sharers->Nationality | VARCHAR(100) | Nationality | India (for country https://api.ezeetechnosys.com/#589) |
Sharers->Zipcode | Integer(11) | zip code | 123456 |
Sharers->Phone | Integer(20) | Phone number | 1234567890 |
Sharers->Mobile | Integer(20) | Mobile number | 1234567890 |
Sharers->Fax | Integer(20) | Fax number | 1234567890 |
Sharers->Email* | VARCHAR(255) | Email id | abc@xyz.com |
Sharers->RegistratioNo | VARCHAR(255) | Registration number | 12345 |
Sharers->IdentityId | BIGINT(20) | Identity unique Id | 1234500000000000001 |
Sharers->IdentityNo | VARCHAR(255) | Identity type number | 123456789 |
Sharers->ExpiryDate | DATE | Expiry dateformat: YYYY-MM-DD | 2022-05-02 |
Request
1.For Single Booking Request { "RES_Request": { "Request_Type": "AddSharer", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" }, "Sharers": [{ "BookingId": "RES101", "Salutation": "Ms.", "FirstName": "Hexvi.S.", "LastName": "Shaby", "Gender": "Female", "Type": "Adult", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "Germany", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "RegistrationNo": "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "" } ] } } 2.For Multiple Booking Request { "RES_Request": { "Request_Type": "AddSharer", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" }, "Sharers": [{ "BookingId": "RES102", "Salutation": "Ms.", "FirstName": "Willi", "LastName": "Crooswoth", "Gender": "Female", "Type": "Adult", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "Germany", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "RegistrationNo": "", "IdentityTypeID": "2700000000000001", "IdentityNo": "12345667765", "ExpiryDate": "" }, { "BookingId": "RES112", "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "Type": "Adult", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "Germany", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "RegistrationNo": "", "IdentityTypeID": "2700000000000001", "IdentityNo": "12345667765", "ExpiryDate": "" } ] } }
Response
Name | Data Type | Description | Example |
Success->SuccessMsg | String | Success Message | Successfully Done |
Errors->ErrorCode | integer | Error Code | 100 |
Errors->ErrorMessage | String | Error Message | Success |
Success
1.Full operation is successfully completed { "Success": { "SuccessMsg": "Sharer is successfully added for Booking RES101" }, "Errors": { "ErrorCode": "0", "ErrorMessage": "Success" } } 2.Full operation Is successfully completed for multiple booking { "Success": { "SuccessMsg": "Sharer is successfully added for Booking RES101,RES112" }, "Errors": { "ErrorCode": "0", "ErrorMessage": "Success" } } 3.In case some booking are successfully added and some have errors for multiple bookings { "Success": { "SuccessMsg": "Sharer is successfully added for Booking RES101" }, "Errors": [ { "ErrorCode": "114", "ErrorMessage": "Country not properly added, it should be according to our database for Booking : RES112" } ] }
Error
{ "Errors": { "ErrorCode": "615", "ErrorMessage": "Unauthorized Request: This request is not valid." } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Invalid Request Type |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
615 | Unauthorized Request: This request is not valid. |
600 | Something went wrong. please try again. Booking |
110 | BookingId is missing |
111 | You cannot add more sharers as the maximum limit for adults reached for the type of room offered, so adding Sharer failed for Booking |
112 | You cannot add more sharers as the maximum limit for children reached for the type of room offered, so adding Sharer failed for Booking |
121 | Either firstname/lastName or Email is mandatory to process your request for Booking |
114 | Country/Nationality is not properly added, it should be according to our database for Booking |
115 | Invalid field <field> for Booking |
116 | Invalid value “<value>” for field “<field name>” for Booking |
113 | We don’t find this reservation in our system. So you can’t add guest for Booking |
117 | Reservation is canceled,noshow or void. So you can’t add guest for Booking |
118 | Reservation is past checked out. So you can’t add guest for Booking |
120 | Maximum five sharers will be processed at a time |
Bookings
Add Payment
This API will post the payment with cash/bank type paymethods to a particular single or multiple reservation no. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Name | Data Type | Description | Example |
HotelCode* | INT(11) | Unique Hotel code | xxxx |
AuthCode* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
Request_Type* | VARCHAR(100) | Request Type | AddPayment |
Reservation->BookingId* | VARCHAR(100) | Reservation No. | 11-1 or 12 |
Reservation->PaymentId* | INT(20) | Payment Unique id (Click here to get PaymentID) https://api.ezeetechnosys.com/#2048 | 123400000000000007 |
Reservation->CurrencyId* | INT(20) | Currency Unique id (Click here to get CurrencyId) https://api.ezeetechnosys.com/#2048 | 123400000000000001 |
Reservation->Payment* | DECIMAL(19,4) | Amount to pay | 100.00 |
Reservation->Comment | VARCHAR(100) | Comment is optional | Payment for room charges |
Receipt->FolioNo | INT(20) | FolioNo is optional | 302 |
Request
{ "RES_Request": { "Request_Type": "AddPayment", "Authentication": { "HotelCode": "1234", "AuthCode": "xxxxxxxxxxxxxxxx" }, "Reservation": [{ "BookingId": "11-1", "FolioNo": "", //Optional "PaymentId": "123400000000000007", "CurrencyId": "123400000000000001", "Payment": "70", "Comment": "payment" }, { "BookingId": "12", "FolioNo": "302", //Optional "PaymentId": "123400000000000007", "CurrencyId": "123400000000000001", "Payment": "200", "Comment": "payment" }] } }
Parameter
Response
Name | Data Type | Description | Example |
Receipt->BookingId | varchar | Reservation No. | 12 |
Receipt->ReceiptNo | Integer | Receipt No. | 230 |
Success
{ "Success": { "SuccessMsg": "Payment done successfully for booking 11-1, 12", "Receipt": [ { "BookingId": "11-1", "ReceiptNo": "1521,1524" }, { "BookingId": "12", "ReceiptNo": "1522,1523" } ] }, "Errors":[ { "ErrorCode": "0", "ErrorMessage": "Success" } ] }
Success/Error:
{ "Success": { "SuccessMsg": "Payment done successfully for booking 12", "Receipt": [ { "BookingId": "12", "ReceiptNo": "232" } ] }, "Errors": [ { "ErrorCode": "113", "ErrorMessage": "We don't find this reservation in our system. So payment not processed for booking 13" } ] }
Error
{ "Errors": [ { "ErrorCode": "106", "ErrorMessage": "Payment amount is missing or invalid payment amount for booking 11-1" } ] }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
103 | Booking ID is missing |
104 | Payment Id is missing for booking |
105 | Currency Id is missing for booking |
106 | Payment amount is missing or invalid payment amount for booking |
108 | Error in folio. |
109 | Maximum 10 bookings are allowed at a time. |
110 | Payment ID not valid |
114 | Currency is not valid for booking |
115 | Amount is exceeded than folio balance for booking |
116 | Invalid parameter for booking |
113 | We don’t find this reservation in our system. So payment not processed for booking |
117 | Reservation is void. So payment not processed for booking |
118 | Reservation is past checked out. So payment not processed for booking |
119 | Invalid folio no for booking |
Bookings
Guest Data Update
This API helps you to update guest data (name, phone, mobile, email, etc) and upload documents (guest identity, guest signature, guest image, and voucher image). The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
HotelCode* | INT(11) | Unique Hotel code | xxxx |
AuthCode* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
Request_Type* | VARCHAR(100) | Request Type | UploadDocument |
BookingId* | VARCHAR(255) | Unique Booking Id/Reservation No | 456 |
FirstName* | VARCHAR(500) | First Name | Torben |
LastName* | VARCHAR(500) | Last Name | L. Schou |
Email* | VARCHAR(255) | Email Id | abc@xyz.com |
UpdateSinglebooking | INT(11) | It is an optional field but please set 1 If you want to update guest data for a single booking. | Value : 1 or 0 For ex: Group Booking: 150 No of Booking: 2 ResNo = 150-1 | Guest = Mr Sanjay ResNo = 150-2 | Guest = Mr Sanjay -> If you want to update ResNo = 150-2 and Mr. Sanjay to Mr. Bharat, you can do it using this parameter. |
UpdateGuestData->Salutation | VARCHAR(100) | Salutation | Mr |
UpdateGuestData->FirstName | VARCHAR(500) | For Update First Name | Torben |
UpdateGuestDat->LastName | VARCHAR(500) | For Update Last Name | L. Schou |
UpdateGuestData->Gender | VARCHAR(25) | For Update Gender | Male |
UpdateGuestData->Type | For Update Type (Adult/Child) | Aduit | |
UpdateGuestData->DateOfBirth | DATE | Date Of Birth | 1985-05-05 |
UpdateGuestData->SpouseDateOfBirth | DATE | Spouse Date Of Birth | 1987-01-25 |
UpdateGuestData->WeddingAnniversary | DATE | Wedding Anniversary Date | 1987-10-05 |
UpdateGuestData->Address | VARCHAR(4000) | Address | 500 Kingston |
UpdateGuestData->City | VARCHAR(255) | Name of City | Toronto |
UpdateGuestData->State | VARCHAR(255) | State name | Ontario |
UpdateGuestData->Country | VARCHAR(255) | Country name | Canada (for country https://api.ezeetechnosys.com/#589) |
UpdateGuestData->Nationality | VARCHAR(255) | Nationality | India (for country https://api.ezeetechnosys.com/#589) |
UpdateGuestData->Zipcode | Integer(11) | zip code | 123456 |
UpdateGuestData->Phone | Integer(20) | Phone number | 1234567890 |
UpdateGuestData->Mobile | Integer(20) | Mobile Number | 1234567890 |
UpdateGuestData->Fax | Integer(20) | Fax number | 1234567890 |
UpdateGuestData->Email | VARCHAR(255) | Email id | abc@xyz.com |
UpdateGuestData->RegistrationNo | VARCHAR(255) | Registration Number | 12345 |
UpdateGuestData->IdentityTypeID | BIGINT(20) | Identity Unique Id | 1234500000000000001 (To get this ID, please check API [Retrieve Identity Type]) https://api.ezeetechnosys.com/#2059 |
UpdateGuestData->IdentityNo | VARCHAR(255) | Identity type number | 123456789 |
UpdateGuestData->ExpiryDate | DATE | Expiry Date | 2022-05-02 |
Documents->Type | Integer(1) | Type Of Document Upload | 1 = Identity, 2 = Signature, 3 = Guest Image, 4 = Guest Vouchers |
Documents->Images | String | Encoded Image String | Alpha-numeric String |
Request
1.For Single Booking Request { "RES_Request": { "Request_Type": "UploadDocument", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" }, "Reservation": [ { "BookingId": "123", "GuestDetails": [ { "FirstName": "Torben", "LastName": "L. Schou", "Email": "abc@xyz.com", "UpdateSinglebooking":0, //Optional "UpdateGuestData": [ { "Salutation": "Mr.", "FirstName": "Torben", "LastName": "L. Schou", "Gender": "Male", "Type": "Adult", "DateOfBirth": "1985-05-05", "SpouseDateOfBirth": "1987-05-05", "WeddingAnniversary": "1987-10-05", "Address": "500 Kingston", "City": " Toronto", "State": "Ontario", "Country": "Canada", "Nationality": "India", "Zipcode": "123456", "Phone": "1234567890", "Mobile": "1234567890", "Fax": "1234567890", "Email": "abc@xyz.com", "RegistrationNo": "12345", "IdentityTypeID": "1234500000000000001", "IdentityNo": "123456789", "ExpiryDate": "2012-12-02" } ], "Documents": [ { "Type": "1", "Images": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAIAAAC1JZyVAAAAA3NCSVQICAjb4U/gAAAAGXRFWHRTb2Z0d2FyZQBnbm9tZS1zY3JlZW5zaG907wO/PgAAAGtJREFUSIlj/P//PwPtARMd7Bi1ZtSaUWtGrRlm1rAwzr5FkgYFNmZjAbYcQyEHOW7idTEyzLpJosugYLeblIs8D5GKyQ+0aeffEa+YfGvOf/xND2se/PpLD2tIAqPWjFozas2oNaPWDFZrAAbVESQbyOtmAAAAAElFTkSuQmCC" }, { "Type": "2", "Images": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAIAAAC1JZyVAAAAA3NCSVQICAjb4U/gAAAAGXRFWHRTb2Z0d2FyZQBnbm9tZS1zY3JlZW5zaG907wO/PgAAAGtJREFUSIlj/P//PwPtARMd7Bi1ZtSaUWtGrRlm1rAwzr5FkgYFNmZjAbYcQyEHOW7idTEyzLpJosugYLeblIs8D5GKyQ+0aeffEa+YfGvOf/xND2se/PpLD2tIAqPWjFozas2oNaPWDFZrAAbVESQbyOtmAAAAAElFTkSuQmCC" }, { "Type": "3", "Images": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAIAAAC1JZyVAAAAA3NCSVQICAjb4U/gAAAAGXRFWHRTb2Z0d2FyZQBnbm9tZS1zY3JlZW5zaG907wO/PgAAAGtJREFUSIlj/P//PwPtARMd7Bi1ZtSaUWtGrRlm1rAwzr5FkgYFNmZjAbYcQyEHOW7idTEyzLpJosugYLeblIs8D5GKyQ+0aeffEa+YfGvOf/xND2se/PpLD2tIAqPWjFozas2oNaPWDFZrAAbVESQbyOtmAAAAAElFTkSuQmCC" }, { "Type": "4", "Images": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAIAAAC1JZyVAAAAA3NCSVQICAjb4U/gAAAAGXRFWHRTb2Z0d2FyZQBnbm9tZS1zY3JlZW5zaG907wO/PgAAAGtJREFUSIlj/P//PwPtARMd7Bi1ZtSaUWtGrRlm1rAwzr5FkgYFNmZjAbYcQyEHOW7idTEyzLpJosugYLeblIs8D5GKyQ+0aeffEa+YfGvOf/xND2se/PpLD2tIAqPWjFozas2oNaPWDFZrAAbVESQbyOtmAAAAAElFTkSuQmCC" } ] } ] } ] } }
2.For Multiple Booking Request { "RES_Request": { "Request_Type": "UploadDocument", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" }, "Reservation": [ { "BookingId": "123", "GuestDetails": [ { "FirstName": "Torben", "LastName": "L. Schou", "Email": "abc@xyz.com", "UpdateSinglebooking":1, //Optional "UpdateGuestData": [ { "Salutation": "Mr.", "FirstName": "Torben", "LastName": "L. Schou", "Gender": "Male", "Type": "Adult", "DateOfBirth": "1994-03-25", "SpouseDateOfBirth": "1996-05-05", "WeddingAnniversary": "1997-10-18", "Address": "500 Kingston", "City": " Toronto", "State": "Ontario", "Country": "Canada", "Nationality": "India", "Zipcode": "123456", "Phone": "1234567890", "Mobile": "1234567890", "Fax": "1234567890", "Email": "abc@xyz.com", "RegistrationNo": "12345", "IdentityTypeID": "1234500000000000001", "IdentityNo": "123456789", "ExpiryDate": "2021-05-02" } ], "Documents": [ { "Type": "1", "Images": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAIAAAC1JZyVAAAAA3NCSVQICAjb4U/gAAAAGXRFWHRTb2Z0d2FyZQBnbm9tZS1zY3JlZW5zaG907wO/PgAAAGtJREFUSIlj/P//PwPtARMd7Bi1ZtSaUWtGrRlm1rAwzr5FkgYFNmZjAbYcQyEHOW7idTEyzLpJosugYLeblIs8D5GKyQ+0aeffEa+YfGvOf/xND2se/PpLD2tIAqPWjFozas2oNaPWDFZrAAbVESQbyOtmAAAAAElFTkSuQmCC" }, { "Type": "2", "Images": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAIAAAC1JZyVAAAAA3NCSVQICAjb4U/gAAAAGXRFWHRTb2Z0d2FyZQBnbm9tZS1zY3JlZW5zaG907wO/PgAAAGtJREFUSIlj/P//PwPtARMd7Bi1ZtSaUWtGrRlm1rAwzr5FkgYFNmZjAbYcQyEHOW7idTEyzLpJosugYLeblIs8D5GKyQ+0aeffEa+YfGvOf/xND2se/PpLD2tIAqPWjFozas2oNaPWDFZrAAbVESQbyOtmAAAAAElFTkSuQmCC" } ] } ] }, { "BookingId": "456", "Guest Details": [ { "FirstName": "Daryl", "LastName": "S. Coleman", "Email": "pqr@xyz.com", "UpdateSinglebooking":0, //Optional "UpdateGuestData": [ { "Salutation": "Mr.", "FirstName": "Daryl", "LastName": "S. Coleman", "Gender": "Male", "Type": "Adult", "DateOfBirth": "1998-10-21", "SpouseDateOfBirth": "2000-07-10", "WeddingAnniversary": "2001-01-20", "Address": "500 Kingston", "City": " Balimo", "State": "Papua", "Country": "Indonesia", "Nationality": "India", "Zipcode": "123456", "Phone": "1234567890", "Mobile": "1234567890", "Fax": "1234567890", "Email": "pqr@xyz.com", "RegistrationNo": "12345", "IdentityTypeID": "1234500000000000001", "IdentityNo": "123456789", "ExpiryDate": "2023-07-12" } ], "Documents": [ { "Type": "1", "Images": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAIAAAC1JZyVAAAAA3NCSVQICAjb4U/gAAAAGXRFWHRTb2Z0d2FyZQBnbm9tZS1zY3JlZW5zaG907wO/PgAAAGtJREFUSIlj/P//PwPtARMd7Bi1ZtSaUWtGrRlm1rAwzr5FkgYFNmZjAbYcQyEHOW7idTEyzLpJosugYLeblIs8D5GKyQ+0aeffEa+YfGvOf/xND2se/PpLD2tIAqPWjFozas2oNaPWDFZrAAbVESQbyOtmAAAAAElFTkSuQmCC" }, { "Type": "2", "Images": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAIAAAC1JZyVAAAAA3NCSVQICAjb4U/gAAAAGXRFWHRTb2Z0d2FyZQBnbm9tZS1zY3JlZW5zaG907wO/PgAAAGtJREFUSIlj/P//PwPtARMd7Bi1ZtSaUWtGrRlm1rAwzr5FkgYFNmZjAbYcQyEHOW7idTEyzLpJosugYLeblIs8D5GKyQ+0aeffEa+YfGvOf/xND2se/PpLD2tIAqPWjFozas2oNaPWDFZrAAbVESQbyOtmAAAAAElFTkSuQmCC" }, { "Type": "3", "Images": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAIAAAC1JZyVAAAAA3NCSVQICAjb4U/gAAAAGXRFWHRTb2Z0d2FyZQBnbm9tZS1zY3JlZW5zaG907wO/PgAAAGtJREFUSIlj/P//PwPtARMd7Bi1ZtSaUWtGrRlm1rAwzr5FkgYFNmZjAbYcQyEHOW7idTEyzLpJosugYLeblIs8D5GKyQ+0aeffEa+YfGvOf/xND2se/PpLD2tIAqPWjFozas2oNaPWDFZrAAbVESQbyOtmAAAAAElFTkSuQmCC" }, { "Type": "4", "Images": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAIAAAC1JZyVAAAAA3NCSVQICAjb4U/gAAAAGXRFWHRTb2Z0d2FyZQBnbm9tZS1zY3JlZW5zaG907wO/PgAAAGtJREFUSIlj/P//PwPtARMd7Bi1ZtSaUWtGrRlm1rAwzr5FkgYFNmZjAbYcQyEHOW7idTEyzLpJosugYLeblIs8D5GKyQ+0aeffEa+YfGvOf/xND2se/PpLD2tIAqPWjFozas2oNaPWDFZrAAbVESQbyOtmAAAAAElFTkSuQmCC" } ] } ] } ] } }
Response
Name | Data Type | Description | Example |
Success->SuccessMsg | String | Success Message | Successfully Done |
Errors>ErrorCode | integer | Error Code | 100 |
Errors>ErrorMessage | String | Error Message | Success |
Success
1.Full Operation Is Successfully Completed { "Success": { "SuccessMsg": "Guest Data/Document successfully uploaded for Booking : 123" }, "Error": { "ErrorCode": "0", "ErrorMessage": "Success" } }
2.Full Operation Is Successfully Completed For Multiple Booking { "Success": { "SuccessMsg": "Guest Data/Document successfully uploaded for Booking : 123,456" }, "Error": { "ErrorCode": "0", "ErrorMessage": "Success" } }
Error
{ "Errors": { "ErrorCode": "301", "ErrorMessage": "Unauthorized Request. Please check hotel code and authentication code" } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
110 | Booking ID is missing |
111 | Guest Identity Image String should be in base64_encoded format, So Document is not uploaded for BookingId : 123, Guest name : Torben L. Schou Guest Signature Image String should be in base64_encoded format, So Document is not uploaded for BookingId : 123, Guest name : Torben L. Schou Guest Image String should be in base64_encoded format, So Document is not uploaded for BookingId : 123, Guest name : Torben L. Schou Guest Voucher Image String should be in base64_encoded format, So Document is not uploaded for BookingId : 123, Guest name : Torben L. Schou |
112 | Identity Information (Type, No) is compulsory to process your request |
113 | Either First Name/Last Name or Email is mandatory to process your request |
115 | The Identity Type ID is not matching with Hotel Data for BookingId : 123, Guest name : Torben L. Schou |
116 | Invalid BookingId |
117 | Guest Email : abc@xyz.com Not Exist For BookingId : 123, Guest name : Torben L. Schou Guest Name : Torben L. Schou is not exist For BookingId : 123 |
118 | Guest Data is not updated For BookingId : 123 |
119 | Missing Parameter OR Invalid Parameter : UpdateGuestData For BookingId : 123 Missing Parameter OR Invalid Parameter : GuestDetails For BookingId : 123 |
120 | Invalid Date Format. Please enter YYYY-MM-DD For BookingId : 123, Guest name : Torben L. Schou |
121 | Invalid Fields : Cities,States For BookingId : 123, Guest name : Torben L. Schou |
122 | Country Name is not matched with our given country name for BookingId : 123, Guest name : Torben L. Schou |
123 | Nationality Name is not matched with our given country name for BookingId : 123, Guest name : Torben L. Schou |
124 | Maximum 5 booking data update for single request |
125 | Please Contact to reception for update profile For BookingId : 123 |
126 | Invalid Email address For BookingId : 123, Guest name : Torben L. Schou |
127 | Given BookingId : 123 is checkout booking Given BookingId : 123 is void booking Given BookingId : 123 is cancelled booking Given BookingId : 123 is no show booking |
128 | Guest name : Torben L. Schou AND Customer Email : abc@xyz.com is repeat same profile multiple times For BookingId : 123 |
Configuration
Retrieve Identity Type
This API will give you all active Identity Types (Passport, Pancard, etc) available in the hotel. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
Request_Type * | VARCHAR(100) | Request Type | RetrieveIdentityType |
Request
{ "RES_Request": { "Request_Type": "RetrieveIdentityType", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" } } }
Response
Name | Data Type | Description | Example |
IdentityType->IdentityTypeID | Integer | Identity Type Unique id | 1234500000000000001 |
IdentityType->Name | String | Identity Type Name | Passport,Driving License |
Success
{ "Success": { "IdentityType": [ { "IdentityTypeID": "1234500000000000001", "Name": "Passport" }, { "IdentityTypeID": "1234500000000000002", "Name": "Driving License" } ] }, "Errors": { "ErrorCode": "0", "ErrorMessage": "Success" } }
Error
{ "Errors": { "ErrorCode": "301", "ErrorMessage": "Unauthorized Request. Please check hotel code and authentication code" } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
203 | No Data Found |
Configuration
Retrieve Pay Methods
This API will give you all the pay methods available in the hotel. You need to send only active pay methods of the hotel. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
Request_Type * | VARCHAR(100) | Request Type | RetrievePayMethods |
Request
{ "RES_Request": { "Request_Type": "RetrievePayMethods", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" } } }
Response
Name | Data Type | Description | Example |
PayMethods->PayMethodID | Integer | Pay Method Unique id | 1234500000000000001 |
PayMethods->PaymentID | String | Payment Unique id | 1234500000000000001 |
PayMethods->Name | String | Pay Method Name | Cash |
PayMethods->ShortCode | String | Pay Method Short Code | Cash |
PayMethods->Type | String | Pay Method Type | Cash,Bank |
PayMethods->CardProcessing | Integer | Card Processing | 0 |
PayMethods->SurchargeApplicable | String | Surcharge Applicable | 1 |
PayMethods->SurchargeType | String | Surcharge Type | FlatPercent,Amount |
PayMethods->SurchargeValue | Decimal | Surcharge Value | 5 |
PayMethods->SurchargeID | Integer | Surcharge Unique ID | 1234500000000000001 |
PayMethods->SurchargeName | String | Surcharge Name | Surcharge |
Success
{ "Success": { "PayMethods": [ { "PayMethodID": "1234500000000000001", "PaymentID": "1234500000000000001", "Name": "Cash", "ShortCode": "Cash", "Type": "Cash", "CardProcessing": "0", "SurchargeApplicable": "1", "SurchargeType": "FlatPercent", "SurchargeValue": "5", "SurchargeID": "1234500000000000001", "SurchargeName": "Surcharge" }, { "PayMethodID": "1234500000000000002", "PaymentID": "1234500000000000002", "Name": "Cheque", "ShortCode": "Chq", "Type": "Bank", "CardProcessing": "0", "SurchargeApplicable": "0", "SurchargeType": "", "SurchargeValue": "", "SurchargeID": "", "SurchargeName": "" } ] }, "Errors": { "ErrorCode": "0", "ErrorMessage": "Success" } }
Error
{ "Errors": { "ErrorCode": "301", "ErrorMessage": "Unauthorized Request. Please check hotel code and authentication code" } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
203 | Payment Methods are not available in this hotel |
Configuration
Retrieve Currency
This API will give you all the currencies available in the hotel. You need to send only active currency of the hotel. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
Request_Type * | VARCHAR(100) | Request Type | RetrieveCurrency |
Request
{ "RES_Request": { "Request_Type": "RetrieveCurrency", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" } } }
Response
Name | Data Type | Description | Example |
CurrencyList->CurrencyID | Integer | Currency Unique id | 1234500000000000001 |
CurrencyList->Country | String | Country name | India |
CurrencyList->Currency | String | Currency Name | Rupees |
CurrencyList->CurrencyCode | String | Currency Code | INR |
CurrencyList->Sign | String | Currency sign | ₹ |
CurrencyList->DigitsAfterDecimal | Integer | Currency Digits After Decimal | 2 |
CurrencyList->IsBaseCurrency | String | Is Base Currency | 0,1 |
CurrencyList->ExchangeRate | Decimal | Currency Exchange Rate | 15.0000 |
Success
{ "Success": { "CurrencyList": [ { "CurrencyID": "1234500000000000001", "Country": "Argentina", "Currency": "Dollar ARS", "CurrencyCode": "ARS", "Sign": "$", "DigitsAfterDecimal": "2", "IsBaseCurrency": "0", "ExchangeRate": "15.0000" }, { "CurrencyID": "1234500000000000002", "Country": "India", "Currency": "Rupees", "CurrencyCode": "INR", "Sign": "₹", "DigitsAfterDecimal": "2", "IsBaseCurrency": "1", "ExchangeRate": "1.0000" } ] }, "Errors": { "ErrorCode": "0", "ErrorMessage": "Success" } }
Error
{ "Errors": { "ErrorCode": "301", "ErrorMessage": "Unauthorized Request. Please check hotel code and authentication code" } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
203 | No Data Found |
Housekeeping
Unblock room
This API helps to unblock a room thereby making a room available for sale. This API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
---|---|---|---|
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
RoomID * | INT(20) | ID of Room | 123450000000000004 |
RoomtypeID * | INT(20) | ID of RoomType | 123450000000000006 |
FromDate * | Date | From date. [Format: yyyy-mm-dd] | 2020-05-15 |
ToDate * | Date | To date. [Format: yyyy-mm-dd] | 2020-05-16 |
Request
{ "RES_Request": { "Request_Type": "UnblockRoom", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" }, "Rooms": [ { "RoomID": "123450000000000004", "RoomtypeID":"123450000000000006", "FromDate": "2020-05-15", "ToDate": "2020-05-16" }, { "RoomID": "123450000000000004", "RoomtypeID": "123450000000000007", "FromDate": "2020-05-19", "ToDate": "2020-05-22" } ]} }
Response
Name | Data Type | Description | Example |
Success.SuccessMsg | – | Generate Success Response Message | Rooms Unblocked Successfully |
Errors.ErrorCode | – | Response Error Code | 0, 301 etc |
Errors.ErrorMessage | – | Generate Response Message | Unauthorized Request. Please check hotel code and authentication code |
Success
{ "Errors": { "ErrorCode": "0", "ErrorMessage": "Success" }, "Success": { "SuccessMsg": "Rooms Unblocked Successfully" } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
103 | Room ID is missing |
104 | Roomtype ID is missing |
105 | From Date is missing. |
106 | From Date is not a valid date |
107 | To Date is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
108 | (To Date) – To Date is not a valid date |
109 | From Date (From Date) To Date : (To Date) – Please check From and To date. To Date should be greater than fromdate |
110 | Unblock is not allowed for past dates. Your property current working date is (Hoteldate) |
128 | (Room ID) – There is no block on this room, so unblock is not possible. |
Finance
Retrieve Incidental Invoices
This API provides incidental invoices (point of sale) information that can be used in your financial accounts. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
hotel_code* | INT(11) | Unique Hotel code | xxxx |
auth_code* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
fromdate | DATE | From date [Format: yyyy-mm-dd] | 2020-03-01 |
todate | DATE | To date [Format: yyyy-mm-dd] | 2020-03-31 |
requestfor* | VARCHAR(100) | Request Type | XERO_INCIDENTAL_INVOICE |
Request
{ "auth_code": "XXXXXXXXXXXXXXXXXXX", "hotel_code": "XXXX", "fromdate" : "2020-03-01", "todate" : "2020-03-30", "requestfor": "XERO_INCIDENTAL_INVOICE" }
Response
Name | Data Type | Description | Example |
status | String | Response status | Success |
data->type | String | Response type | Incidental Invoice |
tranId | String | Transaction Id | P837-211 |
tran_datetime | Date | Transaction Date | 2020-03-22 |
reference1 | String | Guest Name/City Ledger Name | Jhems |
reference2 | String | Guest Name/City Ledger Name | Jhems |
reference3 | String | Bill Number | 2 |
reference4 | String | ||
reference5 | String | ||
reference6 | String | ||
reference7 | String | ||
reference8 | String | ||
reference9 | String | ||
reference10 | String | ||
reference11 | String | ||
reference12 | String | ||
reference13 | String | ||
reference14 | String | Folio Type (CASH/CREDIT) | CASH / CREDIT |
reference15 | String | ||
reference16 | String | Not Applicable | |
reference17 | String | Identity type of billing contact. If Billing contact is guest, Company Tax ID of guest will be displayed and if Billing contact is company,it will be blank. | Passport |
reference18 | String | Identity number of billing contact. If Billing contact is a guest,the tax id of guest will be displayed and if Billing contact is company,it will be blank | T9305602 |
reference19 | String | Email of billing contact | test@gmail.com |
reference20 | String | Address of billing contact | Near railway station,surat-396380,gujarat,india |
reference21 | String | Telephone of billing contact | 0261242059 |
detail->tran_type | String | Transaction Type (Credit/Debit) | Cr/Dr |
detail->remark | String | Comment | |
detail->voucherno | String | Transaction Voucher No | 777 |
detail->parentid | integer | Parent Id | 1234500000000000002 |
detail->taxper | String | Tax Percentage | 15% |
detail->detailId | integer | Transaction Details Id | 1234500000000000991 |
detail->reference_id | integer | Statically Defined Reference Id | 2 |
detail->reference_value | String | If reference_id is 1, thenValue of reference_value: Room Revenue It means :Value of reference_id:1: Room Revenue2: Extra Charges3: Discount4: Adjustment5: Tax6: Payment Type10: City Ledger | Payment Type, Extra Charges,Guest Ledger, Discount |
detail->sub_reference1_id | integer | Statically Defined Sub Reference Id – 1 | 1 |
detail->sub_reference1_value | String | City Ledger/ Discount, Etc Value | 1 |
detail->sub_reference2_id | integer | Statically Defined Sub Reference Id – 2 | 2 |
detail->sub_reference2_value | String | If Above reference value is of Extra Charges, then Extra Charge ID. If Above reference value is of Discount, then Discount ID. | 1234500000000000002 |
detail->sub_reference3_id | integer | If Above reference value is Room Revenue, then sub_reference3_id is 1 otherwise 0. | 1,0 |
detail->sub_reference3_value | String | If Above reference value is Room Revenue, then sub_reference3_value is 1 otherwise 0. | 1,0 |
detail->sub_reference4_id | integer | If Above reference value is Room Revenue, then sub_reference4_value is 1 otherwise 0. | 1,0 |
detail->sub_reference4_value | String | If Above reference value is Room Revenue, then sub_reference4_value is 1 otherwise 0 | 1,0 |
detail->sub_reference5_id | integer | If Above reference value is Room Revenue, then sub_reference5_id is 5 otherwise 0. | 5, 0 |
detail->sub_reference5_value | String | If sub_reference5_id is 5, thenValue of sub_reference5_id: 1/2/3/4/5 It means:1: Room Charges2: Cancellation Revenue3: Day Use Charges4: Late Checkout Charges5: No Show Revenue If sub_reference5_id is 5, then Value of sub_reference5_id: | 0 |
detail->sub_reference6_id | integer | 0 | |
detail->sub_reference6_value | String | 0 | |
detail->sub_reference7_id | integer | 0 | |
detail->sub_reference7_value | String | 0 | |
detail->sub_reference8_id | integer | 0 | |
detail->sub_reference8_value | String | 0 | |
detail->amount | Decimal | Transaction Amount | 50 |
detail->slabtaxunkid | String | Slab Tax id | 1234500000000000013_1 |
detail->slabtax | String | Slab tax name | CGST |
detail->slab | String | Slab range | 1000-2499-12 |
gross_amount | Decimal | Gross Amount | 50 |
amount_paid | Decimal | Amount Paid | 50 |
balance | Decimal | Account Balance | 0 |
remark | String | Comment of transaction |
Success
{ "status": "Success", "data": [ { "type": "Incidental Invoice", "data": [ { "tranId": "P837-211", "tran_datetime": "2020-03-21", "reference1": "Jhems", "reference2": "Jhems", "reference3": "2", "reference4": "", "reference5": "", "reference6": "", "reference7": "", "reference8": "", "reference9": "", "reference10": "", "reference11": "", "reference12": "", "reference13": "", "reference14": "CASH", "reference15": "", "reference16": "", "reference17": "Passport", "reference18": "T9305602", "reference19": "test@gmail.com", "reference20": "Near railway station, surat-396380,gujarat,india ", "reference21": "0261242059", "detail": [ { "tran_type": "Dr", "remark": "", "voucherno": "43", "parentid": "", "taxper": "", "detailId": "1234500000000000837", "reference_id": 6, "reference_value": "Payment Type", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 2, "sub_reference2_value": "1234500000000000155", "sub_reference3_id": 0, "sub_reference3_value": 0, "sub_reference4_id": 0, "sub_reference4_value": 0, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": 70, "slabtaxunkid": "", "slabtax": "", "slab": "" }, { "tran_type": "Cr", "remark": "", "voucherno": "123", "parentid": "", "taxper": "", "detailId": "1234500000000000836", "reference_id": 2, "reference_value": "Extra Charges", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 2, "sub_reference2_value": "1234500000000000001", "sub_reference3_id": 1, "sub_reference3_value": 1, "sub_reference4_id": 1, "sub_reference4_value": 1, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": "70.0000", "slabtaxunkid": "", "slabtax": "", "slab": "" } ], "gross_amount": 70, "amount_paid": 70, "balance": 0, "remark": "" }, { "tranId": "P991-221", "tran_datetime": "2020-03-22", "reference1": "Jiya", "reference2": "Mark Travels", "reference3": "12", "reference4": "", "reference5": "", "reference6": "", "reference7": "", "reference8": "", "reference9": "", "reference10": "", "reference11": "", "reference12": "", "reference13": "", "reference14": "CREDIT", "reference15": "", "reference16": "", "reference17": "Company Tax ID", "reference18": "", "reference19": "test@gmail.com", "reference20": "Near railway station,surat-396380,gujarat,india", "reference21": "0261242059", "detail": [ { "tran_type": "Cr", "remark": "", "voucherno": "777", "parentid": "", "taxper": "", "detailId": "1234500000000000991", "reference_id": 2, "reference_value": "Extra Charges", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 2, "sub_reference2_value": "1234500000000000002", "sub_reference3_id": 1, "sub_reference3_value": 1, "sub_reference4_id": 1, "sub_reference4_value": 1, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": "1000.0000", "slabtaxunkid": "", "slabtax": "", "slab": "" }, { "tran_type": "Cr", "remark": "water", "voucherno": "123-1", "parentid": "", "taxper": "", "detailId": "1234500000000000994", "reference_id": 2, "reference_value": "Extra Charges", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 2, "sub_reference2_value": "1234500000000000003", "sub_reference3_id": 1, "sub_reference3_value": 1, "sub_reference4_id": 1, "sub_reference4_value": 1, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": "500.0000", "slabtaxunkid": "", "slabtax": "", "slab": "" }, { "tran_type": "Dr", "remark": "xyz", "voucherno": "", "parentid": "", "taxper": "", "detailId": "1234500000000000992", "reference_id": 10, "reference_value": "City Ledger", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 2, "sub_reference2_value": "1234500000000000020", "sub_reference3_id": 0, "sub_reference3_value": 0, "sub_reference4_id": 0, "sub_reference4_value": 0, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": 1000, "slabtaxunkid": "", "slabtax": "", "slab": "" }, { "tran_type": "Dr", "remark": "", "voucherno": "", "parentid": "", "taxper": "", "detailId": "1234500000000000996", "reference_id": 10, "reference_value": "City Ledger", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 2, "sub_reference2_value": "1234500000000000020", "sub_reference3_id": 0, "sub_reference3_value": 0, "sub_reference4_id": 0, "sub_reference4_value": 0, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": 450, "slabtaxunkid": "", "slabtax": "", "slab": "" }, { "tran_type": "Dr", "remark": "", "voucherno": "", "parentid": "1234500000000000994", "taxper": "", "detailId": "1234500000000000995", "reference_id": 3, "reference_value": "Discount", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 2, "sub_reference2_value": "1234500000000000018", "sub_reference3_id": 0, "sub_reference3_value": 0, "sub_reference4_id": 0, "sub_reference4_value": 0, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": 50, "slabtaxunkid": "", "slabtax": "", "slab": "" } ], "gross_amount": 1500, "amount_paid": 1500, "balance": 0, "remark": "" } ] } ] }
Error Codes
Code | Message |
AllFields | All fields are mandatory. |
AuthKey | Authentication Key Is Not Found. |
ReqFor | Invalid Request Format. |
HotelCode | Hotel Code Is Not Found |
Error | Something went wrong! |
Error | Bad Request |
304 | Database Error |
202 | Unauthorized request. Hotel code is not active |
301 | Unauthorized request. Request is not valid for this hotel code [Permission denied] |
303 | Auth Code is inactive. |
Finance
Retrieve Journals
This API provides journal data that can be used in your financial accounts. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
hotel_code* | INT(11) | Unique Hotel code | xxxx |
auth_code* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
fromdate | DATE | From date [Format: yyyy-mm-dd] | 2020-03-01 |
todate | DATE | To date [Format: yyyy-mm-dd] | 2020-03-31 |
requestfor* | VARCHAR(100) | Request Type | XERO_GENERAL_JOURNAL_INFO |
Request
{ "auth_code": "XXXXXXXXXXXXXXXXXXX", "hotel_code": "XXXX", "fromdate" : "2020-03-01", "todate" : "2020-03-30", "requestfor": "XERO_GENERAL_JOURNAL_INFO" }
Response
Name | Data Type | Description | Example |
status | String | Response status | Success |
data->type | String | Response type | Advance Deposit Transfer, Folio Transfer, Cityledger Transfer, Cityledger Commision |
tranId | String | Transaction Id | G1057-221 |
tran_datetime | Date | Transaction Date [Format: yyyy-mm-dd] | 2020-03-22 |
reference1 | Date | Receipt No | 52 |
reference2 | Date | Guest Name | Holder |
reference3 | String | Reservation No | 35 |
reference4 | String | Reservation No | 35 |
reference5 | String | Folio No | 36 |
reference6 | String | Bill No / Invoice No | 39 |
reference7 | String | Bill To | Holder |
reference8 | String | Arrival Date [Format: yyyy-mm-dd] | 2020-03-24 |
reference9 | String | Departure Date [Format: yyyy-mm-dd] | 2020-03-28 |
reference10 | String | Business Source | |
reference11 | String | Travel Agent Voucher No | |
reference12 | String | Market Code | |
reference13 | String | City Ledger Name (For only Cityledger Commision data) | |
reference14 | String | Room Name | 107 |
reference15 | String | Not Applicable | |
reference16 | String | Not Applicable | |
reference17 | String | Identity type of billing contact. If Billing contact is guest , Company Tax ID guest will be displayed and if Billing contact is company,it will be blank. | Passport |
reference18 | String | Identity number of billing contact. If Billing contact is a guest, the tax id of guest will be displayed and if Billing contact is company,it will be blank. | T9305602 |
reference19 | String | Email of billing contact | test@gmail.com |
reference20 | String | Address of billing contact | Near railway station,surat-396380,gujarat,india |
reference21 | String | Telephone of billing contact | 0261242059 |
detail->tran_type | String | Transaction Type (Credit/Debit) | Cr/Dr |
detail->detailId | Integer | Detail Id | 1234500000000000971 |
detail->reference_id | integer | 13 | |
detail->reference_value | String | Transaction Mode | Advance,Payment, Paid Out,Guest Ledger |
detail->sub_ref1_id | integer | 1 | |
detail->sub_ref1_value | String | 1 | |
detail->sub_ref2_id | integer | 2 | |
detail->sub_ref2_value | String | Guest Name, City Ledger Id (For only Cityledger Transfer,Cityledger Commision data) Expense Type Id (For only Cityledger Commision data) | Holder |
detail->sub_ref3_id | integer | 3 | |
detail->sub_ref3_value | String | Business Source Id | 0 |
detail->sub_ref4_id | integer | 4 | |
detail->sub_ref4_value | String | Room Id | 1234500000000000007 |
detail->sub_ref5_id | integer | 5 | |
detail->sub_ref5_value | String | Room Type Id | 1234500000000000002 |
detail->sub_ref6_id | integer | 6 | |
detail->sub_ref6_value | String | Folio No | 36 |
detail->sub_ref7_id | integer | 7 | |
detail->sub_ref7_value | String | Bill To | |
detail->sub_ref8_id | integer | 0 | |
detail->sub_ref8_value | String | 0 | |
detail->amount | Decimal | Transaction Amount | 18930 |
gross_amount | Decimal | Gross Amount | 18930 |
remark | String | Comment of transaction |
Success
{ "status": "Success", "data": [ { "type": "Advance Deposit Transfer", "data": [ { "tranId": "G1057-221", "tran_datetime": "2020-03-25", "reference1": "59", "reference2": "Holder", "reference3": "35", "reference4": "35", "reference5": "36", "reference6": "39", "reference7": "", "reference8": "2020-03-25", "reference9": "2020-03-27", "reference10": "", "reference11": "", "reference12": "", "reference13": "", "reference14": "107", "reference15": "", "reference16": "", "reference17": "", "reference18": "", "reference19": "test@gmail.com", "reference20": "Near railway station ,surat-396380,gujarat,india", "reference21": "0261242059", "detail": [ { "tran_type": "Dr", "detailId": "1234500000000000971", "reference_id": 13, "reference_value": "Advance", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 0, "sub_ref2_value": 0, "sub_ref3_id": 0, "sub_ref3_value": 0, "sub_ref4_id": 0, "sub_ref4_value": 0, "sub_ref5_id": 0, "sub_ref5_value": 0, "sub_ref6_id": 0, "sub_ref6_value": 0, "sub_ref7_id": 0, "sub_ref7_value": 0, "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": 18930 }, { "tran_type": "Cr", "detailId": "1234500000000000971", "reference_id": 8, "reference_value": "Guest Ledger", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "Holder", "sub_ref3_id": 3, "sub_ref3_value": "", "sub_ref4_id": 4, "sub_ref4_value": "1234500000000000007", "sub_ref5_id": 5, "sub_ref5_value": "1234500000000000002", "sub_ref6_id": 6, "sub_ref6_value": "36", "sub_ref7_id": 7, "sub_ref7_value": "", "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": 18930 } ], "gross_amount": 18930, "remark": "" } ] }, { "type": "Folio Transfer", "data": [{ "tranId": "123456", "tran_datetime": "2020-06-06 12:10:00", "reference1": "Folio_Transfer-001", "reference2": "Guest/Person Name", "reference3": "booking no", "reference4": "reservation no", "reference5": "folio no", "reference6": "bill no", "reference7": "Bill to Name", "reference8": "Arrival Date ", "reference9": "Departure Date", "reference10": "Business Source Name", "reference11": "Travel Agent Voucher number - OTA Booking Voucher number", "reference12": "Market Name", "reference13": "", "reference14": "Room Name", "reference15": "", "reference16": "", "reference17": "Guest/Person Identity type or Company Tax Id", "reference18": "Guest/Person Identity number"or Tax Id", "reference19": "Guest/Person or Business Sources Email", "reference20": "Guest/Person or Business Sources Address", "reference21": "Guest/Peron or Business Sources Telephone number", "detail": [ { "tran_type": "Dr", "detailId": "123456-1", "reference_id": "7", "reference_value": "Folio Transfer", "sub_reference1_id": "1", "sub_reference1_value": "1", "sub_reference2_id": "0", "sub_reference2_value": "0", "sub_reference3_id": "0", "sub_reference3_value": "0", "sub_reference4_id": "0", "sub_reference4_value": "0", "sub_reference5_id": "0", "sub_reference5_value": "0", "sub_reference6_id": "0", "sub_reference6_value": "0", "sub_reference7_id": "0", "sub_reference7_value": "0", "sub_reference8_id": "0", "sub_reference8_value": "0", "amount": "81.000" }, { "tran_type": "Cr", "detailId": "123456-1", "reference_id": "8", "reference_value": "Guest Ledger", "sub_reference1_id": "1", "sub_reference1_value": "1", "sub_reference2_id": "2", "sub_reference2_value": "Guest Name", "sub_reference3_id": "3", "sub_reference3_value": "buss01", "sub_reference4_id": "4", "sub_reference4_value": "roomunkid", "sub_reference5_id": "5", "sub_reference5_value": "roomtypeunkid", "sub_reference6_id": "6", "sub_reference6_value": "fn-001", "sub_reference7_id": "7", "sub_reference7_value": "Bill to Name", "sub_reference8_id": "0", "sub_reference8_value": "0", "amount": "81.000" } ], "gross_amount": "81.0000", "remark": "" } ] }, { "type": "Cityledger Transfer", "data": [ { "tranId": "G1056-251", "tran_datetime": "2020-03-25", "reference1": "0", "reference2": "Krey", "reference3": "", "reference4": "", "reference5": "31", "reference6": "33", "reference7": "", "reference8": "", "reference9": "", "reference10": "", "reference11": "", "reference12": "", "reference13": "Booking.com Travel", "reference14": "112", "reference15": "", "reference16": "", "reference17": "Company Tax ID", "reference18": "", "reference19": "test@gmail.com", "reference20": "Near railway station ,surat-396380,gujarat,india", "reference21": "0261242059", "detail": [ { "tran_type": "Dr", "detailId": "1234500000000001056", "reference_id": 10, "reference_value": "City Ledger", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "1234500000000000097", "sub_ref3_id": 0, "sub_ref3_value": 0, "sub_ref4_id": 0, "sub_ref4_value": 0, "sub_ref5_id": 0, "sub_ref5_value": 0, "sub_ref6_id": 0, "sub_ref6_value": 0, "sub_ref7_id": 0, "sub_ref7_value": 0, "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": 4130 }, { "tran_type": "Cr", "detailId": "1234500000000001056", "reference_id": 8, "reference_value": "Guest Ledger", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "Krey", "sub_ref3_id": 3, "sub_ref3_value": "", "sub_ref4_id": 4, "sub_ref4_value": "1234500000000000012", "sub_ref5_id": 5, "sub_ref5_value": "1234500000000000002", "sub_ref6_id": 6, "sub_ref6_value": "31", "sub_ref7_id": 7, "sub_ref7_value": "", "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": 4130 } ], "gross_amount": 4130, "remark": "" } ] }, { "type": "Cityledger Commision", "data": [ { "tranId": "G1081-281", "tran_datetime": "2020-03-28", "reference1": "", "reference2": "Prince", "reference3": "49", "reference4": "49", "reference5": "53", "reference6": "44", "reference7": "", "reference8": "2020-03-24", "reference9": "2020-03-28", "reference10": "Max Travel", "reference11": "", "reference12": "", "reference13": "Max Travel", "reference14": "128", "reference15": "", "reference16": "", "reference17": "Company Tax ID", "reference18": "", "reference19": "test@gmail.com", "reference20": "Near railway station, surat-396380,gujarat,india", "reference21": "0261242059", "detail": [ { "tran_type": "Dr", "detailId": "1234500000000001081", "reference_id": 16, "reference_value": "Paid Out", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "1234500000000000001", "sub_ref3_id": 0, "sub_ref3_value": 0, "sub_ref4_id": 0, "sub_ref4_value": 0, "sub_ref5_id": 0, "sub_ref5_value": 0, "sub_ref6_id": 0, "sub_ref6_value": 0, "sub_ref7_id": 0, "sub_ref7_value": 0, "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": "800.0000" }, { "tran_type": "Cr", "detailId": "1234500000000001081", "reference_id": 10, "reference_value": "City Ledger", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "1234500000000000018", "sub_ref3_id": 0, "sub_ref3_value": 0, "sub_ref4_id": 0, "sub_ref4_value": 0, "sub_ref5_id": 0, "sub_ref5_value": 0, "sub_ref6_id": 0, "sub_ref6_value": 0, "sub_ref7_id": 0, "sub_ref7_value": 0, "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": "800.0000" } ], "gross_amount": "800.0000", "remark": "" } ] } ] }
Error Codes
Code | Message |
AllFields | All fields are mandatory. |
AuthKey | Authentication Key Is Not Found. |
ReqFor | Invalid Request Format. |
HotelCode | Hotel Code Is Not Found |
Error | Something went wrong! |
Error | Bad Request |
304 | Database Error |
202 | Unauthorized request. Hotel code is not active |
301 | Unauthorized request. Request is not valid for this hotel code [Permission denied] |
303 | Auth Code is inactive. |
Finance
Retrieve Inwards Payments
This API provides inwards payments (receipts data) that can be used in your financial accounts. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
hotel_code* | INT(11) | Unique Hotel code | xxxx |
auth_code* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
fromdate | DATE | From date [Format: yyyy-mm-dd] | 2020-03-01 |
todate | DATE | To date [Format: yyyy-mm-dd] | 2020-03-31 |
requestfor* | VARCHAR(100) | Request Type | XERO_GET_RECEIPT_DATA |
Request
{ "auth_code": "XXXXXXXXXXXXXXXXXXX", "hotel_code": "XXXX", "fromdate" : "2020-03-01", "todate" : "2020-03-30", "requestfor": "XERO_GET_RECEIPT_DATA" }
Response
Name | Data Type | Description | Example |
status | String | Response status | Success |
data->type | String | Response type | Advance Deposit, Received From Guest, Received From Cityledger |
tranId | String | Transaction Id | R946-22 |
tran_datetime | Date | Transaction Date [Format: yyyy-mm-dd] | 2020-03-22 |
reference1 | Date | Receipt No (For only Advance Deposit data) | 52 |
reference2 | Date | Guest Name / Cityledger Name | Eliza |
reference3 | String | Reservation No (For only Advance Deposit, Received From Guest data) | 50 |
reference4 | String | Reservation No (For only Advance Deposit, Received From Guest data) | 50 |
reference5 | String | Folio No (For only Advance Deposit, Received From Guest data) | 54 |
reference6 | String | Bill No / Inv. No | 45 |
reference7 | String | Bill To (For only Advance Deposit, Received From Guest data | Eliza |
reference8 | String | Arrival Date Time (For only Advance Deposit, Received From Guest data) | 2020-03-24 |
reference9 | String | Departure Date Time (For only Advance Deposit, Received From Guest data) | 2020-03-28 |
reference10 | String | Travel Agent/ Business Source (For only Advance Deposit, Received From Guest data) | Apex Travels |
reference11 | String | Travel Agent Voucher No (For only Advance Deposit, Received From Guest data) | |
reference13 | String | Room Name (For only Advance Deposit, Received From Guest data) | 108 |
reference14 | String | Folio Type / Settlement Type (CASH/CREDIT) (For only Advance Deposit, Received From Guest data) | CASH |
reference15 | String | ||
reference16 | String | Not Applicable | |
reference17 | String | Identity type of billing contact.If Billing contact is guest,Company tax ID of guest will be displayed and if Billing contact is company, it will be blank | Passport |
reference18 | String | Identity number of billing contact.If Billing contact is a guest,the tax id of guest will be displayed and if Billing contact is company ,it will be blank | T9305602 |
reference19 | String | Email of billing contact | test@gmail.com |
reference20 | String | Address of billing contact | Near railway station, surat – 396380,gujarat, india |
reference21 | String | Telephone of billing contact | 0261242059 |
detail->tran_type | String | Transaction Type (Credit/Debit) | Cr/Dr |
detail->detailId | Integer | Detail Id | 1234500000000000946 |
detail->reference_id | integer | 6 | |
detail->reference_value | String | Transaction Mode | Advance,Payment, Paid Out |
detail->sub_ref1_id | integer | 1 | |
detail->sub_ref1_value | String | 1 | |
detail->sub_ref2_id | integer | 2 | |
detail->sub_ref2_value | String | City Ledger Contact Id, Payment Id Guest Name (For only Received From Guest in Credit transaction type data) | 1234500000000000155 |
detail->sub_ref3_id | integer | 0 | |
detail->sub_ref3_value | String | Business Source Id (For only Received From Guest in Credit transaction type data) | 0 |
detail->sub_ref4_id | integer | 0 | |
detail->sub_ref4_value | String | Room Id (For only Received From Guest in Credit transaction type data) | 0 |
detail->sub_ref5_id | integer | 0 | |
detail->sub_ref5_value | String | Room Type Id (For only Received From Guest in Credit transaction type data) | 0 |
detail->sub_ref6_id | integer | 0 | |
detail->sub_ref6_value | String | Folio No (For only Received From Guest in Credit transaction type data) | 0 |
detail->sub_ref7_id | integer | 0 | |
detail->sub_ref7_value | String | Bill To (For only Received From Guest in Credit transaction type data) | 0 |
detail->sub_ref8_id | integer | 0 | |
detail->sub_ref8_value | String | 0 | |
detail->amount | Decimal | Transaction Amount | 200 |
gross_amount | Decimal | Gross Amount | 200 |
remark | String | Comment of transaction |
Success
{ "status": "Success", "data": [ { "type": "Advance Deposit", "data": [ { "tranId": "R946-22", "tran_datetime": "2020-03-22", "reference1": "52", "reference2": "Eliza, "reference3": "50", "reference4": "50", "reference5": "54", "reference6": "45", "reference7": "Eliza", "reference8": "2020-03-24", "reference9": "2020-03-28", "reference10": "Apex Travels", "reference11": "", "reference13": "108", "reference14": "Cash", "reference15": "", "reference16": "", "reference17": "Company Tax ID", "reference18": "", "reference19": "test@gmail.com", "reference20": "Near railway station,surat-396380,gujarat, india", "reference21": "026142059", "detail": [ { "tran_type": "Dr", "detailId": "1234500000000000946", "reference_id": 6, "reference_value": "Payment", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "1234500000000000155", "sub_ref3_id": 0, "sub_ref3_value": 0, "sub_ref4_id": 0, "sub_ref4_value": 0, "sub_ref5_id": 0, "sub_ref5_value": 0, "sub_ref6_id": 0, "sub_ref6_value": 0, "sub_ref7_id": 0, "sub_ref7_value": 0, "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": "25000.0000" }, { "tran_type": "Cr", "detailId": "1234500000000000946", "reference_id": 13, "reference_value": "Advance", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 0, "sub_ref2_value": 0, "sub_ref3_id": 0, "sub_ref3_value": 0, "sub_ref4_id": 0, "sub_ref4_value": 0, "sub_ref5_id": 0, "sub_ref5_value": 0, "sub_ref6_id": 0, "sub_ref6_value": 0, "sub_ref7_id": 0, "sub_ref7_value": 0, "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": "25000.0000" } ], "gross_amount": "25000.0000", "remark": "" } ] }, { "type": "Received From Guest", "data": [ { "tranId": "R355-21", "tran_datetime": "2020-03-21", "reference1": "39", "reference2": "Loy", "reference3": "42", "reference4": "42", "reference5": "45", "reference6": "20", "reference7": "Loy", "reference8": "2020-03-19", "reference9": "2020-03-21", "reference10": "Apex Travels", "reference11": "", "reference13": "113", "reference14": "Cash", "reference15": "", "reference16": "", "reference17": "Company Tax ID", "reference18": "", "reference19": "test@gmail.com", "reference20": "Near railway station, surat-396380,gujarat,india", "reference21": "026142059", "detail": [ { "tran_type": "Dr", "detailId": "1234500000000000355", "reference_id": 6, "reference_value": "Payment", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "1234500000000000155", "sub_ref3_id": 0, "sub_ref3_value": 0, "sub_ref4_id": 0, "sub_ref4_value": 0, "sub_ref5_id": 0, "sub_ref5_value": 0, "sub_ref6_id": 0, "sub_ref6_value": 0, "sub_ref7_id": 0, "sub_ref7_value": 0, "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": 8310 }, { "tran_type": "Cr", "detailId": "1234500000000000355", "reference_id": 8, "reference_value": "Guest Ledger", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "Loy", "sub_ref3_id": 3, "sub_ref3_value": "1234500000000000010", "sub_ref4_id": 4, "sub_ref4_value": "1234500000000000013", "sub_ref5_id": 5, "sub_ref5_value": "1234500000000000002", "sub_ref6_id": 6, "sub_ref6_value": "45", "sub_ref7_id": 7, "sub_ref7_value": "Loy", "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": 8310 } ], "gross_amount": 8310, "remark": "" } ] }, { "type": "Received From Cityledger", "data": [ { "tranId": "R363-21", "tran_datetime": "2020-03-21", "reference1": "42", "reference2": "Apex Travels", "reference3": "", "reference4": "", "reference5": "", "reference6": "", "reference7": "", "reference8": "", "reference9": "", "reference10": "", "reference11": "", "reference13": "", "reference14": "", "reference15": "", "reference16": "", "reference17": "Company Tax ID", "reference18": "", "reference19": "test@gmail.com", "reference20": "Near railway station,surat-396380,gujarat,india", "reference21": "0261242059", "detail": [ { "tran_type": "Dr", "detailId": "1234500000000000363", "reference_id": 6, "reference_value": "Payment", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "1234500000000000155", "sub_ref3_id": 0, "sub_ref3_value": 0, "sub_ref4_id": 0, "sub_ref4_value": 0, "sub_ref5_id": 0, "sub_ref5_value": 0, "sub_ref6_id": 0, "sub_ref6_value": 0, "sub_ref7_id": 0, "sub_ref7_value": 0, "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": 200 }, { "tran_type": "Cr", "detailId": "1234500000000000363", "reference_id": 10, "reference_value": "Cityledger", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "1234500000000000020", "sub_ref3_id": 0, "sub_ref3_value": 0, "sub_ref4_id": 0, "sub_ref4_value": 0, "sub_ref5_id": 0, "sub_ref5_value": 0, "sub_ref6_id": 0, "sub_ref6_value": 0, "sub_ref7_id": 0, "sub_ref7_value": 0, "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": 200 } ], "gross_amount": 200, "remark": "" } ] } ] }
Error Codes
Code | Message |
AllFields | All fields are mandatory. |
AuthKey | Authentication Key Is Not Found. |
ReqFor | Invalid Request Format. |
HotelCode | Hotel Code Is Not Found |
Error | Something went wrong! |
Error | Bad Request |
304 | Database Error |
202 | Unauthorized request. Hotel code is not active |
301 | Unauthorized request. Request is not valid for this hotel code [Permission denied] |
303 | Auth Code is inactive. |
Finance
Retrieve Outwards Payments
This API provides outwards payments that can be used in your financial accounts. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
hotel_code* | INT(11) | Unique Hotel code | xxxx |
auth_code* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
fromdate | DATE | From date [Format: yyyy-mm-dd] | 2020-03-01 |
todate | DATE | To date [Format: yyyy-mm-dd] | 2020-03-31 |
requestfor* | VARCHAR(100) | Request Type | XERO_GET_PAYMENT_DATA |
Request
{ "auth_code": "XXXXXXXXXXXXXXXXXXX", "hotel_code": "XXXX", "fromdate" : "2020-03-01", "todate" : "2020-03-30", "requestfor": "XERO_GET_PAYMENT_DATA" }
Response
Name | Data Type | Description | Example |
status | String | Response status | Success |
data->type | String | Response type | General Expense, Advance Deposit Refund, Guest Refund, Cityledger Refund |
tranId | String | Transaction Id | P950-221 |
tran_datetime | Date | Transaction Date [Format: yyyy-mm-dd] | 2020-03-22 |
reference1 | String | Bill No / Inv. No (For only General Expenses data) Receipt No (For only Advance Deposit Refund, Guest Refund, Cityledger Refund data) | 12 |
reference2 | String | Guest Name (For only General Expense,Advance Deposit Refund, Guest Refund data) | Johnson |
reference3 | String | Reservation No (For only Advance Deposit Refund, Guest Refund data) | |
reference4 | String | Reservation No (For only Advance Deposit Refund, Guest Refund data) | |
reference5 | String | Folio No (For only Advance Deposit Refund, Guest Refund data) | |
reference6 | String | Bill No / Invoice No | 12 |
reference7 | String | Bill To (For only General Expense,Advance Deposit Refund, Guest Refund data) | Johnson |
reference8 | String | Arrival Date Time (For only Advance Deposit Refund, Guest Refund data) | |
reference9 | String | Departure Date Time (For only Advance Deposit Refund, Guest Refund data) | |
reference10 | String | Business Source Id (For only Advance Deposit Refund, Guest Refund data) | |
reference11 | String | TravelAgent Voucher No (For only Advance Deposit Refund, Guest Refund data) | |
reference12 | String | Market Code Id ( For only Advance Deposit Refund, Guest Refund data) | |
reference13 | String | Room Name (For only Advance Deposit Refund, Guest Refund data) | |
reference14 | String | Folio Type / Settlement Type | CASH |
reference15 | String | ||
reference16 | String | Not Applicable | |
reference17 | String | Identity type of billing contact. If Billing contact is guest,Company Tax ID of guest will be displayed and if Billing contact is company,it will be blank | Passport |
reference18 | String | Identity number of billing contact. If Billing contact is a guest, the tax id of guest will be displayed and if Billing contact is company , it will be blank | T9305602 |
reference19 | String | Email of billing contact | test@gmail.com |
reference20 | String | Address of billing contact | Near railway station surat 396380 gujarat india |
reference21 | String | Telephone of billing contact | 0261242059 |
detail->tran_type | String | Transaction Type (Credit/Debit) | Cr/Dr |
detail->detailId | Integer | Detail Id | 1234500000000000951 |
detail->reference_id | integer | Reference Id | 6 |
detail->reference_value | String | Transaction Mode | Advance,Payment, Paid Out |
detail->sub_reference1_id | integer | Single Ledger Id | 1 |
detail->sub_reference1_value | String | Single Ledger Value | 1 |
detail->sub_reference2_id | integer | 2 | |
detail->sub_reference2_value | String | Expense Type Id, Tax Id (For Only General Expensel ) City Ledger Id, Payment Id (All API) Guest Name (For Only Guest Refund in debit transaction type) | 1234500000000000155 |
detail->sub_reference3_id | integer | 3 | |
detail->sub_reference3_value | String | Business Source Id (For Only Guest Refund in debit transaction type) | 0 |
detail->sub_reference4_id | integer | 4 | |
detail->sub_reference4_value | String | Room Id (For Only Guest Refund in debit transaction type) | 0 |
detail->sub_reference5_id | integer | 5 | |
detail->sub_reference5_value | String | Rate Type Id (For Only Guest Refund in debit transaction type) | 0 |
detail->sub_reference6_id | integer | 6 | |
detail->sub_reference6_value | String | Folio No (For Only Guest Refund in debit transaction type) | 0 |
detail->sub_reference7_id | integer | 7 | |
detail->sub_reference7_value | String | Bill To (For Only Guest Refund in debit transaction type) | 0 |
detail->sub_reference8_id | integer | 8 | |
detail->sub_reference8_value | String | 0 | |
detail->amount | Decimal | Transaction Amount | 1900.0000 |
detail->slabtaxunkid | String | IF General Expense type found then add Slab Tax id | 1234500000000000013_1 |
detail->slabtax | String | IF General Expense type found then add Slab tax name | CGST |
detail->slab | String | IF General Expense type found then add Slab range | 1000-2499-12 |
gross_amount | Decimal | Gross Amount | 0 |
amount_paid | Decimal | Amount Paid (For Only General Expense) | 2242 |
balance | Decimal | Account Balance (For Only General Expense) | 0 |
remark | String | Comment of transaction |
Success
{ "status": "Success", "data": [ { "type": "General Expense", "data": [ { "tranId": "P950-221", "tran_datetime": "2020-03-22", "reference1": "12", "reference2": "Johnson", "reference3": "", "reference4": "", "reference5": "", "reference6": "12", "reference7": "Johnson", "reference8": "", "reference9": "", "reference10": "", "reference11": "", "reference12": "", "reference13": "", "reference14": "CASH", "reference15": "", "reference16": "", "reference17": "Passport", "reference18": "T9305602", "reference19": "test@gmail.com", "reference20": "Near railway station surat 396380 gujarat india", "reference21": "0261242059", "detail": [ { "tran_type": "Cr", "detailId": "1234500000000000951", "reference_id": 6, "reference_value": "Payment", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 2, "sub_reference2_value": "1234500000000000155", "sub_reference3_id": 0, "sub_reference3_value": 0, "sub_reference4_id": 0, "sub_reference4_value": 0, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": 1500, "slabtaxunkid": "", "slabtax": "", "slab": "" }, { "tran_type": "Dr", "detailId": "1234500000000000950", "reference_id": 16, "reference_value": "Paid Out", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 2, "sub_reference2_value": "1234500000000000002", "sub_reference3_id": 0, "sub_reference3_value": 0, "sub_reference4_id": 0, "sub_reference4_value": 0, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": "1500.0000", "slabtaxunkid": "", "slabtax": "", "slab": "" } ], "gross_amount": 1500, "amount_paid": 1500, "balance": 0, "remark": "" } ] }, { "type": "Advance Deposit Refund", "data": [ { "tranId": "P949-221", "tran_datetime": "2020-03-22 00:00:00", "reference1": "53", "reference2": "Eliya", "reference3": "50", "reference4": "50", "reference5": "54", "reference6": "45", "reference7": "Mrs. Eliya", "reference8": "2020-03-24", "reference9": "2020-03-28", "reference10": "Mark Tour and Travels", "reference11": "", "reference12": "", "reference13": "108", "reference14": "", "reference15": "", "reference16": "", "reference17": "Company Tax ID", "reference18": "", "reference19": "test@gmail.com", "reference20": "Near railway station surat 396380 gujarat india", "reference21": "0261242059", "detail": [ { "tran_type": "Dr", "detailId": "1234500000000000948", "reference_id": 13, "reference_value": "Advance", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 0, "sub_reference2_value": 0, "sub_reference3_id": 0, "sub_reference3_value": 0, "sub_reference4_id": 0, "sub_reference4_value": 0, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": 2640 }, { "tran_type": "Cr", "detailId": "1234500000000000948", "reference_id": 6, "reference_value": "Payment", "sub_reference1_id": 1, "sub_reference1_value": 1, "sub_reference2_id": 2, "sub_reference2_value": "1234500000000000155", "sub_reference3_id": 0, "sub_reference3_value": 0, "sub_reference4_id": 0, "sub_reference4_value": 0, "sub_reference5_id": 0, "sub_reference5_value": 0, "sub_reference6_id": 0, "sub_reference6_value": 0, "sub_reference7_id": 0, "sub_reference7_value": 0, "sub_reference8_id": 0, "sub_reference8_value": 0, "amount": 2640 } ], "gross_amount": 2640, "remark": "" } ] }, { "type": "Guest Refund", "data": [{ "tranId": "3", "tran_datetime": "2020-06-06 12:10:00", "reference1": "VOC-003", "reference2": "Guest/Person Name", "reference3": "BKN-13", "reference4": "RN-13", "reference5": "FN-13", "reference6": "BL-13", "reference7": "Bill to Name", "reference8": "2020-06-06", "reference9": "2020-06-07", "reference10": "Business Source Name", "reference11": "OTA Booking Voucher number", "reference12": "Market Name", "reference13": "103", "reference14": "Cash", "reference15": "Credit Number", "reference16": "", "reference17": "Passport", "reference18": "T9305602", "reference19": "test@gmail.com", "reference20": "Near railway station,surat-396380,gujarat,india", "reference21": "0261242059", "detail": [ { "tran_type": "Dr", "detailId": "3-1", "reference_id": "8", "reference_value": "Guest Ledger", "sub_reference1_id": "1", "sub_reference1_value": "1", "sub_reference2_id": "2", "sub_reference2_value": "Guest Name", "sub_reference3_id": "3", "sub_reference3_value": "buss01", "sub_reference4_id": "4", "sub_reference4_value": "1234500000000000150", "sub_reference5_id": "5", "sub_reference5_value": "1234500000000000006", "sub_reference6_id": "6", "sub_reference6_value": "fn-001", "sub_reference7_id": "7", "sub_reference7_value": "Bill to Name", "sub_reference8_id": "0", "sub_reference8_value": "0", "amount": "1780.000" }, { "tran_type": "Cr", "detailId": "3-1", "reference_id": "6", "reference_value": "Payment", "sub_reference1_id": "1", "sub_reference1_value": "1", "sub_reference2_id": "2", "sub_reference2_value": "1234500000000000156", "sub_reference3_id": "0", "sub_reference3_value": "0", "sub_reference4_id": "0", "sub_reference4_value": "0", "sub_reference5_id": "0", "sub_reference5_value": "0", "sub_reference6_id": "0", "sub_reference6_value": "0", "sub_reference7_id": "0", "sub_reference7_value": "0", "sub_reference8_id": "0", "sub_reference8_value": "0", "amount": "1780.000" } ], "gross_amount": "1780.0000", "remark": "" } ] }, { "type": "Cityledger Refund", "data": [{ "tranId": "4", "tran_datetime": "2020-06-06 12:10:00", "reference1": "VOC-004", "reference2": "", "reference3": "", "reference4": "", "reference5": "", "reference6": "", "reference7": "", "reference8": "", "reference9": "", "reference10": "", "reference11": "", "reference12": "", "reference13": "", "reference14": "", "reference15": "", "reference16": "", "reference17": "", "reference18": "", "reference19": "", "reference20": "", "reference21": "", "detail": [ { "tran_type": "Dr", "detailId": "4-1", "reference_id": "10", "reference_value": "City Ledger", "sub_reference1_id": "1", "sub_reference1_value": "1", "sub_reference2_id": "2", "sub_reference2_value": "1234500000000000156", "sub_reference3_id": "0", "sub_reference3_value": "0", "sub_reference4_id": "0", "sub_reference4_value": "0", "sub_reference5_id": "0", "sub_reference5_value": "0", "sub_reference6_id": "0", "sub_reference6_value": "0", "sub_reference7_id": "0", "sub_reference7_value": "0", "sub_reference8_id": "0", "sub_reference8_value": "0", "amount": "2801.000" }, { "tran_type": "Cr", "detailId": "4-1", "reference_id": "6", "reference_value": "Payment", "sub_reference1_id": "1", "sub_reference1_value": "1", "sub_reference2_id": "2", "sub_reference2_value": "1234500000000000158", "sub_reference3_id": "0", "sub_reference3_value": "0", "sub_reference4_id": "0", "sub_reference4_value": "0", "sub_reference5_id": "0", "sub_reference5_value": "0", "sub_reference6_id": "0", "sub_reference6_value": "0", "sub_reference7_id": "0", "sub_reference7_value": "0", "sub_reference8_id": "0", "sub_reference8_value": "0", "amount": "2801.000" } ], "gross_amount": "2801.0000", "remark": "" } ] } ] }
Error Codes
Code | Message |
AllFields | All fields are mandatory. |
AuthKey | Authentication Key Is Not Found. |
ReqFor | Invalid Request Format. |
HotelCode | Hotel Code Is Not Found |
Error | Something went wrong! |
Error | Bad Request |
304 | Database Error |
202 | Unauthorized request. Hotel code is not active |
301 | Unauthorized request. Request is not valid for this hotel code [Permission denied] |
303 | Auth Code is inactive. |
Finance
Retrieve Revenues
This API provides revenue information for a property that can be used in your financial accounts. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
hotel_code* | INT(11) | Unique Hotel code | xxxx |
auth_code* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
fromdate | DATE | From date. [Format: yyyy-mm-dd] | 2020-03-01 |
todate | DATE | To date. [Format: yyyy-mm-dd] | 2020-03-31 |
ischeckout | VARCHAR(300) | It is a flag for check out. | True/False |
requestfor* | VARCHAR(100) | Request Type | XERO_GET_TRANSACTION_DATA |
Request
{ "auth_code": "XXXXXXXXXXXXXXXXXXX", "hotel_code": "XXXX", "fromdate" : "2020-03-01", "todate" : "2020-03-30", "ischeckout" : "true", "requestfor": "XERO_GET_TRANSACTION_DATA" }
Response
Name | Data Type | Description | Example |
record_id | String | Record/Unique Id | S7-18 |
record_date | Date | Record Date | 2020-03-18 |
reference1 | Date | Check In Date [Format: yyyy-mm-dd] | 2020-03-17 |
reference2 | Date | Check Out Date [Format: yyyy-mm-dd] | 2020-03-18 |
reference3 | String | Reservation No | 7 |
reference4 | String | Folio No | 6 |
reference5 | String | Guest Name | Alex Joy |
reference6 | String | 0 | |
reference7 | String | Source | |
reference8 | String | Bill No / Invoice No | 0 |
reference9 | String | Bill To | |
reference10 | String | Voucher No | |
reference11 | String | 0 | |
reference12 | String | 0 | |
reference13 | String | Room No | 103 |
reference14 | String | Room Type | Twin |
reference15 | String | Rate Type | Frequent Traveller |
reference16 | String | Market Code | Airline Crew |
reference17 | String | Identity type of billing contact.If Billing contact is guest,Company Tax ID of guest will be displayed and if Billing contact is company,it will be blank | Passport |
reference18 | String | Identity number of billing contact. If Billing contact is a guest , the tax id of guest will be displayed and if Billing contact is company ,it will be blank | T9305602 |
reference19 | String | Email of billing contact | test@gmail.com |
reference20 | String | Address of billing contact | Near railway station surat 396380 gujarat india |
reference21 | String | Telephone of billing contact | 0261242059 |
detail->detail_record_id | integer | Rental ID | 1234500000000000038 |
detail->detail_record_date | Date | Rental Date | 2020-03-17 |
detail->reference_id | integer | List of Account Reference ID | 1 |
detail->reference_name | String | List of Account Reference Name | |
detail->sub_ref1_id | integer | List of Account Sub Reference ID ‘Single Ledger’ | 1 |
detail->sub_ref1_value | String | List of Account Sub Reference value ‘Always “1” when reference_id = 1 | 1 |
detail->sub_ref2_id | integer | List of Account Sub Reference ID ‘Room Name wise | 2 |
detail->sub_ref2_value | String | List of Account Sub Reference value ‘Room Unique ID | 1234500000000000003 |
detail->sub_ref3_id | integer | List of Account Sub Reference ID ‘Room Type wise | 3 |
detail->sub_ref3_value | String | List of Account Sub Reference value ‘Room Type Unique ID | 1234500000000000005 |
detail->sub_ref4_id | integer | List of Account Sub Reference ID ‘Rate Type wise | 4 |
detail->sub_ref4_value | String | List of Account Sub Reference value ‘Rate Type Unique ID | 1234500000000000003 |
detail->sub_ref5_id | integer | List of Account Sub Reference ID ‘Room Charge wise [Room Rent = 1, Cancellation Charge = 2, Day use = 3, Late checkout = 4 and No show charge = 5] | 5 |
detail->sub_ref5_value | String | List of Account Sub Reference value ‘Room Unique ID’ | 1 |
detail->sub_ref6_id | integer | List of Account Sub Reference ID ‘Slab Tax’ wise | 6 |
detail->sub_ref6_value | String | List of Account Sub Reference value ‘Tax Unique ID’ | |
detail->sub_ref7_id | integer | List of Account Sub Reference ID ‘Source wise’ | 7 |
detail->sub_ref7_value | String | List of Account Sub Reference value ‘Source Unique ID’ | |
detail->sub_ref8_id | integer | List of Account Sub Reference ID ‘Market code wise’ | 8 |
detail->sub_ref8_value | String | List of Account Sub Reference value ‘market Place Unique ID’ | |
detail->amount | String | Amount | 1900.0000 |
detail->taxper | String | Percentage of applied tax definition | |
detail->slabtaxunkid | String | Slab Tax id | 1234500000000000013_1 |
detail->slabtax | String | Slab tax name | CGST |
detail->slab | String | Slab range | 1000-2499-12 |
detail->charge_name | String | Charge name | Laundry |
detail->masterunkid | integer | Unique id | 1234500000000000015 |
detail->parentmasterunkid | integer | Unique id | 1234500000000000014 |
detail->description | String | description | |
detail->Taxtype | String | Tax type | |
detail->posdata | String | POS Data | |
detail->POSTaxName | String | POS Tax name | |
detail->POSTaxPercent | String | POS Tax Percentage | |
gross_amount | Decimal | (rent – rental dis. + rental tax + ex. charges – ex. discount + ex. tax) | 0 |
flat_discount | Decimal | Folio level Discount | 0 |
adjustment_amount | Decimal | Adjustment | 0 |
add_less_amount | Decimal | 0 | |
total_amount | Decimal | (gross_amount – flat_discount + adjustment_amount) | 2242.0000 |
amount_paid | Decimal | Paid Amount | 2242 |
balance | Decimal | (total amount – paid amount) | 0 |
Success
[ { "record_id": "S7-18", "record_date": "2020-03-18", "reference1": "2020-03-17", "reference2": "2020-03-18", "reference3": "7", "reference4": "6", "reference5": "Alex Joy", "reference6": "0", "reference7": "", "reference8": "9", "reference9": "", "reference10": "", "reference11": "0", "reference12": "0", "reference13": "103", "reference14": "Twin", "reference15": "Frequent Traveller", "reference16": "", "reference17": "Passport", "reference18": "T9305602", "reference19": "test@gmail.com", "reference20": "Near railway station surat 396380 gujarat india", "reference21": "0261242059", "detail": [ { "detail_record_id": "1234500000000000038", "detail_record_date": "2020-03-17", "reference_id": 1, "reference_name": "Room Revenue", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "1234500000000000003", "sub_ref3_id": 3, "sub_ref3_value": "1234500000000000005", "sub_ref4_id": 4, "sub_ref4_value": "1234500000000000003", "sub_ref5_id": 5, "sub_ref5_value": 1, "sub_ref6_id": 6, "sub_ref6_value": "1234500000000000171_2", "sub_ref7_id": 7, "sub_ref7_value": "", "sub_ref8_id": 8, "sub_ref8_value": "", "amount": "1900.0000", "taxper": "", "slabtaxunkid": "1234500000000000171_2", "slabtax": "CGST", "slab": "1001-7500.99-12", "charge_name": "Room Charges", "masterunkid": "1234500000000000004", "parentmasterunkid": "", "description": "", "Taxtype": "", "posdata": "", "POSTaxName": "", "POSTaxPercent": "" }, { "detail_record_id": "1234500000000000038", "detail_record_date": "2020-03-17", "reference_id": 5, "reference_name": "Taxes", "sub_ref1_id": 1, "sub_ref1_value": 1, "sub_ref2_id": 2, "sub_ref2_value": "1234500000000000003", "sub_ref3_id": 3, "sub_ref3_value": “1234500000000000171_2”, "sub_ref4_id": 0, "sub_ref4_value": 0, "sub_ref5_id": 0, "sub_ref5_value": 0, "sub_ref6_id": 0, "sub_ref6_value": 0, "sub_ref7_id": 0, "sub_ref7_value": 0, "sub_ref8_id": 0, "sub_ref8_value": 0, "amount": "342.0000", "taxper": "18.0000", "slabtaxunkid": "1234500000000000171_2", "slabtax": "CGST", "slab": "1001-7500.99-6", "charge_name": "CGST", "masterunkid": "1234500000000000004", "parentmasterunkid": "", "description": "", "Taxtype": "", "posdata": "", "POSTaxName": "", "POSTaxPercent": "" } ], "gross_amount": 0, "flat_discount": 0, "adjustment_amount": 0, "add_less_amount": 0, "total_amount": "2242.0000", "amount_paid": 2242, "balance": 0 }, ]
Error Codes
Code | Message |
AllFields | All fields are mandatory. |
AuthKey | Authentication Key Is Not Found. |
ReqFor | Invalid Request Format. |
HotelCode | Hotel Code Is Not Found |
Error | Something went wrong! |
Error | Bad Request |
304 | Database Error |
202 | Unauthorized request. Hotel code is not active |
301 | Unauthorized request. Request is not valid for this hotel code [Permission denied] |
303 | Auth Code is inactive. |
Finance
Retrieve Financial Accounts
This API provides a financial accounts list for a property. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
hotel_code* | INT(11) | Unique Hotel code | xxxx |
auth_code* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
requestfor* | VARCHAR(100) | Request Type | XERO_GET_CONFIG_DATA |
Request
{ "auth_code": "XXXXXXXXXXXXXXXXXXX", "hotel_code": "XXXX", "requestfor": "XERO_GET_CONFIG_DATA" }
Response
Name | Data Type | Description | Example |
descriptionunkid | String | The Id is getting based on below data.If descriptiontype is RATE TYPE, then you will get RATE TYPE ID | 1234500000000000004 |
description | String | The description is getting based on the below data.If descriptiontype is RATE TYPE, then you will get RATE TYPE NAME | Daily |
descriptiontypeunkid | String | It is pre-defined unique Id | 1 |
descriptiontype | String | Description type id and description type name is below listed according to Header Id and name Header-1: Room Revenue 1: SINGLE LEDGER 2: ROOM NAME 3: ROOM TYPE 4: RATE TYPE 5: ROOM CHARGE 6: TAX 7: SOURCE 8: MARKET CODE Header-2: Extra Charges 1: SINGLE LEDGER 2: EXTRA CHARGE Header-3: Discount 1: SINGLE LEDGER 2: DISCOUNT Header-4: Adjustment 1: SINGLE LEDGER Header-5: Taxes 1: SINGLE LEDGER 2: TAX Header-6: Payment Type 1: SINGLE LEDGER 2: Payment Type Header-7: Folio Transfer 1: SINGLE LEDGER Header-8: Guest Ledger 1: SINGLE LEDGER 3: BUSINESS SOURCE 4: ROOM NAME 5: ROOM TYPE Header-9: Guest Ledger – Customer 1: SINGLE LEDGER Header-10: City Ledger 1: SINGLE LEDGER 2: City Ledger Header-11: City Ledger – Customer 1: SINGLE LEDGER 2: City Ledger Header-12: City Ledger Contra 1: SINGLE LEDGER Header-13: Advance From Guest 1: SINGLE LEDGER Header-14: Cost Center 1: SINGLE LEDGER 2: ROOM NAME Header-15: Room Posting 1: SINGLE LEDGER 3: Tax Percentage Header-16: Paid Out 1: SINGLE LEDGER 2: Paid Out | SINGLE LEDGER, ROOM NAME, RATE TYPE |
headerid | String | It is pre-defined unique Id | 1 |
header | String | Header-1: Room Revenue Header-2: Extra Charges Header-3: Discount Header-4: Adjustment Header-5: Taxes Header-6: Payment Type Header-7: Folio Transfer Header-8: Guest Ledger Header-9: Guest Ledger – Customer Header-10: City Ledger Header-11: City Ledger – Customer Header-12: City Ledger Contra Header-13: Advance From Guest Header-14: Cost Center Header-15: Room Posting Header-16: Paid Out | Room Revenue |
Success
[ { "descriptionunkid": "1", "description": "Revenue", "descriptiontypeunkid": "1", "descriptiontype": "SINGLE LEDGER", "headerid": "1", "header": "Room Revenue" }, { "descriptionunkid": "123400000000000006", "description": "30 Flat", "descriptiontypeunkid": "2", "descriptiontype": "TAX", "headerid": "5", "header": "Taxes" }, { "descriptionunkid": "123400000000000001", "description": "Daily", "descriptiontypeunkid": "4", "descriptiontype": "RATE TYPE", "headerid": "1", "header": "Room Revenue" }, { "descriptionunkid": "123400000000000001", "description": "Managers Open Discount", "descriptiontypeunkid": "2", "descriptiontype": "DISCOUNT", "headerid": "3", "header": "Discount" } ]
Error Codes
Code | Message |
AllFields | All fields are mandatory. |
AuthKey | Authentication Key Is Not Found. |
ReqFor | Invalid Request Format. |
HotelCode | Hotel Code Is Not Found |
Error | Something went wrong! |
Error | Bad Request |
304 | Database Error |
202 | Unauthorized request. Hotel code is not active |
301 | Unauthorized request. Request is not valid for this hotel code [Permission denied] |
303 | Auth Code is inactive. |
Others
Retrieve Guest
This API provides the guest profiles by filters. Most properties maintains guest database to accumulate the volume of returning guest, for building good relationships and create a better guest experience. This API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Key | Datatype | Description | Example |
Request_Type * | – | Use Keyword “GuestList” | |
AuthCode * | Varchar(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
HotelCode * | Integer(11) | Unique Hotel code | XXXX |
Ids | Varchar(20) | ID of Travel Agent | xxxxxxxxxxxx |
Names | Varchar(20) | Names of travel agent | Peter |
FromDate | Date | Update From date. [Format: yyyy-mm-dd] | 2020-07-01 |
ToDate | Date | Update To date. [Format: yyyy-mm-dd] | 2020-07-03 |
isActive | INT(1) | Staus : active or not 1=active, 0=inactive | 1 or 0 |
Request (Without Optional Value)
{ "RES_Request": { "Request_Type": "GuestList", "Authentication": { "HotelCode": "xxxxx", "AuthCode": "xxxxxxxxxxxxxxxxxxxxxx" } } }
Request (With Optional Value)
{ "RES_Request": { "Request_type": "GuestList", "Authentication": { "HotelCode": "xxxxx", "AuthCode": "xxxxxxxxxxxxxxxxxxxxxx" }, "Ids": [ //Optional Filter "xxxx", "xxxx" ], "Names": [ //Optional Filter "AC Company" ], "Created": { //Optional Filter "from_date": "2019-12-05T00:00:00Z", "to_date": "2019-12-10T00:00:00Z" }, "Updated": { //Optional Filter "from_date": "2019-12-05T00:00:00Z", "to_date": "2019-12-10T00:00:00Z" }, "isActive":"0" //Optional Filter,0 or 1 values where 0 = deactivated company and 1= activated company } }
Response
Name | Datatype | Description | Example |
Id | Integer | Unique Company agent id | xxxxxxxxxxxxx |
AccountName | String | Businessname | Start Travels |
AccountCode | String | Short code | STR. |
Contact_person | String | Contact person name | Mr.James |
Address | String | Address of Travel agent | New York |
City | String | City name | New York |
PostalCode | Integer | Postal code | 101101 |
State | String | State name | New York |
Country | String | Country name | USA |
Phone | Integer | Phone number | 123456 |
Mobile | Integer | Mobile number | 1234567890 |
Fax | Integer | Fax Number | 123456789 |
String | Email id | abc@rmail.com | |
TaxId | String | Tax id | 1 |
RegistrationNo | String | Registration number | 123 |
CommissionPlan | String | Commission plan name | % on all nights (exclu. Tax) |
CommissionValue | Decimal | Commission plan value | 5 |
Discount on the standard rate % | Decimal | Discount percentage | 5 |
IsActive | String | Isactive or note | 0 or 1 |
Success
Response: { "Companies": [ { "Id": "51270000000017", "AccountName": "IBM", //Business Name "AccountCode": "", // Short Code "Contact_person": "Mr. Azad Singh", "Address: "Rheinlanddamm 207-209", “City": "Dortmund", "PostalCode": "44137", "State": "", "Country": "DE", “Phone”:”4334534534”, “Mobile”:”9000123456”, “Fax”:””, “Email”:”azadxyz@yahoo.co.in”, “TaxId”:”43534534534”, “Registration No”:”A3428973449284”, "IsActive": true } ] }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
208 | Both Updated from_date and to_date are mandatory if any one date is entered |
210 | No data found |
105 | From Date is missing. |
106 | From Date is not a valid date |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
205 | Created to_date should be greater than from_date |
108 | (To Date) – To Date is not a valid date |
207 | Updated to_date should be greater than from_dat |
107 | To Date is missing |
Others
Retrieve A Travel Agent
This API provides the travel agent profiles by filters. Most properties use this information when a guest books a room through a Travel Agency. Also hotels use this data to accumulate the booking volume they receive from these travel agents on an ongoing basis. This API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Key | Datatype | Description | Example |
Request_Type * | – | Use Keyword “TravelAgentList” | |
AuthCode * | Varchar(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
HotelCode * | Integer(11) | Unique Hotel code | XXXX |
Ids | Varchar(20) | ID of Travel Agent | xxxxxxxxxxxx |
Names | Varchar(20) | Names of travel agent | Peter |
FromDate | Date | Update From date. [Format: yyyy-mm-dd] | 2020-07-01 |
ToDate | Date | Update To date. [Format: yyyy-mm-dd] | 2020-07-03 |
isActive | INT(1) | Travel agent active or not 1=active, 0=inactive | 1 or 0 |
Request
{ "RES_Request": { "Request_Type": "TravelAgentList", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxx" }, "Ids": [ "3ed9e2f3-4bba-4df6-8d41-ab1b009b6425" ], "Names": [ ], "Created": { "from_date": "2019-12-05", "to_date": "2019-12-10" }, "Updated": { "from_date": "2019-12-05", "to_date": "2019-12-10" }, "isActive":"1" } }
Response
Name | Datatype | Description | Example |
Id | Integer | Unique Travel agent id | xxxxxxxxxxxxx |
AccountName | String | Travel agent Businessname | Start Travels |
AccountCode | String | Travel aget short code | STR. |
Contact_person | String | Contact person name | Mr.James |
Address | String | Address of Travel agent | New York |
City | String | City name | New York |
PostalCode | Integer | Postal code | 101101 |
State | String | State name | New York |
Country | String | Country name | USA |
Phone | Integer | Phone number | 123456 |
Mobile | Integer | Mobile number | 1234567890 |
Fax | Integer | Fax Number | 123456789 |
String | Email id | abc@rmail.com | |
TaxId | String | Tax id | 1 |
RegistrationNo | String | Registration number | 123 |
CommissionPlan | String | Commission plan name | % on all nights (exclu. Tax) |
CommissionValue | Decimal | Commission plan value | 5 |
Discount on the standard rate % | Decimal | Discount percentage | 5 |
IsActive | String | IsActive or not | 0 or 1 |
Success
{ "TravelAgent": [ { "Id": "12340000000000028", "AccountName": "ABC", "AccountCode": "TABC", "Contact_person": "Mr. James", "Address": "A234-A", "City": "New York", "PostalCode": "1000011", "State": "New York", "Country": "USA", "Phone": "9898989898", "Mobile": "9898989898", "Fax": null, "Email": "abc@email.com", "TaxId": "1", "RegistrationNo": null, "CommissionPlan": "% on all nights (exclu. Tax)", "CommissionValue": "4.0000", "Discount on the standard rate %": "7.0000", "IsActive": true } ] }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
208 | Both Updated from_date and to_date are mandatory if any one date is entered |
210 | No data found |
105 | From Date is missing. |
106 | From Date is not a valid date |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
205 | Created to_date should be greater than from_date |
108 | (To Date) – To Date is not a valid date |
207 | Updated to_date should be greater than from_dat |
107 | To Date is missing |
Others
Retrieve a Company
This API provides the company profiles by filters. Most properties use this information to source the correct address for invoicing. Also, hotels use this data to accumulate the booking volume they receive from these companies on an ongoing basis. This API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
Request_Type * | – | Use Keyword “CompanyList” | |
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
Ids | VARCHAR(300) | Add Identity id and also, can add multiple records | Abc4578lk, yzx7426kj |
Names | VARCHAR(300) | Add Business name and also, can add multiple records | 33Comp, Abc Company |
Created. from_date | DATE | To send a created from date | 2020-07-05 |
Created. to_date | DATE | To send a created to date | 2020-07-07 |
Updated. from_date | DATE | To send a updated from date | 2020-07-05 |
Updated. to_date | DATE | To send a updated to date | 2020-07-07 |
isActive | INT(11) | Is Active in 1 or 0 | 1 |
Request
{ "RES_Request": { "Request_Type": "CompanyList", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxx" }, "Ids": ["abc4578lk","yzx7426kj"], "Names": ["33Comp"], "Created": { "from_date": "2019-12-05", "to_date": "2019-12-10" }, "Updated": { "from_date": "2019-12-05", "to_date": "2019-12-10" }, "isActive":"1" } }
Response
Name | Data Type | Description | Example |
Id | INT(11) | Company record id | 2700000000003934 |
AccountName | VARCHAR(255) | Business name | 33Comp |
AccountCode | VARCHAR(255) | Business shortcode | 33c |
Contact_person | VARCHAR(255) | Contact person name | 33CompAccount |
Address | VARCHAR(255) | Address data | street -5, abc road |
City | VARCHAR(255) | City | romania |
PostalCode | VARCHAR(255) | PostalCode | 895623 |
State | VARCHAR(255) | State | |
Country | VARCHAR(255) | Country | Romania |
Phone | VARCHAR(100) | Phone | 789561234 |
Mobile | VARCHAR(100) | Mobile | 44545454554 |
Fax | VARCHAR(100) | Fax | |
VARCHAR(255) | 33Comp@gmail.com | ||
TaxId | VARCHAR(255) | TaxId | 78 |
RegistrationNo | VARCHAR(255) | RegistrationNo | vb89 |
IsActive | VARCHAR(100) | IsActive | false |
Success
{ "Companies": [ { "Id": "2700000000003934", "AccountName": "33Comp", "AccountCode": "33c", "Contact_person": "33CompAccount", "Address": "street -5, abc road", "City": "romania", "PostalCode": "895623", "State": null, "Country": "Romania", "Phone": "789561234", "Mobile": "44545454554", "Fax": null, "Email": "33Comp@gmail.com", "TaxId": "78", "RegistrationNo": "vb89", "IsActive": false } ] }
Error Codes
Error Code | Error Name |
100 | Missing required parameters. |
500 | Error occurred during processing |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
105 | From Date is missing |
107 | To Date is missing |
109 | Please check From and To date. To Date should be greater than fromdate |
208 | Both Updated from_date and to_date are mandatory if any one date is entered |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive. |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
106 | From Date is not a valid date |
108 | To Date is not a valid date |
112 | Error: Date range is too long. Please provide dates for 1 month. |
210 | No data found |
Others
Retrieve Guest Stays Statistics
This API gives us the guest stays statistics by which one can accumulate the volume of returning guests thereby helping to create the best guest experience. This API can return data in CSV formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
Request
{ "hotel_code":"xxxx", "authkey" : "xxxxxxxxxxxx" }
Response
Name | Data Type | Description | Example |
Guest Name | String | To get a guest name | Daniel L |
Guest Email | String | To get a guest email address | Daniele123@yahoo.com |
Total Number of stays | String | To get a guest’s total number of stay in a hotel | 2 |
First stay | Date | To get a guest’s first stay | 2020-05-02 |
First Reservation No | String | To get a guest’s first reservation number | 5-1 |
First Folio No | String | To get a guest’s first folio number | 5 |
Last stay | Date | To get a guest’s last stay | 2020-05-02 |
Last Reservation No | String | To get a guest’s last reservation number | 5-1 |
Last Folio No | String | To get a guest’s last folio number | 5 |
Next stay | Date | To get a guest’s next stay | |
Next Reservation No | String | To get a guest’s next reservation number | |
Next Folio No | String | To get a guest’s next folio number | |
Lifetime Spending | String | To get amount spend | 2560.0000 |
Success
"Guest Name","Guest Email","Total Number of stays","First stay","First Reservation No","First Folio No","Last stay","Last Reservation No","Last Folio No","Next stay","Next Reservation No","Next Folio No","Lifetime Spending" "Mr. Michel Joy","","1","2020-03-11","5-1","2","2020-03-11","5-1","2","","","","3863.0000" "Mr. Rechel","","1","2020-03-11","5-2","3","2020-03-11","5-2","3","","","","0.0000"
Error Codes
Property Deactivated : This property has been deactivated OpenAPI Record invalid : Unauthorized Request. This request is not valid for this hotel code OpenAPI Deactivated : Auth Code is inactive. OpenAPI Request : Invalid API Request. Don't have this API access.
Finance
Retrieve Bills
A Bill is a container of charges, deposits and payments. This API provides you the detail information of all items posted on the booking invoices. The API can return data in CSV formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
---|---|---|---|
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
FromDate * | Date | Date From | 2020-07-01 |
ToDate * | Date | Date To | 2020-07-10 |
Request
{ "authcode": "xxxxxxxxxxxx", "hotel_code":"xxxx", "fromdate": "2020-02-01", "todate": "2020-03-01" }
Response
Name | Data Type | Description | Example |
Unique id | String | Unique id | UNK_123450000000000003_2020-03-28_4 |
Hotel Name | String | Name of Hotel | Hotel Name |
Hotel Code | Integer | Hotel unique code | xxxx |
Folio No | Integer | Folio number | 1 |
Date | Date | Folio date | 2020-02-03 |
Voucher No/Receipt No | Integer | Voucher/Receipt number | 3 |
Invoice Number | String | Invoice Number | A5 |
Guest Name | String | Guest Full Name | Mr. John |
Bill To Name | String | Guest/Business Name | ABC Company |
Guest GST Number | String | Guest GST Number | xxxxxxxxxxxx |
State | String | State Name | Maharastra |
Phone Number | String | Guest Phone Number | 123456789 |
Mobile Number | String | Guest Mobile Number | 123456789 |
Type | String | Folio type | Extra Charges |
Particular | String | Particular folio | Welcome Drink |
Qty | Integer | Particular quantity | 1 |
Currency | String | Folio Currency | $ |
Amount | Decimal | folio amount | 100 |
GST Rate | Float | Total GST Rate | 20,22.5 etc |
CGST Tax Amount | Float | CGST Tax Amount | 10,100.10 etc |
SGST Tax Amount | Float | SGST Tax Amount | 10,100.10 etc |
IGST Tax Amount | Float | IGST Tax Amount | 10,100.10 etc |
Service Tax | Decimal | Service Tax Amount | 10 |
Luxury Tax | Decimal | Luxury Tax Amount | 10 |
Discount | Decimal | Discount Amount | 0 |
Adjustment | Decimal | Adjustment Amount | 0 |
Total | Decimal | Total Amount | 120 |
Is Advance Deposit | String | Is advance deposit | Yes |
Is Inclusion | String | Is Tax inclusion in amount | Yes |
Posted By | String | Posted By | admin |
Success
"Unique id","Hotel Name","Hotel Code","Folio No","Date","VoucherNo/ReceiptNo","Invoice Number","Guest Name","Bill To Name","Guest GST Number","State","Phone Number","Mobile Number","Type","Particular","Qty","Currency","Amount","GST Rate","CGST Tax Amount","SGST Tax Amount","IGST Tax Amount","Service Tax","Luxury Tax","Discount","Adjustment","Total","Is Advance Deposit","Is Inclusion","Posted By", "UNK_123450000000104586","Hotel","xxxx","1484","2020-12-01","504-1","5220","Mr. John","Mr. John","","","123456789","123456789","Bank","Cheque","","Rs","-2200","0","0","0","0","0","0","0","0","-2200","Yes","No","admin", "UNK_123450000000104547","Hotel","xxxx","1484","2021-02-28","","5220","Mr. John","ABC Company","","","123456789","123456789","Room Charges","Room Charges","","Rs","1964.28","12","117.86","117.86","0","0","0","0","0","2200","","No","admin",
Error Codes
Property Deactivated: This property has been deactivated OpenAPI Record invalid: Unauthorized Request. Please check hotel code and authentication code OpenAPI Deactivated: Auth Code is inactive. OpenAPI Request: Property is not authorized to access this api.
Finance
Retrieve Hotel Expenses
This API provides you with detailed information on all expenses for a property. The API can return data in CSV formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
---|---|---|---|
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
FromDate * | Date | Date From | 2020-07-01 |
ToDate * | Date | Date To | 2020-07-10 |
Request
{ "authcode": "xxxxxxxxxxxx", "hotel_code":"xxxx", "fromdate": "2020-02-01", "todate": "2020-03-01" }
Response
Name | Data Type | Description | Example |
Hotel Name | String | Name of Hotel | Hotel Name |
Hotel Code | Integer | Unique Hotel code | xxxx |
Voucher Date | Date | Date of Voucher | 2020-05-02 |
Voucher No | Integer | Voucher number | 1 |
Contact Info | String | Contact information | Michele B. Wiese |
Expense Made To | String | Expense made to | GUEST |
Paid Out | String | Paid out for | Laundry Bill |
Paid Out Charges | Decimal | Paid Out Charges amount | 100 |
Paid Out Currency | String | Currency of Paid out | $ |
Payment Mode | String | Mode of payment | Cash |
Payment Charges | Decimal | Payment Charges | 10 |
Payment Currency | String | Currency of Payment | $ |
Success
"HotelName","HotelCode","VoucherDate","VoucherNo","ContactInfo","ExpenseMadeTo","PaidOut","PaidOutCharges","PaidOutCurrency","PaymentMode","PaymentCharges","PaymentCurrency", "Hotel","xxxx","2020-03-18","3","Mr. Michele B. Wiese","GUEST","Laundry Bill","680","$","Cash,Cash,Cash","-680","$",
Error Codes
Property Deactivated: This property has been deactivated OpenAPI Record invalid: Unauthorized Request. Please check hotel code and authentication code OpenAPI Deactivated: Auth Code is inactive. OpenAPI Request: Property is not authorized to access this api.
Housekeeping
Set out of Order (Block Room)
This API helps to block a room due to maintenance purposes thereby making a room unavailable for sale. This API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
---|---|---|---|
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
RoomID * | INT(20) | ID of Room | 123450000000000001 |
RoomtypeID * | INT(20) | ID of RoomType | 123450000000000001 |
FromDate * | Date | From date. [Format: yyyy-mm-dd] | 2020-07-12 |
ToDate * | Date | To date. [Format: yyyy-mm-dd] | 2020-07-13 |
Reason | VARCHAR(300) | Reason for out of order. | Block Room, Maintenance, etc |
Request
{ "RES_Request": { "Request_Type": "SetoutofOrder", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" }, "Rooms": [ { "RoomID": "123450000000000004", "RoomtypeID":"123450000000000006", "FromDate": "2020-05-15", "ToDate": "2020-05-16", "Reason": "Block Room" } ]} }
Response
Name | Data Type | Description | Example |
Success.SuccessMsg | – | Generate Success Response Message | Rooms Blocked Successfully |
Errors.ErrorCode | – | Response Error Code | 0, 301 etc |
Errors.ErrorMessage | – | Generate Response Message | Unauthorized Request. Please check hotel code and authentication code |
Success
{ "Errors": { "ErrorCode": "0", "ErrorMessage": "Success" }, "Success": { "SuccessMsg": "Rooms Blocked Successfully" } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters |
500 | Error occurred during processing. |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
103 | Room ID is missing |
104 | Roomtype ID is missing |
105 | From Date is missing. |
106 | From Date is not a valid date |
107 | To Date is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
115 | Reason is missing |
108 | (To Date) – To Date is not a valid date |
109 | From Date (From Date) To Date : (To Date) – Please check From and To date. To Date should be greater than fromdate |
110 | From Date is not a valid date, FromDate should be greater than HotelDate |
128 | Room/s cannot be blocked for selected dates |
Housekeeping
Update Room Status
This API helps to update housekeeping information on an inhouse room. This API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
---|---|---|---|
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
roomid * | BIGINT(20) | ID of Room | 123450000000000001 |
unitid * | BIGINT(20) | Unit ID | 123450000000000001 |
hkstatus * | VARCHAR(300) | Housekeeping Status | Clean |
hkremarks | VARCHAR(300) | Housekeeping Remarks | Cleaned |
Request
{ "authcode":"xxxxxxxxxxxx", "hotel_code":"xxxx", "updatehkdata": [{ "hotel_code": "xxxx", "roomid": "123450000000000001", "unitid": "1213450000000000001", "hkstatus": "Clean", "hkremarks": "" },{ "hotel_code": "xxxx", "roomid": "123450000000000002", "unitid": "123450000000000003", "hkstatus": "Dirty", "hkremarks": "" }] }
Response
Name | Data Type | Description | Example |
status | String | Update status | 1 |
message | String | Message | Success |
warning | Integer | Warning | This request will not be process as hotel_code is invalid. |
Success
{ "status": "0", "message": "Success" }
Error Codes
Property Deactivated: {"errorcode":"1","message":"This property has been deactivated."} OpenAPI Record invalid: {"errorcode":"1","message":" Unauthorized Request. Please check hotel code and authentication code "} OpenAPI Deactivated: {"errorcode":"1","message":" Auth Code is inactive. "} OpenAPI Request: {"errorcode":"1","message":"Property is not authorized to access this api. "}
Housekeeping
Retrieve Inhouse Room Status
This API provides housekeeping information of todays vacant and occupied rooms and also provides check in guest information. API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
---|---|---|---|
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
Request
{ "authcode": "xxxxxxxxxxxx", "hotel_code":"xxxx" }
Response
Name | Data Type | Description | Example |
roomlist.hotelcode | Integer | Hotel unique code | xxxx |
roomlist.roomid | Integer | ID of Room | 123450000000000001 |
roomlist.unitid | Integer | Unit ID | 123450000000000001 |
roomlist.roomname | String | Name Of Room | 101 |
roomlist.roomtypeid | Integer | RoomType ID | 123450000000000004 |
roomlist.roomtypename | String | Name of RoomType | Delux |
roomlist.isblocked | String | Is Blocked | No |
roomlist.hkstatus | String | Housekeeping Status | Clean |
roomlist.hkremarks | String | Housekeeping Remarks | cleaned |
roomlist.roomstatus | String | Status of Room | Available |
checkinguestlist.hotel_code | Integer | Hotel unique code | xxxx |
checkinguestlist.reservationno | Integer | Reservation Number | 10 |
checkinguestlist.guestname | String | Name of Guest | John Lenth |
checkinguestlist.email | String | Email of Guest | johnl123@example.com |
checkinguestlist.address | String | Address of Guest | 123, abc building, USA |
checkinguestlist.room | String | Room Name | 101 |
checkinguestlist.roomtype | String | Room Type | Delux |
checkinguestlist.ratetype | String | Rate type | Frequent Traveler |
checkinguestlist.bookingdate | Datetime | Date of Booking | 2020-04-11 16:44:47 |
checkinguestlist.checkindate | Datetime | Date of CheckIn | 2020-04-17 15:44:47 |
checkinguestlist.checkoutdate | Datetime | Date of CheckOut | 2020-04-20 19:44:47 |
checkinguestlist.businesssource | Integer | Business source unique id | 123450000000000001 |
checkinguestlist.market | Integer | Market unique id | 123450000000000001 |
checkinguestlist.travelagent | Integer | Travel Agent id | 123450000000000001 |
checkinguestlist.company | String | Name of Company | Ping Man |
checkinguestlist.tavoucherno | Integer | Travel agent Voucher number | 1 |
checkinguestlist.Adult | Integer | Number of adult | 2 |
checkinguestlist.Child | Integer | Number of child | 1 |
checkinguestlist.housekeepingremarks Stayover | String | Housekeeping remarks | Cleaned |
checkinguestlist.bookingstatus | String | Status of booking such as Arrival,Check Out, Due Out,Confirmed Reservation, Void,Cancel,No Show, Maintenance Block,Unconfirmed Reservation,Stayover, Unblock,Dayuse Reservation,Dayuse | Stayover |
Success
{ "roomlist": [ { "hotel_code": "xxxx", "roomid": "123450000000000001", "unitid": "123450000000000001", "roomname": "101", "roomtypeid": "123450000000000004", "roomtypename": "Delux", "isblocked": "No", "hkstatus": "Dirty", "hkremarks": "", "roomstatus": "Available" }, { "hotel_code": "xxxx", "roomid": "123450000000000002", "unitid": "123450000000000002", "roomname": "102", "roomtypeid": "123450000000000004", "roomtypename": "Delux", "isblocked": "No", "hkstatus": "", "hkremarks": "", "roomstatus": "Available" } ], "checkinguestlist": [ { "hotel_code": "xxxx", "reservationno": "8", "guestname": "Mr. John Lenth", "email": "johnl123@example.com", "address": "123, abc building, USA", "room": "103", "roomtype": "Twin", "ratetype": "Frequent Traveller", "bookingdate": "2020-04-11 16:44:47", "checkindate": "2020-03-17 13:37:16", "checkoutdate": "2020-03-20 17:42:00", "businesssource": "", "market": "", "travelagent": "", "company": "", "tavoucherno": "", "Adult": "2", "Child": "1", "housekeepingremarks": "", "bookingstatus": "Stayover" } ] }
Error Codes
Property Deactivated: This property has been deactivated OpenAPI Record invalid: Unauthorized Request. Please check hotel code and authentication code OpenAPI Deactivated: Auth Code is inactive. OpenAPI Request: Property is not authorized to access this api.
Bookings
Cancel a Booking
This API helps you to cancel bookings in our system. The API can return data in JSON formats. The web service responds to HTTP GET requests.
You need to take eZee Reservation to use this API.
End Point URL
[BaseUrl]booking/reservation_api/listing.php?request_type=[Request_Type]&HotelCode=[Hotel_Code]&APIKey=[API_KEY]&ResNo=[ResNo]
Header
–
Parameter
Name | Data Type | Description | Example |
[BaseUrl] * | – | Live server URL | https://live.ipms247.com/ |
[Request_Type] * | – | Use Keyword “CancelBooking” | |
[Hotel_Code] * | INT(11) | Unique Hotel code | XXXX |
[API_KEY] * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
[ResNo] * | INT(11) | Reservation number | 1 |
SubNo | INT(11) | SubReservation Unique number | 1 |
[LANGUAGE] | VARCHAR(20) | [Optional] Default is en. Pass language code. Language codes are available here. | en |
Request
https://live.ipms247.com/booking/reservation_api/listing.php?request_type=CancelBooking&HotelCode=xxxx&APIKey=xxxxxxxxxxxxxxxx&language=en&ResNo=167&SubNo=&language=en
Response
Name | Data Type | Description | Example |
Success.SuccessMsg | – | Generate Success Response | Booking processed Successfully |
Errors.ErrorCode | – | Response Error Code | 301, 404 etc |
Errors.ErrorMessage | – | Generate Response Message | Reservation already processed |
Success
{“status”:”Successful”}
Error Codes
Error Code | Error Name |
HotelCodeEmpty | Hotel code is empty. |
NORESACC | This request is valid for Reservation Account only. You may not have opted for Reservation Account Or Hotel Code and Authentication are invalid. |
UNAUTHREQ | Unauthorized request. This request is not valid for this hotel code. |
2 | Cannot Parse Request |
5 | Recoverable Error. Equivalent to http 503. |
CheckDate | Check out date should be greater than Check in date |
DBConnectError | Database not connected. |
InvalidData | Please check data passed. |
-1 | No Data found. |
APIACCESSDENIED | Your property doesn’t have access to API integration or Key is incorrect. Please contact support for this. |
ParametersMissing | Missing parameters. |
UnknownError | Unknown Error |
4 | Timeout requested. Stops requests for the specified time. |
InvalidHotelCode | Invalid Hotel code.Please check your property code. |
BadRequest | Bad request type. |
ReservationNotExist | Reservation No. does not exist. Please check. |
Bookings
Retrieve a Booking Based on Parameters
This API provides you current room stats and booking information based on reservation date or arrival dates. The API can return data in JSON formats. The web service responds to HTTP GET requests.
You need to take eZee Reservation to use this API.
End Point URL
[BaseUrl]booking/reservation_api/listing.php?request_type=[Request_Type]&HotelCode=[Hotel_Code]&APIKey=[API_KEY]&created_ from=[CREATED_FROM]&created_to=[CREATED_TO]&EmailId=[Email]
Header
–
Parameter
Name | Data Type | Description | Example |
[BaseUrl] * | – | Live server URL | https://live.ipms247.com/ |
[Request_Type] * | – | Use Keyword “BookingList” | |
[Hotel_Code] * | INT(11) | Unique Hotel code | XXXX |
[API_KEY] * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
[CREATED_FROM] * | Date | Date Fromformat(yyyy-mm-dd) | 2020-05-23 |
[CREATED_TO] * | Date | Date Toformat(yyyy-mm-dd) | 2020-05-30 |
ArrivalFrom | Date | ArrivalDate fromformat(yyyy-mm-dd) | 2020-05-22 |
ArrivalTo | Date | ArrivalDate Toformat(yyyy-mm-dd) | 2020-05-30 |
[Email] * | VARCHAR(100) | Booking EmailId | xxxxxx@xyz.com |
Request
https://live.ipms247.com/booking/reservation_api/listing.php?request_type=BookingList&HotelCode=XXX&APIKey=XXX&arrival_from =XXX&arrival_to=XXX&EmailId=
Response
Name | Data Type | Description | Example |
ReservationNo | Integer(11) | Reservation Unique number | 1 |
GuestName | String | Name of Guest | Mr.Jhonson |
ArrivalDate | Date | Date of arrival | 2020-02-20 |
DepartureDate | Date | Date of Departure | 2020-02-22 |
CancelDate | Date | Date when Reservation is cancel | 2020-02-10 |
ReservationDate | Date | Date when Reservation is created | 2020-02-05 |
Room | String | Room Name | Delux |
ReservationGuarantee | String | Guarantee of reservation | Confirm booking |
Source | String | Source of reservation | web |
VoucherNo | Integer(11) | Voucher number | 1 |
DueAmount | Decimal | Due Amount | 12500 |
Deposit | Decimal | Deposit amount | 0 |
Status | String | Status of booking | Active |
BookingStatus | String | Current Status of booking | Confirmed Reservation |
Transaction Status | String | Status of transaction | Complete Booking |
Total Tax | Decimal | Total Tax amount | 500 |
TotalInclusiveTax | Decimal | Total Inclusive Tax Amount | 1500 |
TotalExclusivTax | Decimal | Total Exclusive Amount | 1000 |
OtherRevenueExclusiveTax | Decimal | Other Revenue tax exclusive amount | 1200 |
OtherRevenueInclusiveTax | Decimal | Other Revenue tax inclusive amount | 1500 |
FolioNo | String | Folio NUmber | A123 |
BaseRateExclusiveTax, BaseRateInclusiveTax | |||
TransactionDate | Date | Date of transaction | |
ChargeName | String | Name of charge | |
ChargeAmount | Decimal | Charge amount |
Success
{ "SearchCriteria": { "arrival_from": "2020-03-15", "arrival_to": "2020-05-30" }, "RoomList": { "TotalActiveRoomInHotel": 1155, "TotalBlockRooms": 0, "TotalOccupiedRooms": 8 }, "BookingList": [ { "ReservationNo": "RV506", "GuestName": "Mr. Anis", "ArrivalDate": "2020-05-08", "DepartureDate": "2020-05-12", "CancelDate": "", "ReservationDate": "2020-05-08", "Room": "Garden View", "RoomShortCode": "GV", "ReservationGuarantee": "Confirm Booking", "Source": "Ajay Tours and Travels", "VoucherNo": "-", "Mobile": "-", "Address": "", "Email": "nishit.vankawala@ezeetechnosys.com", "Country": "India", "Adult": "1", "Child": "0", "Phone": "-", "NoOfGuest": 1, "NoOfNights": "4", "salutation": "Mr.", "FirstName": "Anis", "LastName": "", "DueAmount": 13200, "Deposit": 0, "Status": "Active", "BookingStatus": "Confirmed Reservation", "TransactionStatus": "Complete Booking", "Total Tax": 1345.44, "TotalInclusiveTax": 13200, "TotalExclusivTax": 11854.56, "OtherRevenueExclusiveTax": 2000, "OtherRevenueInclusiveTax": 2360, "FolioNo": "GF759", "BaseRateExclusiveTax": { "2020-05-08": 2463.64, "2020-05-09": 2463.64, "2020-05-10": 2463.64, "2020-05-11": 2463.64 }, "BaseRateInclusiveTax": { "2020-05-08": 2710, "2020-05-09": 2710, "2020-05-10": 2710, "2020-05-11": 2710 }, "ExtraCharges": { "2020-05-08": [ { "TransactionDate": "2020-05-08", "ChargeName": "Pool's", "ChargeAmount": "500.0000" }, { "TransactionDate": "2020-05-08", "ChargeName": "CGST@6%", "ChargeAmount": "90.0000" } ], "2020-05-09": [ { "TransactionDate": "2020-05-09", "ChargeName": "Pool's", "ChargeAmount": "500.0000" }, { "TransactionDate": "2020-05-09", "ChargeName": "CGST@6%", "ChargeAmount": "90.0000" } ], "2020-05-10": [ { "TransactionDate": "2020-05-10", "ChargeName": "Pool's", "ChargeAmount": "500.0000" }, { "TransactionDate": "2020-05-10", "ChargeName": "CGST@6%", "ChargeAmount": "90.0000" } ], "2020-05-11": [ { "TransactionDate": "2020-05-11", "ChargeName": "Pool's", "ChargeAmount": "500.0000" }, { "TransactionDate": "2020-05-11", "ChargeName": "CGST@6%", "ChargeAmount": "90.0000" } ] } } ] }
Error Codes
Error Code | Error Name |
HotelCodeEmpty | Hotel code is empty. |
NORESACC | This request is valid for Reservation Account only. You may not have opted for Reservation Account Or Hotel Code and Authentication are invalid. |
UNAUTHREQ | Unauthorized request. This request is not valid for this hotel code. |
2 | Cannot Parse Request |
5 | Recoverable Error. Equivalent to http 503. |
CheckDate | Check out date should be greater than Check in date |
DBConnectError | Database not connected. |
BookingListLimitExceed | You can not request data of more than 365 days. |
-1 | No Data found. |
APIACCESSDENIED | Your property doesn’t have access to API integration or Key is incorrect. Please contact support for this. |
ParametersMissing | Missing parameters. |
UnknownError | Unknown Error |
4 | Timeout requested. Stops requests for the specified time. |
InvalidHotelCode | Invalid Hotel code.Please check your property code. |
BadRequest | Bad request type. |
getBookingListError | Booking List error |
Bookings
Retrieve Departures
This API provides guest departures information based on departure dates of bookings. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
Request_Type * | VARCHAR(250) | Use Keyword “DepartureList” | |
BookingId | INT(11) | Reservation No (It is Optional) | 12345 |
RoomNo | VARCHAR(500) | Room No (It is Optional) | 101 |
Guest | VARCHAR(100) | Guest Name (It is Optional) | test |
IdentityNo | VARCHAR(255) | Identity No (It is Optional) | ASD43543 |
GuestEmail | VARCHAR(255) | Guest Email (It is Optional) | abc@gmail.com |
GuestMobileNo | VARCHAR(255) | Guest Mobile No (It is Optional) | XXXXXXXXXX |
GuestRegistrationNo | VARCHAR(255) | Guest Registration No (It is Optional) | XXXXXX |
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
from_date * | DATE | To send a from date | 2020-06-05 |
to_date * | DATE | To send a to date | 2020-07-07 |
Request
{ "RES_Request": { "Request_Type": "DepartureList", "BookingId": "12345", "RoomNo": "101", "Guest": "Joy T. Mnewy", "IdentityNo": "ASD43543", "GuestEmail": "XXXXXX@gmail.com", "GuestMobileNo": "XXXXXXXXXX", "GuestRegistrationNo": "XXXXXX", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxxxxxxxxxxxxx" }, "Date": { "from_date": "2020-10-05", "to_date": "2020-10-07" } } }
Response
Name | Data Type | Description | Example |
LocationId | INT(11) | Hotel code | xxxx |
UniqueID | VARCHAR(255) | Unique Booking id | 10125, 86436, B4525 etc |
BookedBy | VARCHAR(255) | Information regarding Booked by | Booking.com etc |
Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo. | VARCHAR(255) | Here * denotes guest information like Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo. | shown in JSON response below. |
Source | VARCHAR(1000) | Booking generated source | Booking.com etc |
PaymentMethod | VARCHAR(255) | Payment Mode selected by guest | Cash, Credit, CityLedger etc |
IsChannelBooking | INT(1) | Is booking comes from channel [0 or 1] 1 : Booking from the channel. 0: Booking not from the channel. | 0 or 1 |
BookingTran. SubBookingId | VARCHAR(255) | Sub booking Id | 138 |
BookingTran. TransactionId | INT(20) | Booking Transaction ID | 123400000000000163 |
BookingTran. Status | VARCHAR(100) | Booking Status | New or Modify or Cancel. |
BookingTran. IsConfirmed | INT(1) | Booking Confirmation Flag. [1 or 0] 1 : Confirmed 0 : Not Confirmed | 1 or 0. |
BookingTran. CurrentStatus | VARCHAR(100) | Booking Current Status | Arrived, Checked Out, Cancel, Void, etc |
BookingTran. VoucherNo | VARCHAR(255) | Booking Voucher No | 10203049/8512 |
BookingTran. PackageCode | INT(20) | Package Code | 123400000000000001 |
BookingTran. PackageName | VARCHAR(1000) | Package Name | European Plan etc |
BookingTran. RateplanCode | INT(20) | Unique RatePlan Code | 123400000000000006 |
BookingTran. RateplanName | STRING(1000) | RatePlan Name | Grand Sea View Junior Suite |
BookingTran. RoomTypeCode | INT(20) | Unique RoomType Code | 123400000000000006 |
BookingTran. RoomTypeName | STRING(1000) | RoomType Name | Garden View Studio Room |
BookingTran. Start | DATE | Check-in date[Format : yyyy-mm-dd] | 2020-10-25 |
BookingTran. End | DATE | Check-out date [Format : yyyy-mm-dd] | 2020-10-27 |
BookingTran.TotalRate | DECIMAL(19,4) | Rate on room in amount | 1500.43 |
BookingTran. | DECIMAL(19,4) | Discount on room in | 500 |
TotalDiscount | Amount | ||
BookingTran. TotalExtraCharge | DECIMAL(19,4) | Extra charges in amount(if any) | 300 |
BookingTran. TotalPayment | DECIMAL(19,4) | Payment for room in amount | 2500.54 |
BookingTran.* | – | Here * denotes guest informations like Salutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo,IdentityType, IdentityNo, ExpiryDate. | |
BookingTran. TransportationMode | VARCHAR(100) | Mode of transportation | Bus, car etc |
BookingTran. Vehicle | VARCHAR(255) | Detail of vehicle | |
BookingTran. PickupDate | DATE | Pickup date[Format : yyyy-mm-dd] | 2020-10-25 etc |
BookingTran. PickupTime | TIME | Pickup time | |
BookingTran. Source | VARCHAR(1000) | Booking generated source | Booking.com |
BookingTran. Comment | VARCHAR(1000) | Additional Information or comment. | |
BookingTran. AffiliateName | VARCHAR(1000) | Booking Affiliate Name | |
BookingTran.AffiliateCode | VARCHAR(1000) | Booking Affiliate Code | |
BookingTran.* | – | Here * denotes Credit Card Informations like CCLink, CCNo, CCType, CardHolderName, CCExpiryDate, | |
BookingTran.RentalInfo. EffectiveDate | DATETIME | Booking details for particular effective date | 2020-10-25 etc |
BookingTran.RentalInfo. PackageCode | INT(20) | Package code | 123400000000000001 |
BookingTran.RentalInfo. PackageName | VARCHAR(100) | Package Name | European Plan |
BookingTran.RentalInfo. RoomTypeCode | INT(20) | Unique RoomType Code | 123400000000000006 |
BookingTran.RentalInfo. RoomTypeName | STRING(100) | RoomType Name | Grand Sea View Junior Suite |
BookingTran.RentalInfo. RoomName | VARCHAR(100) | Room Name/Number | 102 |
BookingTran.RentalInfo.Adult | INT(11) | No. of Adults | 2,3,4 etc |
BookingTran. RentalInfo.Child | INT(11) | No. of Childs | 2,3,4 etc |
BookingTran. RentalInfo.Rent | DECIMAL(19,4) | Room rental amount | 1500.43 |
BookingTran. RentalInfo.Discount | DECIMAL(19,4) | Discount on rental room in amount | 500 |
BookingTran.Sharer.* | – | Here * denotes Sharer informations like Salutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Nationality,Zip Code, Phone, Mobile, Fax, Email,RegistrationNo,IdentityTypeID, IdentityNo, ExpiryDate. | |
Errors.ErrorCode | – | Response Error Code | 104, 404 etc |
Errors.ErrorMessage | – | Generate Response Message | Unauthorized Request. etc |
Success
{ "Reservations": { "Reservation": [ { "BookingTran": [ { "SubBookingId": "RES2233", "TransactionId": "123400000000003264", "Createdatetime": "2020-10-24 17:57:47", "Modifydatetime": "2020-10-24 17:57:47", "Status": "New", "currentstatus": "Checked Out", "IsConfirmed": "1", "CurrentStatus": "Arrived", "VoucherNo": "", "PackageCode": "123400000000000003", "PackageName": "Non Refundable", "RateplanCode": "123400000000000010", "RateplanName": "Seaview Deluxe RoomOnly", "RoomTypeCode": "123400000000000004", "RoomTypeName": "t1", "Start": "2020-10-03", "End": "2020-10-05", "ArrivalTime": "17:48:00", "DepartureTime": "17:48:00", "CurrencyCode": "RS", "TotalAmountAfterTax": "6939.97", "TotalAmountBeforeTax": "5881.33", "TotalTax": "1058.64", "TotalDiscount": "0.00", "TotalExtraCharge": "50.85", "TotalPayment": "0.00", "TACommision": "0.00", "Salutation": "Miss.", "FirstName": "Jia", "LastName": "", "Gender": "Male", "DateOfBirth": "2020-10-01", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": "", "State": "", "Country": "Romania", "Nationality": "India", "Zipcode": "", "Phone": "", "Mobile": "", "Fax": "", "Email": "", “RegistrationNo” : "", "IdentiyType": "Master ID Card", "IdentityNo": "43545", "ExpiryDate": "", "TransportationMode": "", "Vehicle": "", "PickupDate": "", "PickupTime": "", "Source": "WEB", "Comment": "", "AffiliateName": "", "AffiliateCode": "", "CCLink": "", "CCNo": "", "CCType": "", "CCExpiryDate": "", "CardHoldersName": "", "TaxDeatil": [ { "TaxCode": "CGST New", "TaxName": "CGST New", "TaxAmount": "263.9000" }, { "TaxCode": "CGST New", "TaxName": "CGST New", "TaxAmount": "265.4200" }, { "TaxCode": "SGST New", "TaxName": "SGST New", "TaxAmount": "263.9000" }, { "TaxCode": "SGST New", "TaxName": "SGST New", "TaxAmount": "265.4200" } ], "ExtraCharge": [ { "ChargeDate": "2020-10-03", "ChargeCode": "Laundry", "ChargeName": "Laundry", "ChargeDesc": "Laundry", "Remark": "Laundry", "Quantity": "0", "AmountBeforeTax": "16.95", "AmountAfterTax": "20.01" }, { "ChargeDate": "2020-10-04", "ChargeCode": "Laundry", "ChargeName": "Laundry", "ChargeDesc": "Laundry", "Remark": "Laundry", "Quantity": "0", "AmountBeforeTax": "16.95", "AmountAfterTax": "20.01" }, { "ChargeDate": "2020-10-05", "ChargeCode": "Laundry", "ChargeName": "Laundry", "ChargeDesc": "Laundry", "Remark": "Laundry", "Quantity": "0", "AmountBeforeTax": "16.95", "AmountAfterTax": "20.01" } ], "RentalInfo": [ { "EffectiveDate": "2020-10-03", "PackageCode": "123400000000000003", "PackageName": "Non Refundable", "RoomTypeCode": "123400000000000004", "RoomTypeName": "t1", "RoomName": "102", "Adult": "5", "Child": "1", "RentPreTax": "2932.19", "Rent": "3459.99", "Discount": "0.00" }, { "EffectiveDate": "2020-10-04", "PackageCode": "123400000000000003", "PackageName": "Non Refundable", "RoomTypeCode": "123400000000000004", "RoomTypeName": "t1", "RoomName": "102", "Adult": "5", "Child": "1", "RentPreTax": "2949.14", "Rent": "3479.98", "Discount": "0.00" } ], "Sharer": [ { "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "RegistrationNo" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", }, { "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "Registration No" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", } ] } ], "LocationId": "27", "UniqueID": "RES2233", "BookedBy": "John", "Salutation": "Mr.", "FirstName": "John", "LastName": "", "Gender": "Male", "Address": "", "City": "", "State": "", "Country": "Romania", "Zipcode": "", "Phone": "", "Mobile": "", "Fax": "", "Email": "", "Source": "WEB", "PaymentMethod": "Abc", "IsChannelBooking": "1" }, ] } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters. |
500 | Error occurred during processing |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
105 | From Date is missing |
107 | To Date is missing |
109 | Please check From and To date. To Date should be greater than fromdate |
303 | No Data Found. |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive. |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
106 | From Date is not a valid date |
108 | To Date is not a valid date |
112 | Error: Date range is too long. Please provide dates for 1 month. |
503 | No Data Found. |
Bookings
Retrieve Arrivals
This API provides guest arrival information based on arrival dates of bookings. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
Request_Type * | VARCHAR(250) | Use Keyword “ArrivalList” | |
BookingId | INT(11) | Reservation No (It is Optional) | 12345 |
RoomNo | VARCHAR(500) | Room No (It is Optional) | 101 |
Guest | VARCHAR(100) | Guest Name (It is Optional) | test |
IdentityNo | VARCHAR(255) | Identity No (It is Optional) | ASD43543 |
GuestEmail | VARCHAR(255) | Guest Email (It is Optional) | abc@gmail.com |
GuestMobileNo | VARCHAR(255) | Guest Mobile No (It is Optional) | XXXXXXXXXX |
GuestRegistrationNo | VARCHAR(255) | Guest Registration No (It is Optional) | XXXXXX |
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
from_date * | DATE | To send a from date | 2020-06-05 |
to_date * | DATE | To send a to date | 2020-07-07 |
Request
{ "RES_Request": { "Request_Type": "ArrivalList", "BookingId": "12345", "RoomNo": "101", "Guest": "Joy T. Mnewy", "IdentityNo": "ASD43543", "GuestEmail": "XXXXXX@gmail.com", "GuestMobileNo": "XXXXXXXXXX", "GuestRegistrationNo": "XXXXXX", "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxxxxxxxxxxxxx" }, "Date": { "from_date": "2020-04-05", "to_date": "2020-04-07" } } }
Response
Name | Data Type | Description | Example |
LocationId | INT(11) | Hotel code | xxxx |
UniqueID | VARCHAR(255) | Unique Booking id | 10125, 86436, B4525 etc |
BookedBy | VARCHAR(255) | Information regarding Booked by | Booking.com etc |
Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo. | VARCHAR(255) | Here * denotes guest information like Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo. | shown in JSON response below. |
Source | VARCHAR(1000) | Booking generated source | Booking.com etc |
PaymentMethod | VARCHAR(255) | Payment Mode selected by guest | Cash, Credit, CityLedger etc |
IsChannelBooking | INT(1) | Is booking comes from channel [0 or 1] 1 : Booking from the channel. 0: Booking not from the channel. | 0 or 1 |
BookingTran. SubBookingId | VARCHAR(255) | Sub booking Id | 138 |
BookingTran. TransactionId | INT(20) | Booking Transaction ID | 123400000000000163 |
BookingTran. Status | VARCHAR(100) | Booking Status | New or Modify or Cancel. |
BookingTran.IsConfirmed | INT(1) | Booking Confirmation Flag. [1 or 0] 1 : Confirmed 0 : Not Confirmed | 1 or 0. |
BookingTran. CurrentStatus | VARCHAR(100) | Booking Current Status | Arrived, Checked Out, Cancel, Void, etc |
BookingTran. VoucherNo | VARCHAR(255) | Booking Voucher No | 10203049/8512 |
BookingTran. PackageCode | INT(20) | Package Code | 123400000000000001 |
BookingTran. PackageName | VARCHAR(1000) | Package Name | European Plan etc |
BookingTran. RateplanCode | INT(20) | Unique RatePlan Code | 123400000000000006 |
BookingTran. RateplanName | STRING(1000) | RatePlan Name | Grand Sea View Junior Suite |
BookingTran. RoomTypeCode | INT(20) | Unique RoomType Code | 123400000000000006 |
BookingTran. RoomTypeName | STRING(1000) | RoomType Name | Garden View Studio Room |
BookingTran. Start | DATE | Check-in date[Format : yyyy-mm-dd] | 2020-10-25 |
BookingTran. End | DATE | Check-out date [Format : yyyy-mm-dd] | 2020-10-27 |
BookingTran.TotalRate | DECIMAL(19,4) | Rate on room in amount | 1500.43 |
BookingTran. | DECIMAL(19,4) | Discount on room in | 500 |
TotalDiscount | Amount | ||
BookingTran. TotalExtraCharge | DECIMAL(19,4) | Extra charges in amount(if any) | 300 |
BookingTran. TotalPayment | DECIMAL(19,4) | Payment for room in amount | 2500.54 |
BookingTran.* | – | Here * denotes guest informations like Salutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo,IdentityType, IdentityNo, ExpiryDate. | |
BookingTran. TransportationMode | VARCHAR(100) | Mode of transportation | Bus, car etc |
BookingTran. Vehicle | VARCHAR(255) | Detail of vehicle | |
BookingTran. PickupDate | DATE | Pickup date[Format : yyyy-mm-dd] | 2020-10-25 etc |
BookingTran. PickupTime | TIME | Pickup time | |
BookingTran. Source | VARCHAR(1000) | Booking generated source | Booking.com |
BookingTran. Comment | VARCHAR(1000) | Additional Information or comment. | |
BookingTran. AffiliateName | VARCHAR(1000) | Booking Affiliate Name | |
BookingTran.AffiliateCode | VARCHAR(1000) | Booking Affiliate Code | |
BookingTran.* | – | Here * denotes Credit Card Informations like CCLink, CCNo, CCType,CardHolderName, CCExpiryDate, | |
BookingTran.RentalInfo.EffectiveDate | DATETIME | Booking details for particular effective date | 2020-10-25 etc |
BookingTran.RentalInfo.PackageCode | INT(20) | Package code | 123400000000000001 |
BookingTran.RentalInfo.PackageName | VARCHAR(100) | Package Name | European Plan |
BookingTran.RentalInfo. RoomTypeCode | INT(20) | Unique RoomType Code | 123400000000000006 |
BookingTran.RentalInfo. RoomTypeName | STRING(100) | RoomType Name | Grand Sea View Junior Suite |
BookingTran.RentalInfo.Adult | INT(11) | No. of Adults | 2,3,4 etc |
BookingTran. RentalInfo.Child | INT(11) | No. of Childs | 2,3,4 etc |
BookingTran. RentalInfo.Rent | DECIMAL(19,4) | Room rental amount | 1500.43 |
BookingTran. RentalInfo.Discount | DECIMAL(19,4) | Discount on rental room in amount | 500 |
BookingTran.Sharer.* | – | Here * denotes Sharer informations like Salutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Nationality,Zip Code, Phone, Mobile, Fax, Email,RegistrationNo,IdentityTypeID, IdentityNo, ExpiryDate. | |
Errors.ErrorCode | – | Response Error Code | 104, 404 etc |
Errors.ErrorMessage | – | Generate Response Message | Unauthorized Request. etc |
Success
{ "Reservations": { "Reservation": [ { "BookingTran": [ { "SubBookingId": "RES2370", "TransactionId": "123400000000003428", "Createdatetime": "2020-01-21 12:10:58", "Modifydatetime": "2020-01-21 12:10:58", "Status": "New", "IsConfirmed": "1", "CurrentStatus": "Arrived", "VoucherNo": "", "PackageCode": "123400000000000012", "PackageName": "GV", "RateplanCode": "123400000000000051", "RateplanName": "Govt GV", "RoomTypeCode": "123400000000000035", "RoomTypeName": "Govt", "Start": "2020-04-07", "End": "2020-04-08", "ArrivalTime": "12:10:00", "DepartureTime": "12:10:00", "CurrencyCode": "RS", "TotalAmountAfterTax": "1356.00", "TotalAmountBeforeTax": "1200.00", "TotalTax": "156.00", "TotalDiscount": "0.00", "TotalExtraCharge": "0.00", "TotalPayment": "580.00", "TACommision": "0.00", "Salutation": "Dr.", "FirstName": "Maxwel", "LastName": "Phil", "Gender": "Male", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": "", "State": "", "Country": "Romania", "Nationality": "India", "Zipcode": "", "Phone": "", "Mobile": "", "Fax": "", "Email": "", “RegistrationNo” : "", "IdentiyType": "", "IdentityNo": "", "ExpiryDate": "", "TransportationMode": "", "Vehicle": "", "PickupDate": "", "PickupTime": "", "Source": "WEB", "Comment": "", "AffiliateName": "", "AffiliateCode": "", "CCLink": "", "CCNo": "", "CCType": "", "CCExpiryDate": "", "CardHoldersName": "", "TaxDeatil": [ { "TaxCode": "PDV 13%", "TaxName": "PDV 13%", "TaxAmount": "156.0000" } ], "RentalInfo": [ { "EffectiveDate": "2020-10-07", "PackageCode": "123400000000000012", "PackageName": "GV", "RoomTypeCode": "123400000000000035", "RoomTypeName": "Govt", "RoomName": "102", "Adult": "2", "Child": "0", "RentPreTax": "1200.00", "Rent": "1356.00", "Discount": "0.00" } ], "Sharer": [ { "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "RegistrationNo" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", }, { "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "Registration No" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", } ] } ], "LocationId": "27", "UniqueID": "RES2370", "BookedBy": "Joy Chistian", "Salutation": "Dr.", "FirstName": "Joy", "LastName": "Chistian", "Gender": "Male", "Address": "AB-12, Street-2", "City": "", "State": "", "Country": "Romania", "Zipcode": "", "Phone": "", "Mobile": "", "Fax": "", "Email": "", "Source": "WEB", "PaymentMethod": "GreenTop2", "IsChannelBooking": "1" }, ] } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters. |
500 | Error occurred during processing |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
105 | From Date is missing |
107 | To Date is missing |
109 | Please check From and To date. To Date should be greater than fromdate |
303 | No Data Found. |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive. |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
106 | From Date is not a valid date |
108 | To Date is not a valid date |
112 | Error: Date range is too long. Please provide dates for 1 month. |
503 | No Data Found. |
Bookings
Retrieve a Booking
This API helps you to fetch booking details for specific booking ID based on Room No, Guest, Identity No, Guest Email, Guest Mobile No, Guest Registration No. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
Request_Type* | VARCHAR(100) | Request Type | FetchSingleBooking |
BookingId* | INT(11) | Reservation No | 12345 |
RoomNo | VARCHAR(500) | Room No (It is Optional) | 101 |
Guest | VARCHAR(100) | Guest Name (It is Optional) | test |
IdentityNo | VARCHAR(255) | Identity No (It is Optional) | ASD43543 |
GuestEmail | VARCHAR(255) | Guest Email (It is Optional) | abc@gmail.com |
GuestMobileNo | VARCHAR(255) | Guest Mobile No (It is Optional) | XXXXXXXXXX |
GuestRegistrationNo | VARCHAR(255) | Guest Registration No (It is Optional) | XXXXXX |
HotelCode* | INT(11) | Unique Hotel code | xxxx |
AuthCode* | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
Request
{ "RES_Request": { "Request_Type": "FetchSingleBooking", . "BookingId": "12345", "RoomNo": "101", "Guest": "Joy T. Mnewy", "IdentityNo": "ASD43543", "GuestEmail": "XXXXXX@gmail.com", "GuestMobileNo": "XXXXXXXXXX", "GuestRegistrationNo": "XXXXXX", "Authentication": { "HotelCode": "XXXX", "AuthCode": "XXXXXXXXXXXXXXXXXXX" } } }
Response
Name | Data Type | Description | Example |
LocationId | INT(11) | Hotel code | xxxx |
UniqueID | VARCHAR(255) | Unique Booking id/ Reservation No | 10125, 86436, B4525 etc |
BookedBy | VARCHAR(255) | Information regarding Booked by | Booking.com etc |
Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo. | VARCHAR(255) | Here * denotes guest information like Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo. | shown in JSON response below. |
Source | VARCHAR(1000) | Booking generated source | Booking.com etc |
PaymentMethod | VARCHAR(255) | Payment Mode selected by guest | Cash, Credit, CityLedger etc |
IsChannelBooking | INT(1) | Is booking comes from channel [0 or 1]1 : Booking from the channel.0: Booking not from the channel. | 0 or 1 |
BookingTran. SubBookingId | VARCHAR(255) | Sub booking Id | 138 |
BookingTran. TransactionId | INT(20) | Booking Transaction ID | 112500000000000163 |
BookingTran. Status | VARCHAR(100) | Booking Status | New or Modify or Cancel. |
BookingTran.IsConfirmed | INT(1) | Booking Confirmation Flag. [1 or 0]1 : Confirmed0 : Not Confirmed | 1 or 0. |
BookingTran.CurrentStatus | VARCHAR(100) | Booking Current Status | Arrived, Checked Out, Cancel, Void, etc |
BookingTran.VoucherNo | VARCHAR(255) | Booking Voucher No | 10203049/8512 |
BookingTran. PackageCode | INT(20) | Package Code | 112500000000000001 |
BookingTran. PackageName | VARCHAR(1000) | Package Name | European Plan etc |
BookingTran. RateplanCode | INT(20) | Unique RatePlan Code | 112500000000000006 |
BookingTran. RateplanName | STRING(1000) | RatePlan Name | Grand Sea View Junior Suite |
BookingTran. RoomTypeCode | INT(20) | Unique RoomType Code | 112500000000000006 |
BookingTran. RoomTypeName | STRING(1000) | RoomType Name | Garden View Studio Room |
BookingTran.RoomID | INT(20) | Unique RoomID | 112500000000000001 |
BookingTran. RoomName | STRING(1000) | Room Name | 101 |
BookingTran. Start | DATE | Check-in date[Format : yyyy-mm-dd] | 2017-12-25 |
BookingTran. End | DATE | Check-out date [Format : yyyy-mm-dd] | 2017-12-27 |
BookingTran.TotalRate | DECIMAL(19,4) | Rate on room in amount | 1500.43 |
BookingTran. | DECIMAL(19,4) | Discount on room in | 500 |
TotalDiscount | Amount | ||
BookingTran. TotalExtraCharge | DECIMAL(19,4) | Extra charges in amount(if any) | 300 |
BookingTran.* | – | Here * denotes guest informations like Salutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email,RegistrationNo,IdentityType, IdentityNo, ExpiryDate. | |
BookingTran. TransportationMode | VARCHAR(100) | Mode of transportation | Bus, car etc |
BookingTran. Vehicle | VARCHAR(255) | Detail of vehicle | |
BookingTran. PickupDate | DATE | Pickup date[Format : yyyy-mm-dd] | 2017-12-25 etc |
BookingTran. PickupTime | TIME | Pickup time | |
BookingTran. Source | VARCHAR(1000) | Booking generated source | Booking.com |
BookingTran. Comment | VARCHAR(1000) | Additional Information or comment. | |
BookingTran. AffiliateName | VARCHAR(1000) | Booking Affiliate Name | |
BookingTran.AffiliateCode | VARCHAR(1000) | Booking Affiliate Code | |
BookingTran.* | – | Here * denotes Credit Card Informations like CCLink, CCNo, CCType, CardHolderName, CCExpiryDate, | CCLink in encoded with base64_encode. |
BookingTran.RentalInfo.RoomID | INT(20) | Unique RoomID | 112500000000000001 |
BookingTran.RentalInfo. RoomName | STRING(1000) | Room Name | 101 |
BookingTran.RentalInfo.EffectiveDate | DATETIME | Booking details for particular effective date | 2017-12-25 etc |
BookingTran.RentalInfo.PackageCode | INT(20) | Package code | 112500000000000001 |
BookingTran.RentalInfo.PackageName | VARCHAR(1000) | Package Name | European Plan |
BookingTran.RentalInfo.RoomTypeCode | INT(20) | Unique RoomType Code | 112500000000000006 |
BookingTran.RentalInfo.RoomTypeName | STRING(1000) | RoomType Name | Grand Sea View Junior Suite |
BookingTran.RentalInfo.Adult | INT(11) | No. of Adults | 2,3,4 etc |
BookingTran. RentalInfo.Child | INT(11) | No. of Childs | 2,3,4 etc |
BookingTran. RentalInfo.Rent | DECIMAL(19,4) | Room rental amount | 1500.43 |
BookingTran. RentalInfo.Discount | DECIMAL(19,4) | Discount on rental room in amount | 500 |
BookingTran.Sharer.* | – | Here * denotes Sharer informations like Salutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Nationality,Zip Code, Phone, Mobile, Fax, Email,RegistrationNo,IdentityTypeID, IdentityNo, ExpiryDate. | |
Errors.ErrorCode | – | Response Error Code | 104, 404 etc |
Errors.ErrorMessage | – | Generate Response Message | Unauthorized Request. etc |
Success
{ "Reservations": { "Reservation": [ { "BookingTran": [ { "SubBookingId": "11241254", "TransactionId": "112400000000001902", "Createdatetime": "2019-09-04 11:40:30", "Modifydatetime": "2019-09-04 11:40:30", "Status": "New", "IsConfirmed": "1", "CurrentStatus": "Arrived", "VoucherNo": "single1276/1", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RateplanCode": "112400000000000001", "RateplanName": "Sea View Deluxe Room", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "RoomID": "112400000000000001", "RoomName": "101", "Start": "2019-09-26", "End": "2019-09-28", "ArrivalTime": "12:00:00", "DepartureTime": "11:00:00", "CurrencyCode": "USD", "TotalAmountAfterTax": "976.00", "TotalAmountBeforeTax": "800.00", "TotalTax": "176.00", "TotalDiscount": "0.00", "TotalExtraCharge": "0.00", "TotalPayment": "0.00", "TACommision": "0.00", "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", “RegistrationNo” : "", "IdentityType": "Pan card", "IdentityNo": "12345667765", "ExpiryDate": "", "TransportationMode": "", "Vehicle": "car", "PickupDate": "", "PickupTime": "", "Source": "BookingEye", "Comment": "", "AffiliateName": "", "AffiliateCode": "", "CCLink": "", "CCNo": "", "CCType": "", "CCExpiryDate": "", "CardHoldersName": "", "TaxDeatil": [ { "TaxCode": "AA", "TaxName": "VAT @ 12%", "TaxAmount": "96.0000" }, { "TaxCode": "LT", "TaxName": "Luxury @ 10%", "TaxAmount": "80.0000" } ], "RentalInfo": [ { "RoomID": "112400000000000001", "RoomName": "101", "EffectiveDate": "2019-09-26", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "4", "Child": "2", "RentPreTax": "550.00", "Rent": "671.00", "Discount": "0.00" }, { "RoomID": "112400000000000001", "RoomName": "101", "EffectiveDate": "2019-09-27", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "4", "Child": "2", "RentPreTax": "250.00", "Rent": "305.00", "Discount": "0.00" } ], "Sharer": [ { "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "RegistrationNo" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", }, { "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "Registration No" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", } ] } ], "LocationId": "1124", "UniqueID": "11241254", "BookedBy": "BookingEye", "Salutation": "Ms.", "FirstName": "Larry", "LastName": "Forney", "Gender": "Female", "Address": "", "City": "Brockway", "State": "CA", "Country": "USA", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "Source": "BookingEye", "PaymentMethod": "Cash", "IsChannelBooking": "1" } ] } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters. |
500 | Error occurred during processing |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive. |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
212 | Missing Parameter OR Invalid Parameter |
213 | Parameter is blank |
Bookings
Retrieve all Bookings
This API will give you latest updates of bookings which are newly created, modified and canceled. The API can return data in JSON formats. The web service responds to HTTP POST requests.
We recommend periodically calling the API — every minute, so your system can remain in sync with our system thereby keeping your system up-to-date.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
Request_Type * | – | Use Keyword “Bookings” | |
HotelCode * | INT(11) | Unique Hotel code | XXXX |
AuthCode * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
Request
{ "RES_Request": { "Request_Type": "Bookings", "Authentication": { "HotelCode": "xxxx", "AuthCode": "XXXXXXXXXXXXXXXXXXXXXXXX" } } }
Response
Name | Data Type | Description | Example |
LocationId | INT(11) | Hotel code | xxxx |
UniqueID | VARCHAR(255) | Unique Booking id | 10125, 86436, B4525 etc |
BookedBy | VARCHAR(255) | Information regarding Booked by | Booking.com etc |
Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email. | VARCHAR(255) | Here * denotes guest information like Salutation, FirstName, LastName, Gender, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email. | shown in JSON response below. |
Source | VARCHAR(1000) | Booking generated source | Booking.com etc |
PaymentMethod | VARCHAR(255) | Payment Mode selected by guest | Cash, Credit, CityLedger etc |
IsChannelBooking | INT(1) | Is booking comes from channel [0 or 1] 1 : Booking from the channel. 0: Booking not from the channel. | 0 or 1 |
BookingTran. SubBookingId | VARCHAR(255) | Sub booking Id | 138 |
BookingTran. TransactionId | INT(20) | Booking Transaction ID | 112500000000000163 |
BookingTran. Status | VARCHAR(1000) | Booking Status | New or Modify or Cancel. |
BookingTran.I sConfirmed | INT(1) | Booking Confirmation Flag. [1 or 0] 1 : Confirmed 0 : Not Confirmed | 1 or 0. |
BookingTran.CurrentStatus | VARCHAR(100) | Booking Current Status | Arrived, Checked Out, Cancel, Void, etc |
BookingTran. VoucherNo | VARCHAR(255) | Booking Voucher No | 10203049/8512 |
BookingTran. PackageCode | INT(20) | Package Code | 112500000000000001 |
BookingTran. PackageName | VARCHAR(1000) | Package Name | European Plan etc |
BookingTran. RateplanCode | INT(20) | Unique RatePlan Code | 112500000000000006 |
BookingTran. RateplanName | STRING(1000) | RatePlan Name | Grand Sea View Junior Suite |
BookingTran. RoomTypeCode | INT(20) | Unique RoomType Code | 112500000000000006 |
BookingTran. RoomTypeName | STRING(1000) | RoomType Name | Garden View Studio Room |
BookingTran. Start | DATE | Check-in date[Format : yyyy-mm-dd] | 2017-12-25 |
BookingTran. End | DATE | Check-out date [Format : yyyy-mm-dd] | 2017-12-27 |
BookingTran.TotalRate | DECIMAL(19,4) | Rate on room in amount | 1500.43 |
BookingTran. | DECIMAL(19,4) | Discount on room in | 500 |
TotalDiscount | Amount | ||
BookingTran. TotalExtraCharge | DECIMAL(19,4) | Extra charges in amount(if any) | 300 |
BookingTran. TotalPayment | DECIMAL(19,4) | Payment for room in amount | 2500.54 |
BookingTran.* | – | Here * denotes guest informations like Salutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Zip Code, Phone, Mobile, Fax, Email, RegistrationNo, IdentityType, IdentityNo, ExpiryDate. | |
BookingTran. TransportationMode | VARCHAR(100) | Mode of transportation | Bus, car etc |
BookingTran. Vehicle | VARCHAR(255) | Detail of vehicle | |
BookingTran. PickupDate | DATE | Pickup date[Format : yyyy-mm-dd] | 2017-12-25 etc |
BookingTran. PickupTime | TIME | Pickup time | |
BookingTran. Source | VARCHAR(1000) | Booking generated source | Booking.com |
BookingTran. Comment | VARCHAR(1000) | Additional Information or comment. | |
BookingTran. AffiliateName | VARCHAR(1000) | Booking Affiliate Name | |
BookingTran.AffiliateCode | VARCHAR(1000) | Booking Affiliate Code | |
BookingTran.* | – | Here * denotes Credit Card Informations like CCLink, CCNo, CCType, CardHolderName, CCExpiryDate,etc | CCLink in encoded with base64_encode. |
BookingTran.RentalInfo.EffectiveDate | DATETIME | Booking details for particular effective date | 2017-12-25 etc |
BookingTran.RentalInfo.PackageCode | INT(20) | Package code | 112500000000000001 |
BookingTran.RentalInfo.PackageName | VARCHAR(1000) | Package Name | European Plan |
BookingTran.RentalInfo.R oomTypeCode | INT(20) | Unique RoomType Code | 112500000000000006 |
BookingTran.RentalInfo.R oomTypeName | STRING(1000) | RoomType Name | Grand Sea View Junior Suite |
BookingTran.RentalInfo.Adult | INT(11) | No. of Adults | 2,3,4 etc |
BookingTran. RentalInfo.Child | INT(11) | No. of Childs | 2,3,4 etc |
BookingTran. RentalInfo.Rent | DECIMAL(19,4) | Room rental amount | 1500.43 |
BookingTran. RentalInfo.Discount | DECIMAL(19,4) | Discount on rental room in amount | 500 |
BookingTran.Sharer.* | – | Here * denotes Sharer informations like Salutation, FirstName, LastName, Gender, DateOfBirth, SpouseDateOfBirth, WeddingAnniversary, Nationality, Address, City, State, Country, Nationality,Zip Code, Phone, Mobile, Fax, Email,RegistrationNo,IdentityTypeID, IdentityNo, ExpiryDate. | |
Errors.ErrorCode | – | Response Error Code | 104, 404 etc |
Errors.ErrorMessage | – | Generate Response Message | Unauthorized Request. etc |
Success
1.Single Booking { "Reservations": { "Reservation": [ { "BookingTran": [ { "SubBookingId": "12341254", "TransactionId": "123400000000001902", "Createdatetime": "2019-09-04 11:40:30", "Modifydatetime": "2019-09-04 11:40:30", "Status": "New", "IsConfirmed": "1", "CurrentStatus": "Arrived", "VoucherNo": "single1276/1", "PackageCode": "123400000000000001", "PackageName": "European Plan", "RateplanCode": "123400000000000001", "RateplanName": "Sea View Deluxe Room", "RoomTypeCode": "123400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Start": "2019-09-26", "End": "2019-09-28", "ArrivalTime": "12:00:00", "DepartureTime": "11:00:00", "CurrencyCode": "USD", "TotalAmountAfterTax": "976.00", "TotalAmountBeforeTax": "800.00", "TotalTax": "176.00", "TotalDiscount": "0.00", "TotalExtraCharge": "0.00", "TotalPayment": "0.00", "TACommision": "0.00", "Salutation": "Ms.", "FirstName": "April", "LastName": "Myers", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": "Decorah", "State": "Decorah", "Country": "IA", "Nationality": "Malta", "Zipcode": "52101", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "AprilAMyers@jourrapide.com", "RegistrationNo" : "", "IdentityType": "Pan card", "IdentityNo": "12345667765", "ExpiryDate": "", "TransportationMode": "", "Vehicle": "car", "PickupDate": "", "PickupTime": "", "Source": "BookingEye", "Comment": "", "AffiliateName": "", "AffiliateCode": "", "CCLink": "", "CCNo": "", "CCType": "", "CCExpiryDate": "", "CardHoldersName": "", "TaxDeatil": [ { "TaxCode": "AA", "TaxName": "VAT @ 12%", "TaxAmount": "96.0000" }, { "TaxCode": "LT", "TaxName": "Luxury @ 10%", "TaxAmount": "80.0000" } ], "RentalInfo": [ { "EffectiveDate": "2019-09-26", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "4", "Child": "2", "RentPreTax": "550.00", "Rent": "671.00", "Discount": "0.00" }, { "EffectiveDate": "2019-09-27", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "4", "Child": "2", "RentPreTax": "250.00", "Rent": "305.00", "Discount": "0.00" } ], "Sharer": [ { "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "RegistrationNo" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", }, { "Salutation": "Ms.", "FirstName": "Test", "LastName": "Two", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "Registration No" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", } ] } ], "LocationId": "1124", "UniqueID": "11241254", "BookedBy": "BookingEye", "Salutation": "Ms.", "FirstName": "Hae ", "LastName": " Giles ", "Gender": "Female", "Address": " Garfield Road ", "City": "Peoria", "State": " Peoria ", "Country": "IL", "Zipcode": "61614", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "HaeWGiles@jourrapide.com", "Source": "BookingEye", "PaymentMethod": "Cash", "IsChannelBooking": "1" } ] } } 2.Multiple booking : { "Reservations": { "Reservation": [ { "BookingTran": [ { "SubBookingId": "11241254", "TransactionId": "112400000000001902", "Createdatetime": "2019-09-04 11:40:30", "Modifydatetime": "2019-09-04 11:40:30", "Status": "New", "IsConfirmed": "1", "VoucherNo": "single1276/1", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RateplanCode": "112400000000000001", "RateplanName": "Sea View Deluxe Room", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Start": "2019-09-26", "End": "2019-09-28", "ArrivalTime": "12:00:00", "DepartureTime": "11:00:00", "CurrencyCode": "USD", "TotalAmountAfterTax": "976.00", "TotalAmountBeforeTax": "800.00", "TotalTax": "176.00", "TotalDiscount": "0.00", "TotalExtraCharge": "0.00", "TotalPayment": "0.00", "TACommision": "0.00", "Salutation": "Ms.", "FirstName": "Lilly", "LastName": "Harper", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Peoria ", "State": "Peoria", "Country": "IL", "Nationality": "Malta", "Zipcode": "61614", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LillyJHarper@jourrapide.com", "RegistrationNo" : "", "IdentiyType": "Pan card", "IdentityNo": "12345667765", "ExpiryDate": "", "TransportationMode": "", "Vehicle": "car", "PickupDate": "", "PickupTime": "", "Source": "BookingEye", "Comment": "", "AffiliateName": "", "AffiliateCode": "", "CCLink": "", "CCNo": "", "CCType": "", "CCExpiryDate": "", "CardHoldersName": "", "TaxDeatil": [ { "TaxCode": "AA", "TaxName": "VAT @ 12%", "TaxAmount": "96.0000" }, { "TaxCode": "LT", "TaxName": "Luxury @ 10%", "TaxAmount": "80.0000" } ], "RentalInfo": [ { "EffectiveDate": "2019-09-26", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "4", "Child": "2", "RentPreTax": "550.00", "Rent": "671.00", "Discount": "0.00" }, { "EffectiveDate": "2019-09-27", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "4", "Child": "2", "RentPreTax": "250.00", "Rent": "305.00", "Discount": "0.00" } ] } ], "LocationId": "1124", "UniqueID": "11241254", "BookedBy": "BookingEye", "Salutation": "Ms.", "FirstName": "Hae ", "LastName": " Giles ", "Gender": "Female", "Address": " Garfield Road ", "City": "Peoria", "State": " Peoria ", "Country": "IL", "Zipcode": "61614", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "HaeWGiles@jourrapide.com", "Source": "BookingEye", "PaymentMethod": "Cash", "IsChannelBooking": "1" }, { "BookingTran": [ { "SubBookingId": "11241255", "TransactionId": "123450000000001903", "Createdatetime": "2019-09-10 11:31:57", "Modifydatetime": "2019-09-10 11:31:57", "Status": "New", "IsConfirmed": "1", "CurrentStatus": "Arrived", "VoucherNo": "", "PackageCode": "12340000000000001", "PackageName": "European Plan", "RateplanCode": "123450000000000001", "RateplanName": "Sea View Deluxe Room", "RoomTypeCode": "123450000000000001", "RoomTypeName": "Sea View Deluxe Room", "Start": "2019-09-11", "End": "2019-09-12", "ArrivalTime": "12:00:00", "DepartureTime": "11:00:00", "CurrencyCode": "USD", "TotalAmountAfterTax": "6832.00", "TotalAmountBeforeTax": "5600.00", "TotalTax": "1232.00", "TotalDiscount": "0.00", "TotalExtraCharge": "0.00", "TotalPayment": "0.00", "TACommision": "0.00", "Salutation": "Dr.", "FirstName": "Ellen", "LastName": "Novak", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": "", "State": "", "Country": "", "Nationality": "", "Zipcode": "", "Phone": "", "Mobile": "+123 456 7890", "Fax": "", "Email": "EllenDNovak@dayrep.com", "RegistrationNo" : "", "IdentiyType": "", "IdentityNo": "", "ExpiryDate": "", "TransportationMode": "", "Vehicle": "", "PickupDate": "", "PickupTime": "", "Source": "Internet Booking Engine", "Comment": "", "AffiliateName": "", "AffiliateCode": "", "CCLink": "", "CCNo": "", "CCType": "", "CCExpiryDate": "", "CardHoldersName": "", "TaxDeatil": [ { "TaxCode": "AA", "TaxName": "VAT @ 12%", "TaxAmount": "672.0000" }, { "TaxCode": "LT", "TaxName": "Luxury @ 10%", "TaxAmount": "560.0000" } ], "RentalInfo": [ { "EffectiveDate": "2019-09-11", "PackageCode": "123450000000000001", "PackageName": "European Plan", "RoomTypeCode": "123450000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "2", "Child": "0", "RentPreTax": "5600.00", "Rent": "6832.00", "Discount": "0.00" } ], "Sharer": [ { "Salutation": "Ms.", "FirstName": "Test", "LastName": "One", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "RegistrationNo" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", }, { "Salutation": "Ms.", "FirstName": "Test", "LastName": "Two", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Brockway", "State": "CA", "Country": "USA", "Nationality": "Malta", "Zipcode": "95730", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "LarryLForney@rhyta.com", "Registration No" : "", "IdentityTypeID": "894300000000000003", "IdentityNo": "12345667765", "ExpiryDate": "", } ] } ], "LocationId": "1234", "UniqueID": "11241255", "BookedBy": "Internet Booking Engine", "Salutation": "Dr.", "FirstName": "Audrey", "LastName": "Manuel", "Gender": "", "Address": "", "City": "", "State": "", "Country": "", "Zipcode": "", "Phone": "", "Mobile": "+1234567890", "Fax": "", "Email": "AudreyJManuel@armyspy.com", "Source": "Internet Booking Engine", "IsChannelBooking": "0" } ], "CancelReservation": [ { "LocationId": "1234", "UniqueID": "11241008-1", "Status": "Cancel", "Canceldatetime": "2019-05-08 14:21:16", "Remark": "Guest want to cancel reservation through Zenrooms", "VoucherNo": "100335/1" }, { "LocationId": "1234", "UniqueID": "11241008-2", "Status": "Cancel", "Canceldatetime": "2019-05-08 14:21:27", "Remark": "Guest want to cancel reservation through Zenrooms", "VoucherNo": "100335/2" }, { "LocationId": "1234", "UniqueID": "11241011", "Status": "Cancel", "Canceldatetime": "2019-05-08 14:18:57", "Remark": "Guest want to cancel reservation through Zenrooms", "VoucherNo": "1253911111/2" } ] } } 3.Modify Booking : { "Reservations": { "Reservation": [ { "BookingTran": [ { "SubBookingId": "12345254", "TransactionId": "123450000000001902", "Createdatetime": "2019-09-04 11:40:30", "Modifydatetime": "2019-09-04 11:40:30", "Status": "Modify", "IsConfirmed": "1", "VoucherNo": "single1276/1", "PackageCode": "123450000000000001", "PackageName": "European Plan", "RateplanCode": "112400000000000001", "RateplanName": "Sea View Deluxe Room", "RoomTypeCode": "123450000000000001", "RoomTypeName": "Sea View Deluxe Room", "Start": "2019-09-26", "End": "2019-09-28", "ArrivalTime": "12:00:00", "DepartureTime": "11:00:00", "CurrencyCode": "USD", "TotalAmountAfterTax": "976.00", "TotalAmountBeforeTax": "800.00", "TotalTax": "176.00", "TotalDiscount": "0.00", "TotalExtraCharge": "0.00", "TotalPayment": "0.00", "TACommision": "0.00", "Salutation": "Ms.", "FirstName": "Valentina", "LastName": "Riter", "Gender": "Female", "DateOfBirth": "", "SpouseDateOfBirth": "", "WeddingAnniversary": "", "Address": "", "City": " Peoria ", "State": "Peoria", "Country": "IL", "Nationality": "Malta", "Zipcode": "61614", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "ValentinaNRiter@jourrapide.com", "IdentiyType": "Pan card", "IdentityNo": "12345667765", "ExpiryDate": "", "TransportationMode": "", "Vehicle": "car", "PickupDate": "", "PickupTime": "", "Source": "BookingEye", "Comment": "", "AffiliateName": "", "AffiliateCode": "", "CCLink": "", "CCNo": "", "CCType": "", "CCExpiryDate": "", "CardHoldersName": "", "TaxDeatil": [ { "TaxCode": "AA", "TaxName": "VAT @ 12%", "TaxAmount": "96.0000" }, { "TaxCode": "LT", "TaxName": "Luxury @ 10%", "TaxAmount": "80.0000" } ], "RentalInfo": [ { "EffectiveDate": "2019-09-26", "PackageCode": "123450000000000001", "PackageName": "European Plan", "RoomTypeCode": "123450000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "4", "Child": "2", "RentPreTax": "550.00", "Rent": "671.00", "Discount": "0.00" }, { "EffectiveDate": "2019-09-27", "PackageCode": "112400000000000001", "PackageName": "European Plan", "RoomTypeCode": "112400000000000001", "RoomTypeName": "Sea View Deluxe Room", "Adult": "4", "Child": "2", "RentPreTax": "250.00", "Rent": "305.00", "Discount": "0.00" } ] } ], "LocationId": "1234", "UniqueID": "12345254", "BookedBy": "BookingEye", "Salutation": "Ms.", "FirstName": "Valentina", "LastName": "Riter", "Gender": "Female", "Address": "", "City": "Charlotte", "State": "Charlotte", "Country": "NC", "Zipcode": "28202", "Phone": "", "Mobile": "3534", "Fax": "564564", "Email": "ValentinaNRiter@jourrapide.com", "Source": "BookingEye", "PaymentMethod": "Cash", "IsChannelBooking": "1" } ] } } 4.Cancel Booking : { "Reservations": { "CancelReservation": [ { "LocationId": "xxxx", "UniqueID": "12345228-1", "Status": "Cancel", "Canceldatetime": "2019-08-14 16:33:38", "Remark": "", "VoucherNo": "" }, { "LocationId": "xxxx", "UniqueID": "12345228-2", "Status": "Cancel", "Canceldatetime": "2019-08-14 16:33:24", "Remark": "", "VoucherNo": "" } ] } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters. |
500 | Error occurred during processing |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive. |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |
Configuration
Retrieve Payment Gateways
This API provides all payment gateways which are available for your Booking Engine. The API can return data in JSON formats. The web service responds to HTTP GET requests. You need to take eZee Reservation to use this API.
End Point URL
[BaseUrl]booking/reservation_api/listing.php?APIKey=[API_KEY]&request_type=[Request_Type]&HotelCode=[Hotel_Code]
Header
Parameter
Name | Data Type | Description | Example |
[BaseUrl] * | – | Live server URL | https://live.ipms247.com/ |
[Request_Type] * | – | Use Keyword “ConfiguredPGList” | |
[Hotel_Code] * | INT(11) | Unique Hotel code | XXXX |
[API_KEY] * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXX |
Request
https://live.ipms247.com/booking/reservation_api/listing.php?APIKey=XX&request_type=ConfiguredPGList&HotelCode=XX
Response
Name | Data Type | Description | Example |
paymenttypeunkid | Integer(20) | Payment uniqueid | xxxxxxxxxxxx |
hotel_code | Integer(11) | Unique hotel code | 1234 |
shortcode | String | Short code | AirPay |
paymenttype | String | Source of business | AirPay |
Success
[ { "paymenttypeunkid": "4000000000000048", "hotel_code": "1234", "shortcode": "AirPay", "paymenttype": "AirPay” } ]
Error Codes
Error Code | Error Name |
HotelCodeEmpty | Hotel code is empty. |
NORESACC | This request is valid for Reservation Account only. You may not have opted for Reservation Account Or Hotel Code and Authentication are invalid. |
UNAUTHREQ | Unauthorized request. This request is not valid for this hotel code. |
2 | Cannot Parse Request |
DBConnectError | database not connected. |
-1 | No Data found. |
APIACCESSDENIED | Your property doesn’t have access to API integration or Key is incorrect. Please contact support for this. |
BadRequest | Bad request type. |
UnknownError | Unknown Error |
InvalidHotelCode | Invalid Hotel code.Please check your property code. |
Finance
Retrieve Extras
This API provides information of extra services available at your property which can be used in mapping or display purposes in the external applications. The API can return data in JSON formats.
URI Request
Request parameters are supplied by appending a question mark (?) to the base URI, followed by a sequence of parameter names and values separated by an ampersand (&).
End Point URL
[BaseUrl]booking/reservation_api/listing.php?[Request_Type]&HotelCode=[Hotel_Code]&APIKey=[API_KEY]&language=[LANGUAGE];
Header
Parameter
Name | Data Type | Description | Example |
[BaseUrl] * | – | Live server URL | https://live.ipms247.com/ |
[Request_Type] * | – | Use Keyword “ExtraCharges” | |
[Hotel_Code] * | INT(11) | Unique Hotel code | XXXX |
[API_KEY] * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
[LANGUAGE] | VARCHAR(20) | [Optional] Default is en. Pass language code. Language codes are available here. | en |
Request
https://live.ipms247.com/booking/reservation_api/listing.php?request_type=ExtraCharges&HotelCode=XXX&APIKey=XXX&language=en
Response
Name | Data Type | Description | Example |
ExtraChargeId | Integer(20) | Unique id of ExtraCharge | XXXXXXXXXXXXXXXXXX |
ShortCode | String | ShortCode of ExtraCharge | Transport |
charge | String | ExtraCharge name | Welcome Drink |
Description | String | ExtraCharge Description | |
Rate | Decimal | ExtraCharge Rate | 100 |
CharegeRule | String | Rule of ExtraCharge | PERQUANTITY |
PostingRule | String | Rule of posting ExtraCharge | ONLYCHECKOUT |
ValidFrom | Date | From date of ExtraCharge is valid | 2020-02-03 |
ValidTo | Date | To Date of Extracharge is valid | 2020-03-03 |
ischargealways | integer(1) | Is always charge or not, 0: not always charge, 1: always charge | 0 or 1 |
applyon_rateplan | Integer(20) | Rateplanid where ExtraCharge applied or ALL | XXXXXXXXXXXXXXXXXX |
applyon_special | Integer(20) | Specialid where ExtraCharge applied or ALL | ALL |
Success
[ { "ExtraChargeId": "XXXXXXXXXXXXXXXXXX", "ShortCode": "Bottle of Wine on Arrival", "charge": "Bottle of Wine on Arrival", "description": null, "Rate": "500.0000", "ChargeRule": "PERQUANTITY", "PostingRule": "ONLYCHECKOUT", "ValidFrom": null, "ValidTo": null, "ischargealways": "0", "applyon_rateplan": "XXXXXXXXXXXXXXXXXX", "applyon_special": "" }, { "ExtraChargeId": "XXXXXXXXXXXXXXXXXX", "ShortCode": "Transport", "charge": "Transport Services", "description": null, "Rate": "500.0000", "ChargeRule": "PERBOOKING", "PostingRule": "ONLYCHECKIN", "ValidFrom": null, "ValidTo": null, "ischargealways": "0", "applyon_rateplan": "ALL", "applyon_special": "ALL" } ]
Error Codes
Error Code | Error Name |
HotelCodeEmpty | Hotel code is empty. |
NORESACC | This request is valid for Reservation Account only. You may not have opted for Reservation Account Or Hotel Code and Authentication are invalid. |
UNAUTHREQ | Unauthorized request. This request is not valid for this hotel code. |
2 | Cannot Parse Request |
5 | Recoverable Error. Equivalent to http 503. |
CheckDate | Check out date should be greater than Check in date |
DBConnectError | Database not connected. |
getExtraChargeListError | Extra Charge List error |
-1 | No Data found. |
APIACCESSDENIED | Your property doesn’t have access to API integration or Key is incorrect. Please contact support for this. |
ParametersMissing | Missing parameters. |
UnknownError | Unknown Error |
4 | Timeout requested. Stops requests for the specified time. |
InvalidHotelCode | Invalid Hotel code.Please check your property code. |
BadRequest | Bad request type. |
Configuration
Retrieve Salutations and Country
This API provides information of salutations and country list available for your property which can be displayed in the external applications. The API can return data in JSON formats. The web service responds to HTTP GET requests.
URI Request
Request parameters are supplied by appending a question mark (?) to the base URI, followed by a sequence of parameter names and values separated by an ampersand (&).
End Point URL
[BaseUrl]booking/reservation_api/listing.php?request_type=[Request_Type]&HotelCode=[Hotel_Code]&APIKey=[API_KEY]&language=[LANGUAGE]
Header
Parameter
Name | Data Type | Description | Example |
[BaseUrl] * | – | Live server URL | https://live.ipms247.com/ |
[Request_Type] * | – | Use Keyword “ConfiguredDetails” | |
[Hotel_Code] * | INT(11) | Unique Hotel code | XXXX |
[API_KEY] * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
[LANGUAGE] | VARCHAR(20) | [Optional] Default is en. Pass language code. Language codes are available here. | Optional Default is en |
Request
https://live.ipms247.com/booking/reservation_api/listing.php?request_type=ConfiguredDetails&HotelCode=XXXX&APIKey=XXXXXX&language=en
Response
Name | Data Type | Description | Example |
Salution | String | Get salutation list | Dr,Jr |
Country List | String | Get country list | Afghanistan,Albania |
Success
{ "Salutation": { "DR": "Dr.", "JN": "Jn.", "MAM": "Mam.", "MR": "Mr.", "MRS": "Mrs.", "MS": "Ms.", "SIR": "Sir", "SR": "Sr." }, "CountryList": { "1": "Afghanistan", "2": "Albania", "3": "Algeria", ..... } }
Error Codes
Error Code | Error Name |
HotelCodeEmpty | Hotel code is empty. |
NORESACC | This request is valid for Reservation Account only. You may not have opted for Reservation Account Or Hotel Code and Authentication are invalid. |
UNAUTHREQ | Unauthorized request. This request is not valid for this hotel code. |
2 | Cannot Parse Request |
5 | Recoverable Error. Equivalent to http 503. |
DBConnectError | Database not connected. |
BadRequest | Bad request type. |
-1 | No Data found. |
APIACCESSDENIED | Your property doesn’t have access to API integration or Key is incorrect. Please contact support for this. |
ParametersMissing | Missing parameters. |
UnknownError | Unknown Error |
4 | Timeout requested. Stops requests for the specified time. |
InvalidHotelCode | Invalid Hotel code.Please check your property code. |
Configuration
Retrieve Room Types
This API provides limited information of roomtypes for a property which can be used for the mapping or display purpose in the external applications. The API can return data in JSON formats. The web service responds to HTTP GET requests.
URI Request
Request parameters are supplied by appending a question mark (?) to the base URI, followed by a sequence of parameter names and values separated by an ampersand (&).
End Point URL
[BaseUrl]booking/reservation_api/listing.php?request_type=[Request_Type]&HotelCode=[Hotel_Code]&APIKey=[API_KEY]&publishtoweb=1;
Header
Parameter
Name | Data Type | Description | Example |
[BaseUrl] * | – | Live server URL | https://live.ipms247.com/ |
[Request_Type] * | – | Use Keyword “RoomTypeList” | |
[Hotel_Code] * | INT(11) | Unique Hotel code | XXXX |
[API_KEY] * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
[LANGUAGE] | VARCHAR(20) | [Optional] Default is en. Pass language code. Language codes are available here. | en |
publishtoweb | TINYINT(1) | 1 – will retrieve all Room Types0 – will retrieve room types which are published to WEBDefault value is 0 | 0 OR 1 |
Request
https://live.ipms247.com/booking/reservation_api/listing.php?request_type=RoomTypeList&HotelCode=XXX&APIKey=XXX&language=en&publishtoweb=1
Response
Name | Data Type | Description | Example |
roomtypeunkid | INT(20) | Unique Room Type ID | 123400000000000001 |
roomtype | VARCHAR(255) | Room Type Name | Deluxe, Luxury |
base_adult_occupancy | INT(11) | Base adult occupancy in room | 2 |
base_child_occupancy | INT(11) | Base child occupancy in room | 2 |
max_adult_occupancy | INT(11) | Maximum adult occupancy in room | 4 |
max_child_occupancy | INT(11) | Maximum child occupancy in room | 4 |
Success
[ { "roomtypeunkid": "123400000000000001", "roomtype": "King", "shortcode": "KNG", "base_adult_occupancy": "2", "base_child_occupancy": "2", "max_adult_occupancy": "4", "max_child_occupancy": "4" }, { "roomtypeunkid": "123400000000000004", "roomtype": "Deluxe", "shortcode": "DLX", "base_adult_occupancy": "5", "base_child_occupancy": "5", "max_adult_occupancy": "6", "max_child_occupancy": "7" }, { "roomtypeunkid": "123400000000000006", "roomtype": "Suite River View", "shortcode": "SRV", "base_adult_occupancy": "3", "base_child_occupancy": "2", "max_adult_occupancy": "5", "max_child_occupancy": "3" } ]
Error Codes
Error Code | Error Name |
HotelCodeEmpty | Hotel code is empty. |
NORESACC | This request is valid for Reservation Account only. You may not have opted for Reservation Account Or Hotel Code and Authentication are invalid. |
UNAUTHREQ | Unauthorized request. This request is not valid for this hotel code. |
getRoomTypeListError | Room Type List error |
-1 | No Data found. |
APIACCESSDENIED | Your property doesn’t have access to API integration or Key is incorrect. Please contact support for this. |
ParametersMissing | Missing parameters. |
Configuration
Retrieve Hotel Amenities
This API provides list of hotels amenities of a property which is used for displaying on any website or external applications. The API can return data in JSON formats. The web service responds to HTTP GET requests.
URI Request:
Request parameters are supplied by appending a question mark (?) to the base URI, followed by a sequence of parameter names and values separated by an ampersand (&).
End Point URL
[BaseUrl]booking/reservation_api/listing.php?request_type=[Request_Type]&HotelCode=[Hotel_Code]&APIKey=[API_KEY]&language=[LANGUAGE];
Header
Parameter
Name | Data Type | Description | Example |
[BaseUrl] * | – | Live server URL | https://live.ipms247.com/ |
[Request_Type] * | – | Use Keyword “HotelAmenity” | – |
[Hotel_Code] * | INT(11) | Unique Hotel code | XXXX |
[API_KEY] * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXX |
[LANGUAGE] | VARCHAR(20) | [Optional] Default is en. Pass language code. Language codes are available here. | en |
Request
https://live.ipms247.com/booking/reservation_api/listing.php?request_type=HotelAmenity&HotelCode=XXX&APIKey=XXX&language=en
Success
[ { "amenity": "Chinar Hotel @ Spa Naftalan" }, { "amenity": "STD and IDD dialing access" }, { "amenity": "parking lot" }, { "amenity": "Fruit basket upon check-in" }, ]
Error Codes
Error Code | Error Name |
HotelCodeEmpty | Hotel code is empty. |
NORESACC | This request is valid for Reservation Account only. You may not have opted for Reservation Account Or Hotel Code and Authentication are invalid. |
UNAUTHREQ | Unauthorized request. This request is not valid for this hotel code. |
HotelAmenityListingError | Hotel amenity listing error. |
-1 | No Data found. |
APIACCESSDENIED | Your property doesn’t have access to API integration or Key is incorrect. Please contact support for this. |
ParametersMissing | Missing parameters. |
Configuration
Retrieve Hotel Information
This API provides the list of hotel information for groups or chains. This is mainly used for displaying data to the combo box only. The API can return data in JSON formats. The web service responds to HTTP GET requests.
URL Request:
Request parameters are supplied by appending a question mark (?) to the base URI, followed by a sequence of parameter names and values separated by an ampersand (&).
End Point URL
The base URI for the web service for Chain Properties is as follows :
[BaseUrl]booking/reservation_api/listing.php?request_type=[Request_Type]&GroupCode=[Group_Code]&APIKey=[API_KEY];
The base URI for the web service for Single Property is as follows :
[BaseUrl]booking/reservation_api/listing.php?request_type=[Request_Type]&HotelCode=[Hotel_Code]&APIKey=[API_KEY];
Header
Parameter
Name | Data Type | Description | Example |
[BaseUrl] * | – | Live server URL | https://live.ipms247.com/ |
[request_type] * | – | Use Keyword “HotelList” | – |
[GroupCode] * [HotelCode] * | INT(11) | Unique Group code Or Hotel code | XXXXXX or XXXX |
[APIKey] * | VARCHAR(300) | Unique Authentication code | XXXXXXXXXXXXXXXXX |
[LANGUAGE] | VARCHAR(20) | [Optional] Default is en. Pass language code. Language codes are available here. | en |
Single Properties – Request
https://live.ipms247.com/booking/reservation_api/listing.php?request_type=HotelList&HotelCode=XXXX&APIKey=XXXXXX&language=en
Chain Properties – Request
https://live.ipms247.com/booking/reservation_api/listing.php?request_type=HotelList&GroupCode=XXXXXX&APIKey=XXXXXX&language=en
Success
[ { "Hotel_Code": "xxxx", "Hotel_Name": "Hotel Abc", "City": "Surat", "State": "Guj", "Country": "India", "Property_Type": "Resort", "HotelImages": [ "abc1.jpg", "abc21.jpg", ] }, { "Hotel_Code": "xxxx", "Hotel_Name": "Hotel ZY", "City": "Surat", "State": "Gujarat", "Country": "India", "Property_Type": "Hotel", "HotelImages": [ "img.jpg" ] }, ]
Error Codes
Error Code | Error Name |
HotelCodeEmpty | Hotel code is empty. |
NORESACC | This request is valid for Reservation Account only. You may not have opted for Reservation Account Or Hotel Code and Authentication are invalid. |
UNAUTHREQ | Unauthorized request. This request is not valid for this hotel code. |
HotelListingError | Hotel List error |
-1 | No Data found. |
APIACCESSDENIED | Your property doesn’t have access to API integration or Key is incorrect. Please contact support for this. |
ParametersMissing | Missing parameters. |
Configuration
Retrieve Room Information
This API provides room types, rate types and rate plans information for a property. The API can return data in JSON formats. The web service responds to HTTP POST requests.
End Point URL
Header
Parameter
Name | Data Type | Description | Example |
Request_Type * | – | Use Keyword “RoomInfo” | |
NeedPhysicalRooms | INT(2) | If you need Room data, then put it “1”. It is optional | 1 / 0 |
HotelCode * | INT(11) | Unique Hotel code | xxxx |
AuthCode * | VARCHAR(300) | Unique Authentication code | xxxxxxxxxx |
Request
{ "RES_Request": { "Request_Type": "RoomInfo", "NeedPhysicalRooms":1, "Authentication": { "HotelCode": "xxxx", "AuthCode": "xxxxxxxxxxxx" } } }
Response
Name | Data Type | Description | Example |
RoomType.ID | Integer | Unique RoomType ID | 1234500000000000001 |
RoomType.Name | String | RoomType Name | Garden View Studio Room |
RoomType.Rooms. RoomID | Integer | Room Unique ID | 1234500000000000001 |
RoomType.Rooms. RoomName | String | Room Number/Name | 101 |
RateType.ID | Integer | Unique RateType ID | 1234500000000000001 |
RateType.Name | String | RateType Name | European Plan |
RatePlan.RatePlanID | Integer | Unique RatePlan ID | 1234500000000000001 |
RatePlan.Name | String | RatePlan Name | Garden View Studio Room |
RatePlan.RoomTypeID | Integer | RoomType ID | 1234500000000000001 |
RatePlan.RoomType | String | RoomType Name | Garden View Studio Room |
RatePlan.RateTypeID | Integer | RateType ID | 1234500000000000001 |
RatePlan.RateType | String | RateType Name | European Plan |
Errors.ErrorCode | – | Response Error Code | 301, 404 etc |
Errors.ErrorMessage | – | Generate Response Message | Success, Unauthorized Request etc. |
Success
{ "RoomInfo": { "RoomTypes": { "RoomType": [ { "ID": "1234500000000000001", "Name": "Sea View Deluxe Room", "Rooms": [ { "RoomID": "1234500000000000001", "RoomName": "101" }, { "RoomID": "1234500000000000002", "RoomName": "102" } }, { "ID": "1234500000000000002", "Name": "Garden View Studio Room", "Rooms": [ { "RoomID": "1234500000000000004", "RoomName": "201" }, { "RoomID": "1234500000000000005", "RoomName": "202" } } ] }, "RateTypes": { "RateType": [ { "ID": "1234500000000000001", "Name": "European Plan" }, { "ID": "1234500000000000002", "Name": "Continental Plan" }, { "ID": "1234500000000000005", "Name": "Indian Plan" } ] }, "RatePlans": { "RatePlan": [ { "RatePlanID": "1234500000000000001", "Name": "Sea View Deluxe Room", "RoomTypeID": "1234500000000000001", "RoomType": "Sea View Deluxe Room", "RateTypeID": "1234500000000000001", "RateType": "European Plan", "RatePlanType": "INDEPENDENT" }, { "RatePlanID": "1234500000000000015", "Name": "Garden View Studio Room", "RoomTypeID": "1234500000000000002", "RoomType": "Garden View Studio Room", "RateTypeID": "1234500000000000001", "RateType": "European Plan", "RatePlanType": "MASTER" } ] } }, "Errors": { "ErrorCode": "0", "ErrorMessage": "Success" } }
Error Codes
Error Code | Error Name |
100 | Missing required parameters. |
500 | Error occurred during processing |
502 | Request Type is missing |
101 | Hotel Code is missing |
102 | Authentication Code is missing |
301 | Unauthorized Request. Please check hotel code and authentication code |
302 | Unauthorized Request. Integration is not allowed |
303 | Auth Code is inactive. |
201 | Unauthorized request.(Request Type) request is not valid for this hotel code |
202 | Unauthorized request. Hotel code is not active |