This is a typical Opera Integration use case - extract guest details from reservations/profiles and put them into a CRM for sales and marketing purposes.
Simple scenario here - create contacts in SFDC for new Opera reservations. Here I query the Profile and Reservations objects in Opera via OHIP and then leverage the OIC SFDC adapter to create the relevant Contacts in SFDC. This will be a scheduled job that runs on a regular basis, ensuring my guest profiles etc are in sync with the relevant contact data in SFDC.
Starting point, as usual, is Postman and the starter collection delivered by OHIP.
Above - my profile, including address and email details. Note the profile id - 17461. This will be used when creating the Reservation.
Note the Reservation id - 18652. I use this to add a service request to the reservation -
Now to retrieve reservation and profile details for the SFDC Contact creation - think of this as a scheduled job that picks up new reservations since the last run. OHIP provides the following api, which will return a list of reservations based on a start date.
As you can see, the response payload includes the profile id. This value is then used to get the Profile information -
So let's implement in OIC - I will not go into detail here, in respect of the OHIP apis - that has been covered exhaustively already in the previous Oracle Hospitality posts.
Implementing the SFDC Contact Sync in OIC
I create an OIC Scheduled Orchestration, adding a schedule parameter, dateLastRun. This parameter is used as input to the OHIP api call to retrieve the latest reservations.
Step 1 -Implement the retrieval of the reservation list.
As you can see, I have 2 reservations, including my own with id 18652.