Chilkat Online Tools

Foxpro / ORACLE Hospitality OPERA Cloud REST API Workflows / Update an upsell rule

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loResp

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')

* 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 upsell rule",
*       "upsellByRoomType": false,
*       "fromRoomTypeOrFromRoomClass": "STDQ",
*       "toRoomTypeOrToRoomClass": "*",
*       "startDate": "2021-07-03",
*       "upsellByOccupancyLevels": false,
*       "formula": "FlatAmountAddedToOriginalRate",
*       "upsellAmount": "11",
*       "currencyCode": "USD",
*       "roundingRule": "None",
*       "occupancyLevelsType": [
*       ],
*       "useDefaultTrxCode": true,
*       "transactionCode": {
*         "description": "Room Upsell",
*         "transactionCode": "1500",
*         "hotelId": "{{HotelId}}"
*       },
*       "hotelId": "{{HotelId}}",
*       "upsellRuleCode": "NEWUPSELLRULE1"
*     }
*   ]
* }

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("upsellRules[0].description","New upsell rule")
loJson.UpdateBool("upsellRules[0].upsellByRoomType",0)
loJson.UpdateString("upsellRules[0].fromRoomTypeOrFromRoomClass","STDQ")
loJson.UpdateString("upsellRules[0].toRoomTypeOrToRoomClass","*")
loJson.UpdateString("upsellRules[0].startDate","2021-07-03")
loJson.UpdateBool("upsellRules[0].upsellByOccupancyLevels",0)
loJson.UpdateString("upsellRules[0].formula","FlatAmountAddedToOriginalRate")
loJson.UpdateString("upsellRules[0].upsellAmount","11")
loJson.UpdateString("upsellRules[0].currencyCode","USD")
loJson.UpdateString("upsellRules[0].roundingRule","None")
loJson.UpdateNewArray("upsellRules[0].occupancyLevelsType")
loJson.UpdateBool("upsellRules[0].useDefaultTrxCode",1)
loJson.UpdateString("upsellRules[0].transactionCode.description","Room Upsell")
loJson.UpdateString("upsellRules[0].transactionCode.transactionCode","1500")
loJson.UpdateString("upsellRules[0].transactionCode.hotelId","{{HotelId}}")
loJson.UpdateString("upsellRules[0].hotelId","{{HotelId}}")
loJson.UpdateString("upsellRules[0].upsellRuleCode","NEWUPSELLRULE1")

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}}")

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbRequestBody = CreateObject('Chilkat.StringBuilder')
loJson.EmitSb(loSbRequestBody)

loResp = loHttp.PTextSb("PUT","https://domain.com/rsv/config/v0/hotels/{{HotelId}}/upsellRules",loSbRequestBody,"utf-8","application/json",0,0)
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJson
    RELEASE loSbRequestBody
    CANCEL
ENDIF

? STR(loResp.StatusCode)
? loResp.BodyStr
RELEASE loResp

RELEASE loHttp
RELEASE loJson
RELEASE loSbRequestBody

Curl Command

curl -X PUT
	-H "Authorization: Bearer <access_token>"
	-H "Content-Type: application/json"
	-H "x-hotelid: {{HotelId}}"
	-H "x-app-key: {{AppKey}}"
	-d '{
    "upsellRules": [
        {
            "description": "New upsell rule",
            "upsellByRoomType": false,
            "fromRoomTypeOrFromRoomClass": "STDQ",
            "toRoomTypeOrToRoomClass": "*",
            "startDate": "2021-07-03",
            "upsellByOccupancyLevels": false,
            "formula": "FlatAmountAddedToOriginalRate",
            "upsellAmount": "11",
            "currencyCode": "USD",
            "roundingRule": "None",
            "occupancyLevelsType": [],
            "useDefaultTrxCode": true,
             "transactionCode": {
                "description": "Room Upsell",
                "transactionCode": "1500",
                "hotelId": "{{HotelId}}"
            },
            "hotelId": "{{HotelId}}",
            "upsellRuleCode": "NEWUPSELLRULE1"
        }
    ]
}'
https://domain.com/rsv/config/v0/hotels/{{HotelId}}/upsellRules

Postman Collection Item JSON

{
  "name": "Update an upsell rule",
  "request": {
    "auth": {
      "type": "bearer",
      "bearer": [
        {
          "key": "token",
          "value": "{{Token}}",
          "type": "string"
        }
      ]
    },
    "method": "PUT",
    "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 upsell rule\",\r\n            \"upsellByRoomType\": false,\r\n            \"fromRoomTypeOrFromRoomClass\": \"STDQ\",\r\n            \"toRoomTypeOrToRoomClass\": \"*\",\r\n            \"startDate\": \"2021-07-03\",\r\n            \"upsellByOccupancyLevels\": false,\r\n            \"formula\": \"FlatAmountAddedToOriginalRate\",\r\n            \"upsellAmount\": \"11\",\r\n            \"currencyCode\": \"USD\",\r\n            \"roundingRule\": \"None\",\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\": \"NEWUPSELLRULE1\"\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": [
  ]
}