Databases
StackOverflow2013
Postsdbo
POExpedia EAN / TravelNow search using city name issue
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExpedia EAN / TravelNow search using city name issue
    primarykey
    data
    text
    <p>I have implemented the EAN hotel search API using XML and PHP. And I have the following issue when searching and listing hotels.</p> <p>Search details</p> <pre><code>City - Soho Country - GB Arrival - Aug 1, 2013 Departure - Aug 2, 2013 Rooms - 1 room with 2 adults </code></pre> <p>Results in TravelNow site</p> <pre><code>http://www.travelnow.com/templates/331656/hotels/list?lang=en&amp;currency=GBP&amp;secureUrlFromDataBridge=https%3A%2F%2Fwww.travelnow.com&amp;requestVersion=V2&amp;destination=&amp;standardCheckin=8%2F1%2F2013&amp;standardCheckout=8%2F2%2F2013&amp;checkin=8%2F1%2F13&amp; amp;checkout=8%2F2%2F13&amp;rating=0&amp;targetId=AREA-d5cfc783-9e42-4440-9200-0bd17397c37f%7Clandmarks&amp;roomsCount=1&amp;rooms[0].adultsCount=2&amp;rooms[0].childrenCount=0&amp;filter.sortedBy=our_rec&amp;filter.hotelName=&amp;filter.lowPrice=0&amp;filter.travelerOpinion=0&amp;filter.breakfastIncluded=false&amp;subscriptionInfo.termsConditionAgreement=false&amp;subscriptionInfo.wantNews=false&amp;subscriptionInfo.wantNewsletters=false&amp;tab=list </code></pre> <p>In TravelNow site, we searched for Soho, London, United Kingdom as shown in the above URL</p> <p>Request sent</p> <pre><code>http://api.ean.com/ean-services/rs/hotel/v3/list?currencyCode=GBP&amp;minorRev=99&amp;apiKey=XXXXXXXXXXXXXXXXXXXXXXXX&amp;locale=en_US&amp;cid=XXXXXXXX&amp;sort=OVERALL_VALUE&amp;xml=&lt;HotelListRequest&gt;&lt;city&gt;Soho&lt;%2Fcity&gt;&lt;countryCode&gt;GB&lt;%2FcountryCode&gt;&lt;arrivalDate&gt;08%2F01%2F2013&lt;%2FarrivalDat e&gt;&lt;departureDate&gt;08%2F02%2F2013&lt;%2FdepartureDate&gt;&lt;numberOfResults&gt;25&lt;%2FnumberOfResults&gt;&lt;supplierType&gt;E%7CV&lt;%2FsupplierType&gt;&lt;supplierCacheTolerance&gt;MED_ENHANCED&lt;%2FsupplierCacheTolerance&gt;&lt;RoomGroup&gt;&lt;Room&gt;&lt;numberOfAdults&gt;2&lt;%2FnumberOfAdults&gt;&lt;%2FRoom&gt;&lt;%2FRoomGroup&gt;&lt;%2FHotelListRequest&gt; </code></pre> <p>Response received</p> <pre><code>&lt;ns2:HotelListResponse xmlns:ns2="http://v3.hotel.wsapi.ean.com/"&gt; &lt;EanWsError&gt; &lt;itineraryId&gt;-1&lt;/itineraryId&gt; &lt;handling&gt;UNKNOWN&lt;/handling&gt; &lt;category&gt;EXCEPTION&lt;/category&gt; &lt;exceptionConditionId&gt;-1&lt;/exceptionConditionId&gt; &lt;presentationMessage&gt;No Results Available&lt;/presentationMessage&gt; &lt;verboseMessage&gt;Result was null&lt;/verboseMessage&gt; &lt;ServerInfo serverTime="05:45:17.821-0500" timestamp="1375181117" instance="54"/&gt; &lt;/EanWsError&gt; &lt;customerSessionId&gt;0ABAAA36-B023-AF91-4022-F2DA5EE95A74&lt;/customerSessionId&gt; &lt;/ns2:HotelListResponse&gt; </code></pre> <p>I also searched with city string "Soho, London, United Kingdom" given for city/destinationString didn't list any hotel. We used API tester <a href="http://devhub.ean.com/apitester/index.html" rel="nofollow">http://devhub.ean.com/apitester/index.html</a> too and received the same results.</p> <p>This search mostly says no results for many cities in London. We tried "destinationString" based search shown in <a href="http://developer.ean.com/docs/read/hotel_list/examples/XML_Alternatives" rel="nofollow">http://developer.ean.com/docs/read/hotel_list/examples/XML_Alternatives</a> but didn't work either. How do we need to pass the destination/city? Even when it shows hotels they are not in/around the given city.</p> <p>Let us know how to implement the above request to work properly to list the hotels in a given city. This works only for a few cities we have listed in the search. Shown below is a list of exact city names in London we use to pass in the request, inside the block. If below city names are incorrect, then how do they need to be corrected?</p> <p>Bayswater-Paddington, Belgravia, Bloomsbury-Soho, Canary Wharf-Docklands, Camden Town, Chelsea, Chelsea-Knightsbridge, City of Westminster, Chinatown, East End, Fulham, Greenwich, Holborn, Hammersmith, Hampstead, Hampstead-Camden Town, Hounslow, Islington, Knightsbridge, Kensington, Lambeth, London, London area, Mayfair, Mayfair-Marylebone, Marylebone, Pimlico, St. Pancras - Islington, Soho, Southwark-Waterloo</p> <p>Please help with a REST/XML request string that works for the above city/cities.</p> <p>I haven't accepted any of the current answers but are looking for more correct answers that rings a bell.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTechyTee
    1. USTechyTee
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POExpedia EAN / TravelNow search using city name issue
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt is because you send the destination string "soho" but in Ean Api Name of city is "SoHo". That's why the error is shown to resolve that you may try my code given below.
      singulars
      1. POExpedia EAN / TravelNow search using city name issue
      1. USchirag Nandwani
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload