GET hotels/{hotelId}/reservations/guestprofile?key={key}&fromDate={fromDate}&toDate={toDate}

Gets all Reservations for the hotel specified that will arrive on a specific date range (max. 60 days) and their related Guest Profiles. Checked-in, checked-out and cancelled reservations are not returned.

Request Information

URI Parameters

Name	Description	Type	Additional information
hotelId	Hotel-Id => checked against the calling applications permissions	string	Required
key	API - Key identifying the caller	string	Required
fromDate	Start of Date Range, Format YYYY-MM-DD	date	Required
toDate	End of Date Range, Format YYYY-MM-DD	date	Required

Body Parameters

None.

Response Information

Resource Description

List of reservationsGuestProfile

Collection of ReservationGuestProfile

Name	Description	Type	Additional information
AcceptGeneralEmail	Accept General Email - "Y" will be sent for yes, "N" will be sent for no (related to your "reservation email")	string	None.
AddressLine1	Guest's first address line	string	None.
AddressLine2	Guest's secound address line	string	None.
ArrivalDate	The date guest arrive to the hotel	string	None.
AvailableCredit	Guests available credit, Credit Limit minus already accured charges	decimal number	None.
BookingNumber	reservation number	string	None.
CancellationNumber	The Cancellation Number that is assigned to a Cancelled Reservation	integer	None.
Cell1	Guests main Cell phone	string	None.
Cell2	Guests secondary Cell-Phone (e.g. work)	string	None.
CentralReservationNumber	Central reservation Number	string	None.
City	Guest's city	string	None.
CompanyEmailAddress	Travel agency email address	string	None.
CompanyFaxNumber	Travel agency Fax number	string	None.
CompanyName	Tarvel agency name	string	None.
CompRate	Comp Rate ('Y' if $0 rate, or 'N')	string	None.
Contact	Travel agent contact	string	None.
ContactEmailAddress	Travel agent contact email address	string	None.
ContactFaxNumber	Travel agent contact fax number	string	None.
CountryCode	Guest's country code	string	None.
DepartureDate	The date guest does checking out	string	None.
DepositPaid	Deposit amount that guests pay	decimal number	None.
EmailAddress	Guest's email address	string	None.
FirstName	Guest's first name	string	None.
FolioNumber	Displays lowest Folio number being used on Guest Folio	integer	None.
GuestId	Guest Identifier	string	None.
GuestType	Client Type (System Configuration -> Client Type -> Name)	string	None.
IsGuestTaxExempt	Is guest tax excempt	boolean	None.
JoinLoyalty	Guest would like to join loyalty return one, if not zero.	integer	None.
LastName	Guest's last name	string	None.
LastUpdateDate	Last update date i.e.: date when the reservation was created in RoomKey database, checked-in, checked-out, cancelled - whichever is the most recent one	string	None.
LoyaltyNumber	Guests loyalty number	string	None.
MailToFlag	Guest wants to receive email	boolean	None.
MarketingCode	Associated with Client Type Grouping found in RoomKey under System Configuration -> Client Types	string	None.
MarketSegment	Rate Plan Market Segment	string	None.
MarketingOptIn	Marketing Opt In - "Y" will be sent for yes, "N" will be sent for no (related to your "marketing campaigns")	string	None.
MiddleInitial	[deprecated] Field not available in system	string	None.
NumberOfActualNights	Number of actual nights guest stay at the hotel	decimal number	None.
NumberOfAdults	Number of adults	integer	None.
NumberOfChildren	Number of childeren	integer	None.
NumberOfNights	Number of booked nights	integer	None.
OtherRevenue	Other revenue except room revenue	decimal number	None.
PackageCode	Code associated with Package booked - found under System Configuration -> Packages and Inclusions -> Short Name	string	None.
PaymentType	Type of payment	string	None.
Phone1	Guests main Phone	string	None.
Phone2	Guests secondary phone (e.g. work)	string	None.
PreferredContactMethod	[deprecated] Field not available in system	string	None.
PromoCode	Code associated with Online Booking Promotion booked - found under System Configuration -> Online Booking Promotions -> Promo Name	string	None.
PropertyCode	Hotel code	string	None.
RateCode	Rate Code name	string	None.
RecordType	Record Type S = Guest Stay Data, R = reservation Data *Required if reservation Data is sent	string	None.
ReservationDate	Date the reservation is made	string	None.
ReservationRates	Reservation Daily Rates	Collection of ReservationRate	None.
ReservationServices	Reservation Guest Service Detail	Collection of ReservationService	None.
ReservationUniqueIDs	Reservation Guest Service Detail	Collection of ReservationUniqueID	None.
ResortFee	[deprecated] Field not available in system	decimal number	None.
RoomNumber	Room number	string	None.
RoomRate	Daily rate of the room	decimal number	None.
RoomRevenue	Room revenue	decimal number	None.
RoomTypeCode	Code of room type	string	None.
SourceOfBusiness	Source of business (SOB), e.g. "Application", "CallCentre", "Email", "Facebook", "Fax", "Instagram", ...	string	None.
StateCode	Guest's state or province	string	None.
Status	Reservation status, i.e. "In House", "Reserved", "Canceled", "Checked out" Endpoints that return only a specific reservation status usually return this field blank.	string	None.
Taxes	Total taxes	decimal number	None.
TelephoneNumber	[deprecated] Please use the Phone1 field	string	None.
TimeofCheckOut	The time guest does checking out	string	None.
Title	Guest's title	string	None.
TotalRevenue	Total revenue: room revenue + other revenue + taxes	decimal number	None.
TotalRevenueWithoutTaxes	Total revenue without taxes: room revenue + other revenue	decimal number	None.
TravelAgent	Travel Agent name	string	None.
TravelAgentEmailAddress	Travel agent email address	string	None.
TravelAgentFaxNumber	Travel agent fax number	string	None.
TravelAgentIATA	Travel Agent IATA Number	string	None.
VIP	VIP indicator	boolean	None.
VIPCode	VIP guest's code	string	None.
ZipCode	Guest's ZIP code	string	None.
VehicleLicensePlate	Guest Vehicle Licence plate #	string	None.
VehicleMake	Guest Vehicle Make	string	None.
VehicleModel	Guest Vehicle Model	string	None.
VehicleColor	Guest Vehicle Color	string	None.
GroupId		string	None.
GroupName		string	None.
CorporateId		string	None.
CorporateName		string	None.
WholeSalerId		string	None.
WholeSalerName		string	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "AcceptGeneralEmail": "sample string 1",
    "AddressLine1": "sample string 2",
    "AddressLine2": "sample string 3",
    "ArrivalDate": "sample string 4",
    "AvailableCredit": 5.0,
    "BookingNumber": "sample string 6",
    "CancellationNumber": 1,
    "Cell1": "sample string 7",
    "Cell2": "sample string 8",
    "CentralReservationNumber": "sample string 9",
    "City": "sample string 10",
    "CompanyEmailAddress": "sample string 11",
    "CompanyFaxNumber": "sample string 12",
    "CompanyName": "sample string 13",
    "CompRate": "sample string 14",
    "Contact": "sample string 15",
    "ContactEmailAddress": "sample string 16",
    "ContactFaxNumber": "sample string 17",
    "CountryCode": "sample string 18",
    "DepartureDate": "sample string 19",
    "DepositPaid": 20.0,
    "EmailAddress": "sample string 21",
    "FirstName": "sample string 22",
    "FolioNumber": 23,
    "GuestId": "sample string 24",
    "GuestType": "sample string 25",
    "IsGuestTaxExempt": true,
    "JoinLoyalty": 27,
    "LastName": "sample string 28",
    "LastUpdateDate": "sample string 29",
    "LoyaltyNumber": "sample string 30",
    "MailToFlag": true,
    "MarketingCode": "sample string 32",
    "MarketSegment": "sample string 33",
    "MarketingOptIn": "sample string 34",
    "MiddleInitial": "sample string 35",
    "NumberOfActualNights": 36.1,
    "NumberOfAdults": 37,
    "NumberOfChildren": 38,
    "NumberOfNights": 39,
    "OtherRevenue": 40.0,
    "PackageCode": "sample string 41",
    "PaymentType": "sample string 42",
    "Phone1": "sample string 43",
    "Phone2": "sample string 44",
    "PreferredContactMethod": "sample string 45",
    "PromoCode": "sample string 46",
    "PropertyCode": "sample string 47",
    "RateCode": "sample string 48",
    "RecordType": "sample string 49",
    "ReservationDate": "sample string 50",
    "ReservationRates": [],
    "ReservationServices": [],
    "ReservationUniqueIDs": [],
    "ResortFee": 51.0,
    "RoomNumber": "sample string 52",
    "RoomRate": 53.0,
    "RoomRevenue": 54.0,
    "RoomTypeCode": "sample string 55",
    "SourceOfBusiness": "sample string 56",
    "StateCode": "sample string 57",
    "Status": "sample string 58",
    "Taxes": 59.0,
    "TelephoneNumber": "sample string 60",
    "TimeofCheckOut": "sample string 61",
    "Title": "sample string 62",
    "TotalRevenue": 63.0,
    "TotalRevenueWithoutTaxes": 64.0,
    "TravelAgent": "sample string 65",
    "TravelAgentEmailAddress": "sample string 66",
    "TravelAgentFaxNumber": "sample string 67",
    "TravelAgentIATA": "sample string 68",
    "VIP": true,
    "VIPCode": "sample string 70",
    "ZipCode": "sample string 71",
    "VehicleLicensePlate": "sample string 72",
    "VehicleMake": "sample string 73",
    "VehicleModel": "sample string 74",
    "VehicleColor": "sample string 75",
    "GroupId": "sample string 76",
    "GroupName": "sample string 77",
    "CorporateId": "sample string 78",
    "CorporateName": "sample string 79",
    "WholeSalerId": "sample string 80",
    "WholeSalerName": "sample string 81"
  },
  {
    "AcceptGeneralEmail": "sample string 1",
    "AddressLine1": "sample string 2",
    "AddressLine2": "sample string 3",
    "ArrivalDate": "sample string 4",
    "AvailableCredit": 5.0,
    "BookingNumber": "sample string 6",
    "CancellationNumber": 1,
    "Cell1": "sample string 7",
    "Cell2": "sample string 8",
    "CentralReservationNumber": "sample string 9",
    "City": "sample string 10",
    "CompanyEmailAddress": "sample string 11",
    "CompanyFaxNumber": "sample string 12",
    "CompanyName": "sample string 13",
    "CompRate": "sample string 14",
    "Contact": "sample string 15",
    "ContactEmailAddress": "sample string 16",
    "ContactFaxNumber": "sample string 17",
    "CountryCode": "sample string 18",
    "DepartureDate": "sample string 19",
    "DepositPaid": 20.0,
    "EmailAddress": "sample string 21",
    "FirstName": "sample string 22",
    "FolioNumber": 23,
    "GuestId": "sample string 24",
    "GuestType": "sample string 25",
    "IsGuestTaxExempt": true,
    "JoinLoyalty": 27,
    "LastName": "sample string 28",
    "LastUpdateDate": "sample string 29",
    "LoyaltyNumber": "sample string 30",
    "MailToFlag": true,
    "MarketingCode": "sample string 32",
    "MarketSegment": "sample string 33",
    "MarketingOptIn": "sample string 34",
    "MiddleInitial": "sample string 35",
    "NumberOfActualNights": 36.1,
    "NumberOfAdults": 37,
    "NumberOfChildren": 38,
    "NumberOfNights": 39,
    "OtherRevenue": 40.0,
    "PackageCode": "sample string 41",
    "PaymentType": "sample string 42",
    "Phone1": "sample string 43",
    "Phone2": "sample string 44",
    "PreferredContactMethod": "sample string 45",
    "PromoCode": "sample string 46",
    "PropertyCode": "sample string 47",
    "RateCode": "sample string 48",
    "RecordType": "sample string 49",
    "ReservationDate": "sample string 50",
    "ReservationRates": [],
    "ReservationServices": [],
    "ReservationUniqueIDs": [],
    "ResortFee": 51.0,
    "RoomNumber": "sample string 52",
    "RoomRate": 53.0,
    "RoomRevenue": 54.0,
    "RoomTypeCode": "sample string 55",
    "SourceOfBusiness": "sample string 56",
    "StateCode": "sample string 57",
    "Status": "sample string 58",
    "Taxes": 59.0,
    "TelephoneNumber": "sample string 60",
    "TimeofCheckOut": "sample string 61",
    "Title": "sample string 62",
    "TotalRevenue": 63.0,
    "TotalRevenueWithoutTaxes": 64.0,
    "TravelAgent": "sample string 65",
    "TravelAgentEmailAddress": "sample string 66",
    "TravelAgentFaxNumber": "sample string 67",
    "TravelAgentIATA": "sample string 68",
    "VIP": true,
    "VIPCode": "sample string 70",
    "ZipCode": "sample string 71",
    "VehicleLicensePlate": "sample string 72",
    "VehicleMake": "sample string 73",
    "VehicleModel": "sample string 74",
    "VehicleColor": "sample string 75",
    "GroupId": "sample string 76",
    "GroupName": "sample string 77",
    "CorporateId": "sample string 78",
    "CorporateName": "sample string 79",
    "WholeSalerId": "sample string 80",
    "WholeSalerName": "sample string 81"
  }
]

application/xml, text/xml

Sample:

<ArrayOfReservationGuestProfile xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/RoomKeyAPI.Models">
  <ReservationGuestProfile>
    <AcceptGeneralEmail>sample string 1</AcceptGeneralEmail>
    <AddressLine1>sample string 2</AddressLine1>
    <AddressLine2>sample string 3</AddressLine2>
    <ArrivalDate>sample string 4</ArrivalDate>
    <AvailableCredit>5</AvailableCredit>
    <BookingNumber>sample string 6</BookingNumber>
    <CancellationNumber>1</CancellationNumber>
    <Cell1>sample string 7</Cell1>
    <Cell2>sample string 8</Cell2>
    <CentralReservationNumber>sample string 9</CentralReservationNumber>
    <City>sample string 10</City>
    <CompRate>sample string 14</CompRate>
    <CompanyEmailAddress>sample string 11</CompanyEmailAddress>
    <CompanyFaxNumber>sample string 12</CompanyFaxNumber>
    <CompanyName>sample string 13</CompanyName>
    <Contact>sample string 15</Contact>
    <ContactEmailAddress>sample string 16</ContactEmailAddress>
    <ContactFaxNumber>sample string 17</ContactFaxNumber>
    <CorporateId>sample string 78</CorporateId>
    <CorporateName>sample string 79</CorporateName>
    <CountryCode>sample string 18</CountryCode>
    <DepartureDate>sample string 19</DepartureDate>
    <DepositPaid>20</DepositPaid>
    <EmailAddress>sample string 21</EmailAddress>
    <FirstName>sample string 22</FirstName>
    <FolioNumber>23</FolioNumber>
    <GroupId>sample string 76</GroupId>
    <GroupName>sample string 77</GroupName>
    <GuestId>sample string 24</GuestId>
    <GuestType>sample string 25</GuestType>
    <IsGuestTaxExempt>true</IsGuestTaxExempt>
    <JoinLoyalty>27</JoinLoyalty>
    <LastName>sample string 28</LastName>
    <LastUpdateDate>sample string 29</LastUpdateDate>
    <LoyaltyNumber>sample string 30</LoyaltyNumber>
    <MailToFlag>true</MailToFlag>
    <MarketSegment>sample string 33</MarketSegment>
    <MarketingCode>sample string 32</MarketingCode>
    <MarketingOptIn>sample string 34</MarketingOptIn>
    <MiddleInitial>sample string 35</MiddleInitial>
    <NumberOfActualNights>36.1</NumberOfActualNights>
    <NumberOfAdults>37</NumberOfAdults>
    <NumberOfChildren>38</NumberOfChildren>
    <NumberOfNights>39</NumberOfNights>
    <OtherRevenue>40</OtherRevenue>
    <PackageCode>sample string 41</PackageCode>
    <PaymentType>sample string 42</PaymentType>
    <Phone1>sample string 43</Phone1>
    <Phone2>sample string 44</Phone2>
    <PreferredContactMethod>sample string 45</PreferredContactMethod>
    <PromoCode>sample string 46</PromoCode>
    <PropertyCode>sample string 47</PropertyCode>
    <RateCode>sample string 48</RateCode>
    <RecordType>sample string 49</RecordType>
    <ReservationDate>sample string 50</ReservationDate>
    <ReservationRates />
    <ReservationServices />
    <ReservationUniqueIDs />
    <ResortFee>51</ResortFee>
    <RoomNumber>sample string 52</RoomNumber>
    <RoomRate>53</RoomRate>
    <RoomRevenue>54</RoomRevenue>
    <RoomTypeCode>sample string 55</RoomTypeCode>
    <SourceOfBusiness>sample string 56</SourceOfBusiness>
    <StateCode>sample string 57</StateCode>
    <Status>sample string 58</Status>
    <Taxes>59</Taxes>
    <TelephoneNumber>sample string 60</TelephoneNumber>
    <TimeofCheckOut>sample string 61</TimeofCheckOut>
    <Title>sample string 62</Title>
    <TotalRevenue>63</TotalRevenue>
    <TotalRevenueWithoutTaxes>64</TotalRevenueWithoutTaxes>
    <TravelAgent>sample string 65</TravelAgent>
    <TravelAgentEmailAddress>sample string 66</TravelAgentEmailAddress>
    <TravelAgentFaxNumber>sample string 67</TravelAgentFaxNumber>
    <TravelAgentIATA>sample string 68</TravelAgentIATA>
    <VIP>true</VIP>
    <VIPCode>sample string 70</VIPCode>
    <VehicleColor>sample string 75</VehicleColor>
    <VehicleLicensePlate>sample string 72</VehicleLicensePlate>
    <VehicleMake>sample string 73</VehicleMake>
    <VehicleModel>sample string 74</VehicleModel>
    <WholeSalerId>sample string 80</WholeSalerId>
    <WholeSalerName>sample string 81</WholeSalerName>
    <ZipCode>sample string 71</ZipCode>
  </ReservationGuestProfile>
  <ReservationGuestProfile>
    <AcceptGeneralEmail>sample string 1</AcceptGeneralEmail>
    <AddressLine1>sample string 2</AddressLine1>
    <AddressLine2>sample string 3</AddressLine2>
    <ArrivalDate>sample string 4</ArrivalDate>
    <AvailableCredit>5</AvailableCredit>
    <BookingNumber>sample string 6</BookingNumber>
    <CancellationNumber>1</CancellationNumber>
    <Cell1>sample string 7</Cell1>
    <Cell2>sample string 8</Cell2>
    <CentralReservationNumber>sample string 9</CentralReservationNumber>
    <City>sample string 10</City>
    <CompRate>sample string 14</CompRate>
    <CompanyEmailAddress>sample string 11</CompanyEmailAddress>
    <CompanyFaxNumber>sample string 12</CompanyFaxNumber>
    <CompanyName>sample string 13</CompanyName>
    <Contact>sample string 15</Contact>
    <ContactEmailAddress>sample string 16</ContactEmailAddress>
    <ContactFaxNumber>sample string 17</ContactFaxNumber>
    <CorporateId>sample string 78</CorporateId>
    <CorporateName>sample string 79</CorporateName>
    <CountryCode>sample string 18</CountryCode>
    <DepartureDate>sample string 19</DepartureDate>
    <DepositPaid>20</DepositPaid>
    <EmailAddress>sample string 21</EmailAddress>
    <FirstName>sample string 22</FirstName>
    <FolioNumber>23</FolioNumber>
    <GroupId>sample string 76</GroupId>
    <GroupName>sample string 77</GroupName>
    <GuestId>sample string 24</GuestId>
    <GuestType>sample string 25</GuestType>
    <IsGuestTaxExempt>true</IsGuestTaxExempt>
    <JoinLoyalty>27</JoinLoyalty>
    <LastName>sample string 28</LastName>
    <LastUpdateDate>sample string 29</LastUpdateDate>
    <LoyaltyNumber>sample string 30</LoyaltyNumber>
    <MailToFlag>true</MailToFlag>
    <MarketSegment>sample string 33</MarketSegment>
    <MarketingCode>sample string 32</MarketingCode>
    <MarketingOptIn>sample string 34</MarketingOptIn>
    <MiddleInitial>sample string 35</MiddleInitial>
    <NumberOfActualNights>36.1</NumberOfActualNights>
    <NumberOfAdults>37</NumberOfAdults>
    <NumberOfChildren>38</NumberOfChildren>
    <NumberOfNights>39</NumberOfNights>
    <OtherRevenue>40</OtherRevenue>
    <PackageCode>sample string 41</PackageCode>
    <PaymentType>sample string 42</PaymentType>
    <Phone1>sample string 43</Phone1>
    <Phone2>sample string 44</Phone2>
    <PreferredContactMethod>sample string 45</PreferredContactMethod>
    <PromoCode>sample string 46</PromoCode>
    <PropertyCode>sample string 47</PropertyCode>
    <RateCode>sample string 48</RateCode>
    <RecordType>sample string 49</RecordType>
    <ReservationDate>sample string 50</ReservationDate>
    <ReservationRates />
    <ReservationServices />
    <ReservationUniqueIDs />
    <ResortFee>51</ResortFee>
    <RoomNumber>sample string 52</RoomNumber>
    <RoomRate>53</RoomRate>
    <RoomRevenue>54</RoomRevenue>
    <RoomTypeCode>sample string 55</RoomTypeCode>
    <SourceOfBusiness>sample string 56</SourceOfBusiness>
    <StateCode>sample string 57</StateCode>
    <Status>sample string 58</Status>
    <Taxes>59</Taxes>
    <TelephoneNumber>sample string 60</TelephoneNumber>
    <TimeofCheckOut>sample string 61</TimeofCheckOut>
    <Title>sample string 62</Title>
    <TotalRevenue>63</TotalRevenue>
    <TotalRevenueWithoutTaxes>64</TotalRevenueWithoutTaxes>
    <TravelAgent>sample string 65</TravelAgent>
    <TravelAgentEmailAddress>sample string 66</TravelAgentEmailAddress>
    <TravelAgentFaxNumber>sample string 67</TravelAgentFaxNumber>
    <TravelAgentIATA>sample string 68</TravelAgentIATA>
    <VIP>true</VIP>
    <VIPCode>sample string 70</VIPCode>
    <VehicleColor>sample string 75</VehicleColor>
    <VehicleLicensePlate>sample string 72</VehicleLicensePlate>
    <VehicleMake>sample string 73</VehicleMake>
    <VehicleModel>sample string 74</VehicleModel>
    <WholeSalerId>sample string 80</WholeSalerId>
    <WholeSalerName>sample string 81</WholeSalerName>
    <ZipCode>sample string 71</ZipCode>
  </ReservationGuestProfile>
</ArrayOfReservationGuestProfile>