Chilkat Online Tools

SQL Server Examples for ORACLE Hospitality OPERA Cloud REST API Workflows

Back

Postman Collection Items

• OAuth Token/Get OAuth Token --initialiize currentdate
• Common Workflows/Add an Accompanying Guest to a Reservation/Search for an existing reservation
• Common Workflows/Add an Accompanying Guest to a Reservation/Search for Guest Profile
• Common Workflows/Add an Accompanying Guest to a Reservation/Create New Profile If one doesn't exist
• Common Workflows/Add an Accompanying Guest to a Reservation/Update Reservation - add accompanying profile
• Common Workflows/Add Tickets to a Reservation/Search For Available Tickets
• Common Workflows/Add Tickets to a Reservation/Add Tickets To Reservation
• Common Workflows/Add Tickets to a Reservation/Get existing tickets on a reservation
• Common Workflows/Add Tickets to a Reservation/Update Existing Ticket on a reservation
• Common Workflows/Check-In/Search for an existing reservation
• Common Workflows/Check-In/Retrieve reservation details by Id
• Common Workflows/Check-In/Split a multi room reservation
• Common Workflows/Check-In/Get reservations linked to the reservation
• Common Workflows/Check-In/Update the reservations payment method
• Common Workflows/Check-In/Update the guest profile with new contact details
• Common Workflows/Check-In/Pre-register a Reservation and update the arrival time
• Common Workflows/Check-In/Pre-Register with payment method and arrival time
• Common Workflows/Check-In/Search for available rooms for assignment
• Common Workflows/Check-In/Add a room number to a reservation
• Common Workflows/Check-In/Check In a reservation
• Common Workflows/Check Out/Search for a Reservation
• Common Workflows/Check Out/Retrieve reservation details by Id
• Common Workflows/Check Out/Update Reservation With Payment Method
• Common Workflows/Check Out/Get the reservation folio
• Common Workflows/Check Out/Get transaction codes to see what charges can be posted
• Common Workflows/Check Out/Add a charge to the folio
• Common Workflows/Check Out/Add a Payment to the Folio
• Common Workflows/Check Out/Post a Folio, required before checking out a guest
• Common Workflows/Check Out/Check out a reservation
• Common Workflows/Check Out/Reverse a check out
• Common Workflows/Contactless Guest Journey/01. Get oAuth Token
• Common Workflows/Contactless Guest Journey/02. Booking - getProfiles
• Common Workflows/Contactless Guest Journey/03. Booking - getHotelAvailability
• Common Workflows/Contactless Guest Journey/04. Booking - postReservation (with existing profile)
• Common Workflows/Contactless Guest Journey/05. Pre-Arrival - putReservation (add pref)
• Common Workflows/Contactless Guest Journey/06. Pre-Arrival - getHotelRooms
• Common Workflows/Contactless Guest Journey/07. Pre-Arrival - postRoomAssignment
• Common Workflows/Contactless Guest Journey/08. Pre-Arrival - postPreCheckInReservation (update arrival time)
• Common Workflows/Contactless Guest Journey/09. Pre-Arrival - getBusinessEvents (update room status)
• Common Workflows/Contactless Guest Journey/10. Check-In - postCheckIn
• Common Workflows/Contactless Guest Journey/11. Check-In - postRoomKey
• Common Workflows/Contactless Guest Journey/12. Stay - postServiceRequests (request towels)
• Common Workflows/Contactless Guest Journey/13. Stay - postBillingCharges (car service)
• Common Workflows/Contactless Guest Journey/14. Check-Out - putReservation (add departure time)
• Common Workflows/Contactless Guest Journey/15. Check-Out - getFolio
• Common Workflows/Contactless Guest Journey/16. Check-Out - postCheckout
• Common Workflows/Contactless Guest Journey/17. Check-Out - postBillingPayment
• Common Workflows/Contactless Guest Journey/18. Check-Out - postFolios (close folio)
• Common Workflows/Contactless Guest Journey/19. Check-Out - postCheckout
• Common Workflows/Create a Block/Search for available Block Status to use in postBlock
• Common Workflows/Create a Block/Search for available Block Reservation Types
• Common Workflows/Create a Block/Search for available rate codes to use in postBlock
• Common Workflows/Create a Block/Search for Block Origin Codes
• Common Workflows/Create a Block/Search for Block Booking types
• Common Workflows/Create a Block/Get block default code to use in postBlock
• Common Workflows/Create a Block/Create a new Block
• Common Workflows/Create a Block/Add notes to a block
• Common Workflows/Create a Block/Get Block Next Status Codes
• Common Workflows/Create a Block/Update the Block's Status
• Common Workflows/Create a Block/Create a Posting Master Reservation on the block
• Common Workflows/Create an Event/Search for all Event Types
• Common Workflows/Create an Event/Get available event statuses
• Common Workflows/Create an Event/Search Function Space Availability
• Common Workflows/Create an Event/Search for rental codes
• Common Workflows/Create an Event/Search for room setup styles available
• Common Workflows/Create an Event/Create a new event with function space & rental amount
• Common Workflows/Create an Event/Search for available event resources
• Common Workflows/Create an Event/Add event resources to the event
• Common Workflows/Create an Event/Add notes to the event
• Common Workflows/Create an Event/Get event resources attached to an event
• Common Workflows/Create an Event/Find next available block catering statuses
• Common Workflows/Create an Event/Update an event - change the event time
• Common Workflows/Create a Standard Rate/Get Rate Categories for a property
• Common Workflows/Create a Standard Rate/Get Room Types for a property
• Common Workflows/Create a Standard Rate/Get Market Codes for a property
• Common Workflows/Create a Standard Rate/Get Source codes for a property
• Common Workflows/Create a Standard Rate/Get Transaction Codes for a property
• Common Workflows/Create a Standard Rate/Get Rate Package Transaction Codes
• Common Workflows/Create a Standard Rate/Create a new Rate Plans
• Common Workflows/Create a Standard Rate/Add packages to a Rate Plan
• Common Workflows/Create a Standard Rate/Update an existing Rate Plan
• Common Workflows/Create a Standard Rate/Get Room types available to add rate schedules
• Common Workflows/Create a Standard Rate/Create Rate Plan Schedules
• Common Workflows/Create a Standard Rate/Create Rate Plan Schedules with a package
• Common Workflows/Create a Standard Rate/Update a Rate Plan Schedule
• Common Workflows/Create a Standard Rate/Get existing Rate Plan Schedules
• Common Workflows/Create a Room Maintenance Request/Find all existing Room Maintenance Requests
• Common Workflows/Create a Room Maintenance Request/Create a new Room Maintenance request
• Common Workflows/Create a Room Maintenance Request/Update an existing Room Maintenance Request
• Common Workflows/Create a Room Maintenance Request/Resolve a Room Maintenance Request
• Common Workflows/Create a Room Maintenance Request/unresolve a Room Maintenance Request
• Common Workflows/Create a Room Maintenance Request/Delete a Room Maintenance Request
• Common Workflows/Create a Service Request for a Guest/Add a Service request to a reservation
• Common Workflows/Create a Service Request for a Guest/Update a Service Request
• Common Workflows/Create a Service Request for a Guest/Delete a Service Request
• Common Workflows/Create a Room Class Upgrade Rule/get Upsell From Room Class LOV
• Common Workflows/Create a Room Class Upgrade Rule/get Upsell To Room Class LOV
• Common Workflows/Create a Room Class Upgrade Rule/get Upsell Rate Codes LOV
• Common Workflows/Create a Room Class Upgrade Rule/get Upsell Rate Categories LOV
• Common Workflows/Create a Room Class Upgrade Rule/get Upsell Membership Types LOV
• Common Workflows/Create a Room Class Upgrade Rule/get Upsell Membership Levels LOV
• Common Workflows/Create a Room Class Upgrade Rule/get Reservation Types LOV
• Common Workflows/Create a Room Class Upgrade Rule/get Upsell Market Codes LOV
• Common Workflows/Create a Room Class Upgrade Rule/get Channel Codes LOV
• Common Workflows/Create a Room Class Upgrade Rule/get Upsell Trx Codes LOV
• Common Workflows/Create a Room Class Upgrade Rule/Create a new upsell rule
• Common Workflows/Create a Room Class Upgrade Rule/Update an upsell rule
• Common Workflows/Create a Room Class Upgrade Rule/Test an upsell Rule
• Common Workflows/Create a Room Class Upgrade Rule/Get existing upsell rules
• Common Workflows/Create a Room Type Upgrade Rule/get Upsell From Room Type LOV
• Common Workflows/Create a Room Type Upgrade Rule/get Upsell To Room Type LOV
• Common Workflows/Create a Room Type Upgrade Rule/get Upsell Rate Codes LOV
• Common Workflows/Create a Room Type Upgrade Rule/get Upsell Rate Categories LOV
• Common Workflows/Create a Room Type Upgrade Rule/get Upsell Membership Types LOV
• Common Workflows/Create a Room Type Upgrade Rule/get Upsell Membership Levels LOV
• Common Workflows/Create a Room Type Upgrade Rule/get Reservation Types LOV
• Common Workflows/Create a Room Type Upgrade Rule/get Upsell Market Codes LOV
• Common Workflows/Create a Room Type Upgrade Rule/get Channel Codes LOV
• Common Workflows/Create a Room Type Upgrade Rule/get Upsell Trx Codes LOV
• Common Workflows/Create a Room Type Upgrade Rule/Create a new upsell rule
• Common Workflows/Create a Room Type Upgrade Rule/Update an upsell rule
• Common Workflows/Create a Room Type Upgrade Rule/Test an upsell rule
• Common Workflows/Create a Room Type Upgrade Rule/Get existing upsell rules
• Common Workflows/Guest Messages for an In House Guest/Create a new Guest Messages
• Common Workflows/Guest Messages for an In House Guest/Update an existing Guest Messages
• Common Workflows/Guest Messages for an In House Guest/Get Guest Messages on a reservation
• Common Workflows/Issue Guest a Digital Key/Check-In a Guest
• Common Workflows/Issue Guest a Digital Key/Create Room Key
• Common Workflows/Perform a Room Move/Search available rooms for assignment
• Common Workflows/Perform a Room Move/Get available room move reason codes
• Common Workflows/Perform a Room Move/Move an in-house guest to a new room
• Common Workflows/Perform a Room Move/Get Room Move History
• Common Workflows/Post a charge to a Folio/Get transaction codes to see what charges can be posted
• Common Workflows/Post a charge to a Folio/Add a charge to the folio
• Common Workflows/Post a charge to a Folio/Get Folio to view the charges
• Common Workflows/Queue Rooms/Add Reservation To Queue
• Common Workflows/Queue Rooms/Get Reservations in Queue
• Common Workflows/Queue Rooms/Remove Reservation from Queue
• Common Workflows/Queue Rooms/get Reservation Queue Statistics
• Common Workflows/Schedule a Wake Up Call/Get all wake Up Calls by date range
• Common Workflows/Schedule a Wake Up Call/Schedule a Wake Up Call for a guest
• Common Workflows/Schedule a Wake Up Call/Update a Wake Up Call on a reservation
• Common Workflows/Schedule a Wake Up Call/Delete a Wake Up Call
• Common Workflows/Search Availability and Book a Reservation/Search hotel availability
• Common Workflows/Search Availability and Book a Reservation/Get rate plan Details including the long description
• Common Workflows/Search Availability and Book a Reservation/Get market codes for a property
• Common Workflows/Search Availability and Book a Reservation/Get source codes for a property
• Common Workflows/Search Availability and Book a Reservation/Get available guarantee policies
• Common Workflows/Search Availability and Book a Reservation/Get payment methods, such as cash, Visa etc
• Common Workflows/Search Availability and Book a Reservation/Get available packages
• Common Workflows/Search Availability and Book a Reservation/Get reservation packages
• Common Workflows/Search Availability and Book a Reservation/Search for a guest profile
• Common Workflows/Search Availability and Book a Reservation/Create a new reservation
• Common Workflows/Search Availability and Book a Reservation/Create a new reservation using existing profile
• Common Workflows/Search Availability and Book a Reservation/Create a new reservation with a package
• Common Workflows/Search Availability and Book a Reservation/Cancel a reservation
• Common Workflows/Upgrade a Reservation/Retrieve reservation and see if an upsell offer is available
• Common Workflows/Upgrade a Reservation/Find available upsell offers to present to a guest
• Common Workflows/Upgrade a Reservation/Add an upsell to a reservation
• Common Workflows/Upgrade a Reservation/Remove an upsell from a reservation
• Common Workflows/Upgrade a Reservation/Set if an upsell exists on a reservation