Chilkat Online Tools

VBScript / ORACLE Hospitality OPERA Cloud REST API Workflows / Update a Rate Plan Schedule

Back to Collection Items

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' 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")
set http = 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.

' {
'   "ratePlanScheduleList": [
'     {
'       "ratePlanScheduleId": {
'         "type": "RateSetId",
'         "id": "199827"
'       },
'       "ratePlanScheduleDetail": {
'         "roomTypeList": [
'           "ECO",
'           "SUP"
'         ],
'         "sunday": true,
'         "monday": true,
'         "tuesday": true,
'         "wednesday": true,
'         "thursday": true,
'         "friday": true,
'         "saturday": true,
'         "rateAmounts": {
'           "onePersonRate": "305",
'           "twoPersonRate": "305",
'           "threePersonRate": "344",
'           "fourPersonRate": "340",
'           "fivePersonRate": "400",
'           "rateByAgeBuckets": [
'             {
'               "minimumAge": "0",
'               "maximumAge": "3"
'             },
'             {
'               "minimumAge": "4",
'               "maximumAge": "10"
'             },
'             {
'               "minimumAge": "11",
'               "maximumAge": "17"
'             }
'           ],
'           "overrideFloorAmount": true
'         },
'         "rateAmountBoundaries": {
'           "minimum": {
'             "onePersonRate": "300"
'           },
'           "maximum": {}
'         },
'         "classifications": {},
'         "rateSchedulePackages": {
'           "packages": [
'           ],
'           "packageGroups": [
'           ]
'         },
'         "tierID": "1",
'         "start": "2021-03-11",
'         "end": "2021-03-31"
'       }
'     }
'   ],
'   "hotelId": "{{HotelId}}",
'   "ratePlanCode": "{{RatePlanCode}}"
' }

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleId.type","RateSetId")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleId.id","199827")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.roomTypeList[0]","ECO")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.roomTypeList[1]","SUP")
success = json.UpdateBool("ratePlanScheduleList[0].ratePlanScheduleDetail.sunday",1)
success = json.UpdateBool("ratePlanScheduleList[0].ratePlanScheduleDetail.monday",1)
success = json.UpdateBool("ratePlanScheduleList[0].ratePlanScheduleDetail.tuesday",1)
success = json.UpdateBool("ratePlanScheduleList[0].ratePlanScheduleDetail.wednesday",1)
success = json.UpdateBool("ratePlanScheduleList[0].ratePlanScheduleDetail.thursday",1)
success = json.UpdateBool("ratePlanScheduleList[0].ratePlanScheduleDetail.friday",1)
success = json.UpdateBool("ratePlanScheduleList[0].ratePlanScheduleDetail.saturday",1)
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.onePersonRate","305")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.twoPersonRate","305")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.threePersonRate","344")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.fourPersonRate","340")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.fivePersonRate","400")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.rateByAgeBuckets[0].minimumAge","0")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.rateByAgeBuckets[0].maximumAge","3")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.rateByAgeBuckets[1].minimumAge","4")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.rateByAgeBuckets[1].maximumAge","10")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.rateByAgeBuckets[2].minimumAge","11")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.rateByAgeBuckets[2].maximumAge","17")
success = json.UpdateBool("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmounts.overrideFloorAmount",1)
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmountBoundaries.minimum.onePersonRate","300")
success = json.UpdateNewObject("ratePlanScheduleList[0].ratePlanScheduleDetail.rateAmountBoundaries.maximum")
success = json.UpdateNewObject("ratePlanScheduleList[0].ratePlanScheduleDetail.classifications")
success = json.UpdateNewArray("ratePlanScheduleList[0].ratePlanScheduleDetail.rateSchedulePackages.packages")
success = json.UpdateNewArray("ratePlanScheduleList[0].ratePlanScheduleDetail.rateSchedulePackages.packageGroups")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.tierID","1")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.start","2021-03-11")
success = json.UpdateString("ratePlanScheduleList[0].ratePlanScheduleDetail.end","2021-03-31")
success = json.UpdateString("hotelId","{{HotelId}}")
success = json.UpdateString("ratePlanCode","{{RatePlanCode}}")

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbRequestBody = CreateObject("Chilkat.StringBuilder")
success = json.EmitSb(sbRequestBody)

' resp is a Chilkat.HttpResponse
Set resp = http.PTextSb("PUT","https://domain.com/rtp/v0/hotels/{{HotelId}}/ratePlans/{{RatePlanCode}}/schedules",sbRequestBody,"utf-8","application/json;charset=UTF-8",0,0)
If (http.LastMethodSuccess = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine(resp.StatusCode)
outFile.WriteLine(resp.BodyStr)


outFile.Close

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 '{
    "ratePlanScheduleList": [
        {
            "ratePlanScheduleId": {
                "type": "RateSetId",
                "id": "199827"
            },
            "ratePlanScheduleDetail": {
                "roomTypeList": [
                    "ECO",
                    "SUP"
                ],
                "sunday": true,
                "monday": true,
                "tuesday": true,
                "wednesday": true,
                "thursday": true,
                "friday": true,
                "saturday": true,
                "rateAmounts": {
                    "onePersonRate": "305",
                    "twoPersonRate": "305",
                    "threePersonRate": "344",
                    "fourPersonRate": "340",
                    "fivePersonRate": "400",
                    "rateByAgeBuckets": [
                        {
                            "minimumAge": "0",
                            "maximumAge": "3"
                        },
                        {
                            "minimumAge": "4",
                            "maximumAge": "10"
                        },
                        {
                            "minimumAge": "11",
                            "maximumAge": "17"
                        }
                    ],
                    "overrideFloorAmount": true
                },
                "rateAmountBoundaries": {
                    "minimum": {
                        "onePersonRate": "300"
                    },
                    "maximum": {}
                },
                "classifications": {},
                "rateSchedulePackages": {
                    "packages": [],
                    "packageGroups": []
                },
                "tierID": "1",
                "start": "2021-03-11",
                "end": "2021-03-31"
            }
        }
    ],
    "hotelId": "{{HotelId}}",
    "ratePlanCode": "{{RatePlanCode}}"
}'
https://domain.com/rtp/v0/hotels/{{HotelId}}/ratePlans/{{RatePlanCode}}/schedules

Postman Collection Item JSON

{
  "name": "Update a Rate Plan Schedule",
  "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    \"ratePlanScheduleList\": [\r\n        {\r\n            \"ratePlanScheduleId\": {\r\n                \"type\": \"RateSetId\",\r\n                \"id\": \"199827\"\r\n            },\r\n            \"ratePlanScheduleDetail\": {\r\n                \"roomTypeList\": [\r\n                    \"ECO\",\r\n                    \"SUP\"\r\n                ],\r\n                \"sunday\": true,\r\n                \"monday\": true,\r\n                \"tuesday\": true,\r\n                \"wednesday\": true,\r\n                \"thursday\": true,\r\n                \"friday\": true,\r\n                \"saturday\": true,\r\n                \"rateAmounts\": {\r\n                    \"onePersonRate\": \"305\",\r\n                    \"twoPersonRate\": \"305\",\r\n                    \"threePersonRate\": \"344\",\r\n                    \"fourPersonRate\": \"340\",\r\n                    \"fivePersonRate\": \"400\",\r\n                    \"rateByAgeBuckets\": [\r\n                        {\r\n                            \"minimumAge\": \"0\",\r\n                            \"maximumAge\": \"3\"\r\n                        },\r\n                        {\r\n                            \"minimumAge\": \"4\",\r\n                            \"maximumAge\": \"10\"\r\n                        },\r\n                        {\r\n                            \"minimumAge\": \"11\",\r\n                            \"maximumAge\": \"17\"\r\n                        }\r\n                    ],\r\n                    \"overrideFloorAmount\": true\r\n                },\r\n                \"rateAmountBoundaries\": {\r\n                    \"minimum\": {\r\n                        \"onePersonRate\": \"300\"\r\n                    },\r\n                    \"maximum\": {}\r\n                },\r\n                \"classifications\": {},\r\n                \"rateSchedulePackages\": {\r\n                    \"packages\": [],\r\n                    \"packageGroups\": []\r\n                },\r\n                \"tierID\": \"1\",\r\n                \"start\": \"2021-03-11\",\r\n                \"end\": \"2021-03-31\"\r\n            }\r\n        }\r\n    ],\r\n    \"hotelId\": \"{{HotelId}}\",\r\n    \"ratePlanCode\": \"{{RatePlanCode}}\"\r\n}"
    },
    "url": {
      "raw": "{{HostName}}/rtp/v0/hotels/{{HotelId}}/ratePlans/{{RatePlanCode}}/schedules",
      "host": [
        "{{HostName}}"
      ],
      "path": [
        "rtp",
        "v0",
        "hotels",
        "{{HotelId}}",
        "ratePlans",
        "{{RatePlanCode}}",
        "schedules"
      ]
    }
  },
  "response": [
  ]
}