Chilkat Online Tools

PowerBuilder / ORACLE Hospitality OPERA Cloud REST API Workflows / Create a new upsell rule

Back to Collection Items

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Json
oleobject loo_Resp

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

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat_9_5_0.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

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

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

// {
//   "upsellRules": [
//     {
//       "description": "New Rule Description",
//       "upsellByRoomType": true,
//       "fromRoomTypeOrFromRoomClass": "STDK",
//       "toRoomTypeOrToRoomClass": "SUPK",
//       "startDate": "2022-03-03",
//       "endDate": "2023-12-31",
//       "rateCodes": [
//         "BARBB",
//         "BAR"
//       ],
//       "marketCodes": [
//       ],
//       "upsellByOccupancyLevels": false,
//       "formula": "FlatAmountAddedToOriginalRate",
//       "upsellAmount": "5",
//       "currencyCode": "USD",
//       "roundingRule": "Down",
//       "occupancyLevelsType": [
//       ],
//       "useDefaultTrxCode": true,
//       "transactionCode": {
//         "description": "Room Upsell",
//         "transactionCode": "1500",
//         "hotelId": "{{HotelId}}"
//       },
//       "hotelId": "{{HotelId}}",
//       "upsellRuleCode": "UPSELLRULECODE1"
//     }
//   ]
// }

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat_9_5_0.JsonObject")

loo_Json.UpdateString("upsellRules[0].description","New Rule Description")
loo_Json.UpdateBool("upsellRules[0].upsellByRoomType",1)
loo_Json.UpdateString("upsellRules[0].fromRoomTypeOrFromRoomClass","STDK")
loo_Json.UpdateString("upsellRules[0].toRoomTypeOrToRoomClass","SUPK")
loo_Json.UpdateString("upsellRules[0].startDate","2022-03-03")
loo_Json.UpdateString("upsellRules[0].endDate","2023-12-31")
loo_Json.UpdateString("upsellRules[0].rateCodes[0]","BARBB")
loo_Json.UpdateString("upsellRules[0].rateCodes[1]","BAR")
loo_Json.UpdateNewArray("upsellRules[0].marketCodes")
loo_Json.UpdateBool("upsellRules[0].upsellByOccupancyLevels",0)
loo_Json.UpdateString("upsellRules[0].formula","FlatAmountAddedToOriginalRate")
loo_Json.UpdateString("upsellRules[0].upsellAmount","5")
loo_Json.UpdateString("upsellRules[0].currencyCode","USD")
loo_Json.UpdateString("upsellRules[0].roundingRule","Down")
loo_Json.UpdateNewArray("upsellRules[0].occupancyLevelsType")
loo_Json.UpdateBool("upsellRules[0].useDefaultTrxCode",1)
loo_Json.UpdateString("upsellRules[0].transactionCode.description","Room Upsell")
loo_Json.UpdateString("upsellRules[0].transactionCode.transactionCode","1500")
loo_Json.UpdateString("upsellRules[0].transactionCode.hotelId","{{HotelId}}")
loo_Json.UpdateString("upsellRules[0].hotelId","{{HotelId}}")
loo_Json.UpdateString("upsellRules[0].upsellRuleCode","UPSELLRULECODE1")

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

loo_Resp = loo_Http.PostJson3("https://domain.com/rsv/config/v0/hotels/{{HotelId}}/upsellRules","application/json",loo_Json)
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_Json
    return
end if

Write-Debug string(loo_Resp.StatusCode)
Write-Debug loo_Resp.BodyStr
destroy loo_Resp


destroy loo_Http
destroy loo_Json

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 '{
    "upsellRules": [
        {
            "description": "New Rule Description",
            "upsellByRoomType": true,
            "fromRoomTypeOrFromRoomClass": "STDK",
            "toRoomTypeOrToRoomClass": "SUPK",
            "startDate": "2022-03-03",
            "endDate": "2023-12-31",
            "rateCodes": [
                "BARBB",
                "BAR"
            ],
            "marketCodes": [],
            "upsellByOccupancyLevels": false,
            "formula": "FlatAmountAddedToOriginalRate",
            "upsellAmount": "5",
            "currencyCode": "USD",
            "roundingRule": "Down",
            "occupancyLevelsType": [],
            "useDefaultTrxCode": true,
            "transactionCode": {
                "description": "Room Upsell",
                "transactionCode": "1500",
                "hotelId": "{{HotelId}}"
            },
            "hotelId": "{{HotelId}}",
            "upsellRuleCode": "UPSELLRULECODE1"
        }
    ]
}'
https://domain.com/rsv/config/v0/hotels/{{HotelId}}/upsellRules

Postman Collection Item JSON

{
  "name": "Create a new upsell rule",
  "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",
        "type": "text",
        "value": "{{AppKey}}"
      }
    ],
    "body": {
      "mode": "raw",
      "raw": "{\r\n    \"upsellRules\": [\r\n        {\r\n            \"description\": \"New Rule Description\",\r\n            \"upsellByRoomType\": true,\r\n            \"fromRoomTypeOrFromRoomClass\": \"STDK\",\r\n            \"toRoomTypeOrToRoomClass\": \"SUPK\",\r\n            \"startDate\": \"2022-03-03\",\r\n            \"endDate\": \"2023-12-31\",\r\n            \"rateCodes\": [\r\n                \"BARBB\",\r\n                \"BAR\"\r\n            ],\r\n            \"marketCodes\": [],\r\n            \"upsellByOccupancyLevels\": false,\r\n            \"formula\": \"FlatAmountAddedToOriginalRate\",\r\n            \"upsellAmount\": \"5\",\r\n            \"currencyCode\": \"USD\",\r\n            \"roundingRule\": \"Down\",\r\n            \"occupancyLevelsType\": [],\r\n            \"useDefaultTrxCode\": true,\r\n            \"transactionCode\": {\r\n                \"description\": \"Room Upsell\",\r\n                \"transactionCode\": \"1500\",\r\n                \"hotelId\": \"{{HotelId}}\"\r\n            },\r\n            \"hotelId\": \"{{HotelId}}\",\r\n            \"upsellRuleCode\": \"UPSELLRULECODE1\"\r\n        }\r\n    ]\r\n}",
      "options": {
        "raw": {
          "language": "json"
        }
      }
    },
    "url": {
      "raw": "{{HostName}}/rsv/config/v0/hotels/{{HotelId}}/upsellRules",
      "host": [
        "{{HostName}}"
      ],
      "path": [
        "rsv",
        "config",
        "v0",
        "hotels",
        "{{HotelId}}",
        "upsellRules"
      ]
    }
  },
  "response": [
  ]
}