Lookups

What are lookups for?

Lookups are used for you to access data in your system as XML. For example, if you want to find out which airports are mapped to which resorts in your system, you can use the airport geography lookup, which will return a list of those mappings in XML format.

The precise XML structure for every currently available lookup is listed in detail on this page.

How to use lookups

To use a lookup you have to visit the URL for that lookup, which will be in the following format. Note: The login and password fields will be deprecated in future versions and the call will not require authentication.

http://[YourURL]/lookups/lookups.ashx?login=[YourLogin]&password=[YourPassword]&files=[file1,file2,file3...]

The URL will return an XML document containing a list of the data you've requested.

For example, you might visit http://demo.ivectorconnect.co.uk/lookups/lookups.ashx?login=me&password=mypassword&files=propertyroomtype to retrieve a list of property room types and receive the following XML:

How are lookups different to REST requests?

Notice that for a lookup, you need to include in the querystring your login and password. This is not required for the REST request so the data returned from REST requests is accessible by anyone with the correct URL. To access lookups, only a URL containing a valid login and password will return results.

Lookups also have the advantage that a large range of lookups are already set up for a range of different content. These are available to all clients, regardless of set up whereas some setups do not use REST requests.

Available lookups

The current files available for download via this method are

• AdhocComponentType

• Airport

• AirportGeography

• AirportGroup

• AirportGroupAirport

• AirportGroupResort

• AirportGroupRouteAvailability

• AirportTerminal

• Bonding

• BookingAdjustmentType

• BookingCommentType

• BookingComponent

• BookingCountry

• BookingCountryRegion

• BookingDescription

• BookingDocumentation

• BookingSource

• Brand

• BrandGeography

• CardType

• CarHireDepot

• CarHireDepotGeographyLevel3

• CarType

• CommentType

• ContractBenefit

• ContractSupplement

• CreditCardType

• Currency

• ExchangeRates

• Extra

• ExtraCategory

• ExtraDuration

• ExtraGroup

• ExtraSubType

• ExtraSupplement

• ExtraType

• FareType

• FilterFacility

• FlightCarrier

• FlightCarrierPrefix

• FlightClass

• FlightImport

• FlightSupplierRoute

• GeographyDateBand

• GeographyGrouping

• GeographyGroupingGeography

• GeographyGroups

• Landmark

• Language

• Location

• MarketingCode

• MealBasis

• MealBasisGroup

• Nationality

• OffsitePaymentType

• PackageName

• PaymentType

• Port

• ProductAttributes

• PropertyReference

• PropertyRoomType

• PropertyType

• RefundType

• RoomType

• RoomView

• RouteAvailability

• SalesChannel

• SellingExchangeRates

• SSRCodes

• StarRating

• Station

• Supplier

• SupplierCountry

• SystemUser

• ThirdParty

• Titles

• TPCarContent

• TPCarHireDepot

• TrackingAffiliate

• Trade

• TradeContact

• TradeContactGroup

• TradeGroup

• TradeSets

• Trailer

• TransferVehicle

• TranslatedAirport

• TranslatedAirportGroup

• TranslatedLocation

• TranslatedGeographyGrouping

• URL301Redirect

• Vehicle

* This list was last updated October 2024. *

Examples

Airports and Airport Geographies

To retrieve a list of airports and airport geographies (i.e. a list of which resorts the airports are mapped to) set up in the system for Test Travel, the user visits the following URL:

URL

http://demo.ivectorconnect.co.uk/lookups/lookups.ashx?login=TestLogin&password=TestPassword&files=airport,airportgeography

Response

<Lookups>

<Airports>

<Airport>

<Airport>Bergamo</Airport>

<IATACode>BGV</IATACode>

<AirportID>1</AirportID>

<Type>Departure and Arrival</Type>

<OffsetDays>0</OffsetDays>

<HolidayDurationType>Departure to Departure</HolidayDurationType>

<GeographyLevel1D>21</GeographyLevel1ID>

<GeographyLevel1Name>Italy</GeographyLevel1Name>

<Latitude>45.66972459187415</Latitude>

<Longitude>9.70367431640092</Longitude>

</Airport>

<Airport>

<Airport>Tenerife South</Airport>

<IATACode>TFS</IATACode>

<AirportID>2</AirportID>

<Type>Departure and Arrival</Type>

<OffsetDays>0</OffsetDays>

<GeographyLevel1ID>7</GeographyLevel1ID>

<GeographyLevel1Name>Canary Islands</GeographyLevel1Name>

</Airport>

</Airports>

<AirportGeographies>

<AirportGeography>

<AirportID>1</AirportID>

<GeographyLevel3ID>12</GeographyLevel3ID>

</AirportGeography>

<AirportGeography>

<AirportID>2</AirportID>

<GeographyLevel3ID>43</GeographyLevel3ID>

</AirportGeography>

<AirportGeographies>

</Lookups>