Chilkat Online Tools

VB6 / 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.

Dim http As New ChilkatHttp
Dim success As Long

' 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
'       }
'     ]
'   }
' }

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

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

Dim resp As ChilkatHttpResponse
Set resp = http.PostJson3("https://domain.com/rsv/v1/hotels/{{HotelId}}/reservations/","application/json",json)
If (http.LastMethodSuccess = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print resp.StatusCode
Debug.Print resp.BodyStr

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": [
  ]
}