7. Static Rates and Availability

This method will allow you to get the full rates and availability files and store them on your system, allowing you do show rates without the need to use the API.
The Static Rates and Availability method is aimed at accounts who for different reasons cannot work with the default pull mechanism. Due to the high cost of this method, it will be enabled for high-volume accounts only, and with a setup fee and a monthly fee, as well as a high monthly minimum booking threshold.

Send an XML request using your regular Mishor credentials and get the latest available file. Note that you will need to the HTTP request to a different server, given to you by your account manager:

Request:
<request version="4.0">
  <auth>
    <username>example</username>
    <password>example</password>
    <agent>example</agent>
  </auth>
  <hotel-static-results>
     <entity entityType="location" entityID="3474" />
     <entity entityType="location" entityID="1234" />
     ...
  </hotel-static-results>
</request>

Response:

<response success="1" time="2016-01-23 13:49:32" session="xx.123456789">
  <hotel-static-results>
    <entity entityType="location" entityID="3474">
      <item>http://files.push.innstant-servers.com/xxx/static_xxx.csv</item>
      <item>http://files.push.innstant-servers.com/xxx/availability_xxx.csv</item>
    </entity>
    <entity entityType="location" entityID="1234">
      <item>http://files.push.innstant-servers.com/xxx/static_xxx.csv</item>
      <item>http://files.push.innstant-servers.com/xxx/availability_xxx.csv</item>
    </entity>
  </hotel-static-results>
</response>

for each service opened on your account for static handling, you will get a node with a url to download a zip file containing an XML with the static data.

The rates and availability files are CSV files, and the content is based on the client account setup.  every few hours a new .zip file is generated with a CSV file for each city, so if for example your account is set up with 1,000 cities - you will get a .zip file with 1,000 csv files inside.
The structure of the files is as follows:

static_xxx.csv file, static information about rooms available for booking:

 FieldType Comments 
 HotelIDIntThe hotel id the room belongs to
 RoomIDStringunique identifier of the specific room in the hotel, for example "6077-standard-twin" 
 RoomTypeStringThe type of the room, i.e. "standard", "deluxe", etc.
 RoomBeddingStringThe bedding type, i.e. "twin", "double", etc.
 BoardCodeBoard Code2 letter board code, see lookups for a full list


availability_xxx.csv file,availability and pricing data for the rooms available for booking:

 FieldType Comments 
 HotelIDInt The hotel id the room belongs to
 DateDateYYYY-MM-DD, the date the rate belongs to
 RoomIDStringunique identifier of the specific room in the hotel, for example "6077-standard-twin"
 AmountUSDFloatUSD Amount of the cost per stay for this date 
 BoardCodeBoard Code2 letter board code, see lookups for a full list
 RoomPaxIntNumber of pax that fit in the specific room 
 CancellationDateDateYYYY-MM-DD the date until when the cancellation is free of charge 
 CancellationPenaltyUSDFloatThe cancellation penalty in USD 

Notes:
  1. CancellationDate and CancellationPenaltyUSD can be empty, this DOES NOT mean there is no cancellation fee, it only means that it is unknown during this time and should be queried using the booking-info method ONLY when a user is interested in a specific room. 


Subpages (1): Deprecated version
Comments