oracle / hospitality-api-docs Goto Github PK

Hello 🙂

I’m using the Reservation Asynchronous APIs for BI purposes. It works fine for the most part. However, the workflow fails sometimes for a couple of properties, for a certain range of dates. That is, I was able to download the reservations for those properties for all periods except for a gap where the calls fail.

All that is different between the successful and failed calls are the "endLastModifiedDate" and "startLastModifiedDate" parameters. The entire rest of the workflow is scripted the same way. The dates are valid and located between date ranges that were passed successfully before.

The process starts behaving weirdly for the failed dates in the response of “Check status of Reservation Daily Summary process”. It returns, every time, after dozens of retries:

• Status code 201
• “INVALID REQUEST” in “status” header
• A URL under “Location” header

When I anyway try to use the summaryId in the URL under the “Location” header to make a call to the “Get results of Reservations Daily Summary.” endpoint, I get the response below:

{
  "type": "Bad Request",
  "title": "ORA-20001: P$M$S-1400P$M$S: ORA-01400: cannot insert NULL into (\"OPERA\".\"TMP_TAXCALC_E\".\"TROOMCATEGORY\") at OPERA.PKG_RATE_PRICE[r592916](5543) : -20001",
  "status": "NotProcessed",
  "detail": "ORA-20001: P$M$S-1400P$M$S: ORA-01400: cannot insert NULL into (\"OPERA\".\"TMP_TAXCALC_E\".\"TROOMCATEGORY\") at OPERA.PKG_RATE_PRICE[r592916](5543) : -20001",
  "o:errorCode": "OPERAWS-ODE09998",
  "language": "en"
}

What could be behind this error? Thank you in advance.

Can you add the Distribution API specs too please?

Hi,
I am not sure if this belongs into repo issues but email address [email protected] bounces back as non existent.

Pavel

Hi,

I am trying to send item to the Reservation.

example:

• bottle of water, $ 1.00.

In pontman I found the colection

• "Property Interfaces - Post Simple Charges"

• • Post a billing charge including amount

That is a correct endpoint, to send data from POS to Oracle | Hospitality ?

The Postman Collection file, oracle-hospitality-property-workflows.postman_collection.json, is not valid JSON.

It cannot be parsed by JavaScript's JSON.parse() method.

Hi , I am trying to use your APIs and test them ,
I have added the environment variables , but all of them are empty string , how can I use and test the APIs?