Chilkat Online Tools

lianja / ORACLE Hospitality OPERA Cloud REST API Workflows / Create a new reservation

Back to Collection Items

// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

loHttp = createobject("CkHttp")

// Use this online tool to generate code from sample JSON: Generate Code to Create JSON

// The following JSON is sent in the request body.

// {
//   "reservations": {
//     "reservation": [
//       {
//         "sourceOfSale": {
//           "sourceType": "PMS",
//           "sourceCode": "{{HotelId}}"
//         },
//         "roomStay": {
//           "roomRates": [
//             {
//               "total": {
//                 "amountBeforeTax": "200"
//               },
//               "rates": {
//                 "rate": [
//                   {
//                     "base": {
//                       "amountBeforeTax": "200",
//                       "currencyCode": "USD"
//                     },
//                     "shareDistributionInstruction": "Full",
//                     "total": {
//                       "amountBeforeTax": "200"
//                     },
//                     "start": "{{currentdate}}",
//                     "end": "{{currentdateplus1}}"
//                   }
//                 ]
//               },
//               "guestCounts": {
//                 "adults": "1",
//                 "children": "0"
//               },
//               "roomType": "{{RoomTypeCode}}",
//               "ratePlanCode": "{{RatePlanCode}}",
//               "start": "{{currentdate}}",
//               "end": "{{currentdateplus1}}",
//               "suppressRate": true,
//               "marketCode": "LEISURE",
//               "marketCodeDescription": "Leisure",
//               "sourceCode": "PHONE",
//               "sourceCodeDescription": "Over the Phone",
//               "numberOfUnits": "1",
//               "pseudoRoom": false,
//               "roomTypeCharged": "{{RoomTypeCode}}",
//               "houseUseOnly": false,
//               "complimentary": false,
//               "fixedRate": true,
//               "discountAllowed": false,
//               "bogoDiscount": false
//             }
//           ],
//           "guestCounts": {
//             "adults": "1",
//             "children": "0"
//           },
//           "arrivalDate": "{{currentdate}}",
//           "departureDate": "{{currentdateplus1}}",
//           "guarantee": {
//             "guaranteeCode": "6PM",
//             "shortDescription": "6PM Hold"
//           },
//           "roomNumberLocked": false,
//           "printRate": false
//         },
//         "reservationGuests": [
//           {
//             "profileInfo": {
//               "profile": {
//                 "customer": {
//                   "personName": [
//                     {
//                       "givenName": "Jane",
//                       "surname": "Smith",
//                       "nameType": "Primary"
//                     },
//                     {
//                       "nameType": "External"
//                     }
//                   ],
//                   "language": "E"
//                 },
//                 "profileType": "Guest"
//               }
//             },
//             "primary": true
//           }
//         ],
//         "reservationPaymentMethods": [
//           {
//             "paymentMethod": "CA",
//             "folioView": "1"
//           }
//         ],
//         "comments": [
//           {
//             "comment": {
//               "text": {
//                 "value": "Please ensure I have tea in my room"
//               },
//               "commentTitle": "General Notes",
//               "notificationLocation": "RESERVATION",
//               "type": "GEN",
//               "internal": false
//             }
//           }
//         ],
//         "hotelId": "{{HotelId}}",
//         "roomStayReservation": true,
//         "reservationStatus": "Reserved",
//         "computedReservationStatus": "DueIn",
//         "walkIn": false,
//         "printRate": false,
//         "preRegistered": false,
//         "upgradeEligible": false,
//         "allowAutoCheckin": false,
//         "hasOpenFolio": false,
//         "allowMobileCheckout": false,
//         "allowMobileViewFolio": false,
//         "allowPreRegistration": false,
//         "optedForCommunication": false
//       }
//     ]
//   }
// }

loJson = createobject("CkJsonObject")
loJson.UpdateString("reservations.reservation[0].sourceOfSale.sourceType","PMS")
loJson.UpdateString("reservations.reservation[0].sourceOfSale.sourceCode","{{HotelId}}")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].total.amountBeforeTax","200")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].rates.rate[0].base.amountBeforeTax","200")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].rates.rate[0].base.currencyCode","USD")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].rates.rate[0].shareDistributionInstruction","Full")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].rates.rate[0].total.amountBeforeTax","200")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].rates.rate[0].start","{{currentdate}}")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].rates.rate[0].end","{{currentdateplus1}}")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].guestCounts.adults","1")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].guestCounts.children","0")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].roomType","{{RoomTypeCode}}")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].ratePlanCode","{{RatePlanCode}}")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].start","{{currentdate}}")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].end","{{currentdateplus1}}")
loJson.UpdateBool("reservations.reservation[0].roomStay.roomRates[0].suppressRate",.T.)
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].marketCode","LEISURE")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].marketCodeDescription","Leisure")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].sourceCode","PHONE")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].sourceCodeDescription","Over the Phone")
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].numberOfUnits","1")
loJson.UpdateBool("reservations.reservation[0].roomStay.roomRates[0].pseudoRoom",.F.)
loJson.UpdateString("reservations.reservation[0].roomStay.roomRates[0].roomTypeCharged","{{RoomTypeCode}}")
loJson.UpdateBool("reservations.reservation[0].roomStay.roomRates[0].houseUseOnly",.F.)
loJson.UpdateBool("reservations.reservation[0].roomStay.roomRates[0].complimentary",.F.)
loJson.UpdateBool("reservations.reservation[0].roomStay.roomRates[0].fixedRate",.T.)
loJson.UpdateBool("reservations.reservation[0].roomStay.roomRates[0].discountAllowed",.F.)
loJson.UpdateBool("reservations.reservation[0].roomStay.roomRates[0].bogoDiscount",.F.)
loJson.UpdateString("reservations.reservation[0].roomStay.guestCounts.adults","1")
loJson.UpdateString("reservations.reservation[0].roomStay.guestCounts.children","0")
loJson.UpdateString("reservations.reservation[0].roomStay.arrivalDate","{{currentdate}}")
loJson.UpdateString("reservations.reservation[0].roomStay.departureDate","{{currentdateplus1}}")
loJson.UpdateString("reservations.reservation[0].roomStay.guarantee.guaranteeCode","6PM")
loJson.UpdateString("reservations.reservation[0].roomStay.guarantee.shortDescription","6PM Hold")
loJson.UpdateBool("reservations.reservation[0].roomStay.roomNumberLocked",.F.)
loJson.UpdateBool("reservations.reservation[0].roomStay.printRate",.F.)
loJson.UpdateString("reservations.reservation[0].reservationGuests[0].profileInfo.profile.customer.personName[0].givenName","Jane")
loJson.UpdateString("reservations.reservation[0].reservationGuests[0].profileInfo.profile.customer.personName[0].surname","Smith")
loJson.UpdateString("reservations.reservation[0].reservationGuests[0].profileInfo.profile.customer.personName[0].nameType","Primary")
loJson.UpdateString("reservations.reservation[0].reservationGuests[0].profileInfo.profile.customer.personName[1].nameType","External")
loJson.UpdateString("reservations.reservation[0].reservationGuests[0].profileInfo.profile.customer.language","E")
loJson.UpdateString("reservations.reservation[0].reservationGuests[0].profileInfo.profile.profileType","Guest")
loJson.UpdateBool("reservations.reservation[0].reservationGuests[0].primary",.T.)
loJson.UpdateString("reservations.reservation[0].reservationPaymentMethods[0].paymentMethod","CA")
loJson.UpdateString("reservations.reservation[0].reservationPaymentMethods[0].folioView","1")
loJson.UpdateString("reservations.reservation[0].comments[0].comment.text.value","Please ensure I have tea in my room")
loJson.UpdateString("reservations.reservation[0].comments[0].comment.commentTitle","General Notes")
loJson.UpdateString("reservations.reservation[0].comments[0].comment.notificationLocation","RESERVATION")
loJson.UpdateString("reservations.reservation[0].comments[0].comment.type","GEN")
loJson.UpdateBool("reservations.reservation[0].comments[0].comment.internal",.F.)
loJson.UpdateString("reservations.reservation[0].hotelId","{{HotelId}}")
loJson.UpdateBool("reservations.reservation[0].roomStayReservation",.T.)
loJson.UpdateString("reservations.reservation[0].reservationStatus","Reserved")
loJson.UpdateString("reservations.reservation[0].computedReservationStatus","DueIn")
loJson.UpdateBool("reservations.reservation[0].walkIn",.F.)
loJson.UpdateBool("reservations.reservation[0].printRate",.F.)
loJson.UpdateBool("reservations.reservation[0].preRegistered",.F.)
loJson.UpdateBool("reservations.reservation[0].upgradeEligible",.F.)
loJson.UpdateBool("reservations.reservation[0].allowAutoCheckin",.F.)
loJson.UpdateBool("reservations.reservation[0].hasOpenFolio",.F.)
loJson.UpdateBool("reservations.reservation[0].allowMobileCheckout",.F.)
loJson.UpdateBool("reservations.reservation[0].allowMobileViewFolio",.F.)
loJson.UpdateBool("reservations.reservation[0].allowPreRegistration",.F.)
loJson.UpdateBool("reservations.reservation[0].optedForCommunication",.F.)

loHttp.SetRequestHeader("Content-Type","application/json")
loHttp.SetRequestHeader("x-hotelid","{{HotelId}}")
// Adds the "Authorization: Bearer <access_token>" header.
loHttp.AuthToken = "<access_token>"
loHttp.SetRequestHeader("x-app-key","{{AppKey}}")

loResp = loHttp.PostJson3("https://domain.com/rsv/v1/hotels/{{HotelId}}/reservations/","application/json",loJson)
if (loHttp.LastMethodSuccess = .F.) then
    ? loHttp.LastErrorText
    release loHttp
    release loJson
    return
endif

? str(loResp.StatusCode)
? loResp.BodyStr
release loResp


release loHttp
release loJson

Curl Command

curl -X POST
	-H "Authorization: Bearer <access_token>"
	-H "Content-Type: application/json"
	-H "x-hotelid: {{HotelId}}"
	-H "x-app-key: {{AppKey}}"
	-d '{
    "reservations": {
        "reservation": [
            {
                "sourceOfSale": {
                    "sourceType": "PMS",
                    "sourceCode": "{{HotelId}}"
                },
                "roomStay": {
                    "roomRates": [
                        {
                            "total": {
                                "amountBeforeTax": "200"
                            },
                            "rates": {
                                "rate": [
                                    {
                                        "base": {
                                            "amountBeforeTax": "200",
                                            "currencyCode": "USD"
                                        },
                                        "shareDistributionInstruction": "Full",
                                        "total": {
                                            "amountBeforeTax": "200"
                                        },
                                        "start": "{{currentdate}}",
                                        "end": "{{currentdateplus1}}"
                                    }
                                ]
                            },
                            "guestCounts": {
                                "adults": "1",
                                "children": "0"
                            },
                            "roomType": "{{RoomTypeCode}}",
                            "ratePlanCode": "{{RatePlanCode}}",
                            "start": "{{currentdate}}",
                            "end": "{{currentdateplus1}}",
                            "suppressRate": true,
                            "marketCode": "LEISURE",
                            "marketCodeDescription": "Leisure",
                            "sourceCode": "PHONE",
                            "sourceCodeDescription": "Over the Phone",
                            "numberOfUnits": "1",
                            "pseudoRoom": false,
                            "roomTypeCharged": "{{RoomTypeCode}}",
                            "houseUseOnly": false,
                            "complimentary": false,
                            "fixedRate": true,
                            "discountAllowed": false,
                            "bogoDiscount": false
                        }
                    ],
                    "guestCounts": {
                        "adults": "1",
                        "children": "0"
                    },
                    "arrivalDate": "{{currentdate}}",
                    "departureDate": "{{currentdateplus1}}",
                    "guarantee": {
                        "guaranteeCode": "6PM",
                        "shortDescription": "6PM Hold"
                    },
                    "roomNumberLocked": false,
                    "printRate": false
                },
                "reservationGuests": [
                    {
                        "profileInfo": {
                            "profile": {
                                "customer": {
                                    "personName": [
                                        {
                                            "givenName": "Jane",
                                            "surname": "Smith",
                                            "nameType": "Primary"
                                        },
                                        {
                                            "nameType": "External"
                                        }
                                    ],
                                    "language": "E"
                                },
                                "profileType": "Guest"
                            }
                        },
                        "primary": true
                    }
                ],
               "reservationPaymentMethods": [
                    {
                        "paymentMethod": "CA",
                        "folioView": "1"
                    }
                ],
                "comments": [
                    {
                        "comment": {
                            "text": {
                                "value": "Please ensure I have tea in my room"
                            },
                            "commentTitle": "General Notes",
                            "notificationLocation": "RESERVATION",
                            "type": "GEN",
                            "internal": false
                        }
                    }
                ],
                "hotelId": "{{HotelId}}",
                "roomStayReservation": true,
                "reservationStatus": "Reserved",
                "computedReservationStatus": "DueIn",
                "walkIn": false,
                "printRate": false,
                "preRegistered": false,
                "upgradeEligible": false,
                "allowAutoCheckin": false,
                "hasOpenFolio": false,
                "allowMobileCheckout": false,
                "allowMobileViewFolio": false,
                "allowPreRegistration": false,
                "optedForCommunication": false
            }
        ]
    }
}'
https://domain.com/rsv/v1/hotels/{{HotelId}}/reservations/

Postman Collection Item JSON

{
  "name": "Create a new reservation",
  "event": [
    {
      "listen": "test",
      "script": {
        "exec": [
          "var data = pm.response.headers.get(\"Location\").split(\"/\").pop();\r",
          "postman.setEnvironmentVariable(\"ReservationId\", data);"
        ],
        "type": "text/javascript"
      }
    }
  ],
  "request": {
    "auth": {
      "type": "bearer",
      "bearer": [
        {
          "key": "token",
          "value": "{{Token}}",
          "type": "string"
        }
      ]
    },
    "method": "POST",
    "header": [
      {
        "key": "Content-Type",
        "name": "Content-Type",
        "type": "text",
        "value": "application/json"
      },
      {
        "key": "x-hotelid",
        "type": "text",
        "value": "{{HotelId}}"
      },
      {
        "key": "x-app-key",
        "value": "{{AppKey}}",
        "type": "text"
      }
    ],
    "body": {
      "mode": "raw",
      "raw": "{\r\n    \"reservations\": {\r\n        \"reservation\": [\r\n            {\r\n                \"sourceOfSale\": {\r\n                    \"sourceType\": \"PMS\",\r\n                    \"sourceCode\": \"{{HotelId}}\"\r\n                },\r\n                \"roomStay\": {\r\n                    \"roomRates\": [\r\n                        {\r\n                            \"total\": {\r\n                                \"amountBeforeTax\": \"200\"\r\n                            },\r\n                            \"rates\": {\r\n                                \"rate\": [\r\n                                    {\r\n                                        \"base\": {\r\n                                            \"amountBeforeTax\": \"200\",\r\n                                            \"currencyCode\": \"USD\"\r\n                                        },\r\n                                        \"shareDistributionInstruction\": \"Full\",\r\n                                        \"total\": {\r\n                                            \"amountBeforeTax\": \"200\"\r\n                                        },\r\n                                        \"start\": \"{{currentdate}}\",\r\n                                        \"end\": \"{{currentdateplus1}}\"\r\n                                    }\r\n                                ]\r\n                            },\r\n                            \"guestCounts\": {\r\n                                \"adults\": \"1\",\r\n                                \"children\": \"0\"\r\n                            },\r\n                            \"roomType\": \"{{RoomTypeCode}}\",\r\n                            \"ratePlanCode\": \"{{RatePlanCode}}\",\r\n                            \"start\": \"{{currentdate}}\",\r\n                            \"end\": \"{{currentdateplus1}}\",\r\n                            \"suppressRate\": true,\r\n                            \"marketCode\": \"LEISURE\",\r\n                            \"marketCodeDescription\": \"Leisure\",\r\n                            \"sourceCode\": \"PHONE\",\r\n                            \"sourceCodeDescription\": \"Over the Phone\",\r\n                            \"numberOfUnits\": \"1\",\r\n                            \"pseudoRoom\": false,\r\n                            \"roomTypeCharged\": \"{{RoomTypeCode}}\",\r\n                            \"houseUseOnly\": false,\r\n                            \"complimentary\": false,\r\n                            \"fixedRate\": true,\r\n                            \"discountAllowed\": false,\r\n                            \"bogoDiscount\": false\r\n                        }\r\n                    ],\r\n                    \"guestCounts\": {\r\n                        \"adults\": \"1\",\r\n                        \"children\": \"0\"\r\n                    },\r\n                    \"arrivalDate\": \"{{currentdate}}\",\r\n                    \"departureDate\": \"{{currentdateplus1}}\",\r\n                    \"guarantee\": {\r\n                        \"guaranteeCode\": \"6PM\",\r\n                        \"shortDescription\": \"6PM Hold\"\r\n                    },\r\n                    \"roomNumberLocked\": false,\r\n                    \"printRate\": false\r\n                },\r\n                \"reservationGuests\": [\r\n                    {\r\n                        \"profileInfo\": {\r\n                            \"profile\": {\r\n                                \"customer\": {\r\n                                    \"personName\": [\r\n                                        {\r\n                                            \"givenName\": \"Jane\",\r\n                                            \"surname\": \"Smith\",\r\n                                            \"nameType\": \"Primary\"\r\n                                        },\r\n                                        {\r\n                                            \"nameType\": \"External\"\r\n                                        }\r\n                                    ],\r\n                                    \"language\": \"E\"\r\n                                },\r\n                                \"profileType\": \"Guest\"\r\n                            }\r\n                        },\r\n                        \"primary\": true\r\n                    }\r\n                ],\r\n               \"reservationPaymentMethods\": [\r\n                    {\r\n                        \"paymentMethod\": \"CA\",\r\n                        \"folioView\": \"1\"\r\n                    }\r\n                ],\r\n                \"comments\": [\r\n                    {\r\n                        \"comment\": {\r\n                            \"text\": {\r\n                                \"value\": \"Please ensure I have tea in my room\"\r\n                            },\r\n                            \"commentTitle\": \"General Notes\",\r\n                            \"notificationLocation\": \"RESERVATION\",\r\n                            \"type\": \"GEN\",\r\n                            \"internal\": false\r\n                        }\r\n                    }\r\n                ],\r\n                \"hotelId\": \"{{HotelId}}\",\r\n                \"roomStayReservation\": true,\r\n                \"reservationStatus\": \"Reserved\",\r\n                \"computedReservationStatus\": \"DueIn\",\r\n                \"walkIn\": false,\r\n                \"printRate\": false,\r\n                \"preRegistered\": false,\r\n                \"upgradeEligible\": false,\r\n                \"allowAutoCheckin\": false,\r\n                \"hasOpenFolio\": false,\r\n                \"allowMobileCheckout\": false,\r\n                \"allowMobileViewFolio\": false,\r\n                \"allowPreRegistration\": false,\r\n                \"optedForCommunication\": false\r\n            }\r\n        ]\r\n    }\r\n}",
      "options": {
        "raw": {
          "language": "json"
        }
      }
    },
    "url": {
      "raw": "{{HostName}}/rsv/v1/hotels/{{HotelId}}/reservations/",
      "host": [
        "{{HostName}}"
      ],
      "path": [
        "rsv",
        "v1",
        "hotels",
        "{{HotelId}}",
        "reservations",
        ""
      ]
    }
  },
  "response": [
  ]
}