Chilkat Online Tools

PowerBuilder / ORACLE Hospitality OPERA Cloud REST API Workflows / Update an existing Rate Plan

Back to Collection Items

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Json
oleobject loo_SbRequestBody
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
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.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.

// {
//   "ratePlan": {
//     "primaryDetails": {
//       "description": {
//         "defaultText": "Description of rate code "
//       },
//       "startSellDate": "2021-07-03",
//       "endSellDate": "2021-08-31",
//       "privilegedRate": false,
//       "privilegedRateRestriction": false,
//       "lockStatus": "Unlocked"
//     },
//     "classifications": {
//       "rateCategory": "PHONE",
//       "marketCode": "BUSINESS"
//     },
//     "roomTypeList": [
//       {
//         "code": "ECO"
//       },
//       {
//         "code": "SUP"
//       }
//     ],
//     "mobileCheckinAllowed": false,
//     "mobileCheckoutAllowed": false,
//     "hotelId": "{{HotelId}}",
//     "ratePlanCode": "{{RatePlanCode}}",
//     "supressRate": false,
//     "printRate": true,
//     "discountAllowed": false,
//     "redemption": false,
//     "bARRate": false,
//     "daily": false,
//     "tiered": false,
//     "dayUse": false,
//     "dayType": false,
//     "complimentary": false,
//     "houseUse": false,
//     "negotiated": false,
//     "ownerRate": false,
//     "membershipEligible": true,
//     "advancedDailyBase": false,
//     "advancedDailyRate": false
//   }
// }

loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.UpdateString("ratePlan.primaryDetails.description.defaultText","Description of rate code ")
loo_Json.UpdateString("ratePlan.primaryDetails.startSellDate","2021-07-03")
loo_Json.UpdateString("ratePlan.primaryDetails.endSellDate","2021-08-31")
loo_Json.UpdateBool("ratePlan.primaryDetails.privilegedRate",0)
loo_Json.UpdateBool("ratePlan.primaryDetails.privilegedRateRestriction",0)
loo_Json.UpdateString("ratePlan.primaryDetails.lockStatus","Unlocked")
loo_Json.UpdateString("ratePlan.classifications.rateCategory","PHONE")
loo_Json.UpdateString("ratePlan.classifications.marketCode","BUSINESS")
loo_Json.UpdateString("ratePlan.roomTypeList[0].code","ECO")
loo_Json.UpdateString("ratePlan.roomTypeList[1].code","SUP")
loo_Json.UpdateBool("ratePlan.mobileCheckinAllowed",0)
loo_Json.UpdateBool("ratePlan.mobileCheckoutAllowed",0)
loo_Json.UpdateString("ratePlan.hotelId","{{HotelId}}")
loo_Json.UpdateString("ratePlan.ratePlanCode","{{RatePlanCode}}")
loo_Json.UpdateBool("ratePlan.supressRate",0)
loo_Json.UpdateBool("ratePlan.printRate",1)
loo_Json.UpdateBool("ratePlan.discountAllowed",0)
loo_Json.UpdateBool("ratePlan.redemption",0)
loo_Json.UpdateBool("ratePlan.bARRate",0)
loo_Json.UpdateBool("ratePlan.daily",0)
loo_Json.UpdateBool("ratePlan.tiered",0)
loo_Json.UpdateBool("ratePlan.dayUse",0)
loo_Json.UpdateBool("ratePlan.dayType",0)
loo_Json.UpdateBool("ratePlan.complimentary",0)
loo_Json.UpdateBool("ratePlan.houseUse",0)
loo_Json.UpdateBool("ratePlan.negotiated",0)
loo_Json.UpdateBool("ratePlan.ownerRate",0)
loo_Json.UpdateBool("ratePlan.membershipEligible",1)
loo_Json.UpdateBool("ratePlan.advancedDailyBase",0)
loo_Json.UpdateBool("ratePlan.advancedDailyRate",0)

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

loo_SbRequestBody = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbRequestBody.ConnectToNewObject("Chilkat.StringBuilder")

loo_Json.EmitSb(loo_SbRequestBody)

loo_Resp = loo_Http.PTextSb("PUT","https://domain.com/rtp/v0/hotels/{{HotelId}}/ratePlans/{{RatePlanCode}}",loo_SbRequestBody,"utf-8","application/json;charset=UTF-8",0,0)
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_Json
    destroy loo_SbRequestBody
    return
end if

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


destroy loo_Http
destroy loo_Json
destroy loo_SbRequestBody

Curl Command

curl -X PUT
	-H "Authorization: Bearer <access_token>"
	-H "Content-Type: application/json;charset=UTF-8"
	-H "Accept: application/json;charset=UTF-8"
	-H "x-hotelid: {{HotelId}}"
	-H "x-app-key: {{AppKey}}"
	-d '{
    "ratePlan": {
        "primaryDetails": {
            "description": {
                "defaultText": "Description of rate code "
            },
            "startSellDate": "2021-07-03",
            "endSellDate": "2021-08-31",
            "privilegedRate": false,
            "privilegedRateRestriction": false,
            "lockStatus": "Unlocked"
        },
        "classifications": {
            "rateCategory": "PHONE",
            "marketCode": "BUSINESS"
        },
        "roomTypeList": [
            {
                "code": "ECO"
            },
            {
                "code": "SUP"
            }
        ],
        "mobileCheckinAllowed": false,
        "mobileCheckoutAllowed": false,
        "hotelId": "{{HotelId}}",
        "ratePlanCode": "{{RatePlanCode}}",
        "supressRate": false,
        "printRate": true,
        "discountAllowed": false,
        "redemption": false,
        "bARRate": false,
        "daily": false,
        "tiered": false,
        "dayUse": false,
        "dayType": false,
        "complimentary": false,
        "houseUse": false,
        "negotiated": false,
        "ownerRate": false,
        "membershipEligible": true,
        "advancedDailyBase": false,
        "advancedDailyRate": false
    }
}'
https://domain.com/rtp/v0/hotels/{{HotelId}}/ratePlans/{{RatePlanCode}}

Postman Collection Item JSON

{
  "name": "Update an existing Rate Plan",
  "request": {
    "auth": {
      "type": "bearer",
      "bearer": [
        {
          "key": "token",
          "value": "{{Token}}",
          "type": "string"
        }
      ]
    },
    "method": "PUT",
    "header": [
      {
        "key": "Content-Type",
        "type": "text",
        "value": "application/json;charset=UTF-8"
      },
      {
        "key": "Accept",
        "type": "text",
        "value": "application/json;charset=UTF-8"
      },
      {
        "key": "x-hotelid",
        "type": "text",
        "value": "{{HotelId}}"
      },
      {
        "key": "x-app-key",
        "type": "text",
        "value": "{{AppKey}}"
      }
    ],
    "body": {
      "mode": "raw",
      "raw": "{\r\n    \"ratePlan\": {\r\n        \"primaryDetails\": {\r\n            \"description\": {\r\n                \"defaultText\": \"Description of rate code \"\r\n            },\r\n            \"startSellDate\": \"2021-07-03\",\r\n            \"endSellDate\": \"2021-08-31\",\r\n            \"privilegedRate\": false,\r\n            \"privilegedRateRestriction\": false,\r\n            \"lockStatus\": \"Unlocked\"\r\n        },\r\n        \"classifications\": {\r\n            \"rateCategory\": \"PHONE\",\r\n            \"marketCode\": \"BUSINESS\"\r\n        },\r\n        \"roomTypeList\": [\r\n            {\r\n                \"code\": \"ECO\"\r\n            },\r\n            {\r\n                \"code\": \"SUP\"\r\n            }\r\n        ],\r\n        \"mobileCheckinAllowed\": false,\r\n        \"mobileCheckoutAllowed\": false,\r\n        \"hotelId\": \"{{HotelId}}\",\r\n        \"ratePlanCode\": \"{{RatePlanCode}}\",\r\n        \"supressRate\": false,\r\n        \"printRate\": true,\r\n        \"discountAllowed\": false,\r\n        \"redemption\": false,\r\n        \"bARRate\": false,\r\n        \"daily\": false,\r\n        \"tiered\": false,\r\n        \"dayUse\": false,\r\n        \"dayType\": false,\r\n        \"complimentary\": false,\r\n        \"houseUse\": false,\r\n        \"negotiated\": false,\r\n        \"ownerRate\": false,\r\n        \"membershipEligible\": true,\r\n        \"advancedDailyBase\": false,\r\n        \"advancedDailyRate\": false\r\n    }\r\n}"
    },
    "url": {
      "raw": "{{HostName}}/rtp/v0/hotels/{{HotelId}}/ratePlans/{{RatePlanCode}}",
      "host": [
        "{{HostName}}"
      ],
      "path": [
        "rtp",
        "v0",
        "hotels",
        "{{HotelId}}",
        "ratePlans",
        "{{RatePlanCode}}"
      ]
    }
  },
  "response": [
  ]
}