Chilkat Online Tools

Foxpro / ORACLE Hospitality OPERA Cloud REST API Workflows / Create a new Rate Plans

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loJson
LOCAL loResp

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

loHttp = CreateObject('Chilkat_9_5_0.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.

* {
*   "ratePlan": {
*     "primaryDetails": {
*       "description": {
*         "defaultText": "Rate Code Description Goes Here"
*       },
*       "startSellDate": "2021-01-03",
*       "endSellDate": "2021-12-31",
*       "privilegedRate": false,
*       "privilegedRateRestriction": false,
*       "lockStatus": "Unlocked"
*     },
*     "classifications": {
*       "rateCategory": "HOTEL",
*       "marketCode": "LEISURE"
*     },
*     "transactionDetails": {
*       "folioText": {
*         "defaultText": "Accommodation"
*       },
*       "transactionCode": "1000",
*       "currencyCode": "USD",
*       "rateIncludesTax": true
*     },
*     "rateCommission": {},
*     "roomTypeList": [
*       {
*         "code": "ECO"
*       },
*       {
*         "code": "SGL"
*       },
*       {
*         "code": "DBL"
*       },
*       {
*         "code": "SUP"
*       },
*       {
*         "code": "JSUI"
*       },
*       {
*         "code": "SUI"
*       }
*     ],
*     "ratePackages": {
*       "packages": [
*       ],
*       "packageGroups": [
*       ]
*     },
*     "controls": {
*       "sell": {
*         "minimumStayThrough": "1",
*         "minimumLengthOfStay": "1"
*       },
*       "yield": {
*         "yieldable": "NonYieldable"
*       }
*     },
*     "distribution": {
*       "restrictionUpdate": false,
*       "rateUpdate": false,
*       "myFidelioUploadAllowed": false,
*       "channelRateMappingExists": false,
*       "channelAllowed": false
*     },
*     "ratePlanBasedOnRates": [
*       {
*         "basedOnRatePlanType": "None"
*       }
*     ],
*     "approvalNotes": [
*       {}
*     ],
*     "mobileCheckinAllowed": false,
*     "mobileCheckoutAllowed": false,
*     "hotelId": "{{HotelId}}",
*     "ratePlanCode": "RACK123",
*     "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
*   }
* }

loJson = CreateObject('Chilkat_9_5_0.JsonObject')
loJson.UpdateString("ratePlan.primaryDetails.description.defaultText","Rate Code Description Goes Here")
loJson.UpdateString("ratePlan.primaryDetails.startSellDate","2021-01-03")
loJson.UpdateString("ratePlan.primaryDetails.endSellDate","2021-12-31")
loJson.UpdateBool("ratePlan.primaryDetails.privilegedRate",0)
loJson.UpdateBool("ratePlan.primaryDetails.privilegedRateRestriction",0)
loJson.UpdateString("ratePlan.primaryDetails.lockStatus","Unlocked")
loJson.UpdateString("ratePlan.classifications.rateCategory","HOTEL")
loJson.UpdateString("ratePlan.classifications.marketCode","LEISURE")
loJson.UpdateString("ratePlan.transactionDetails.folioText.defaultText","Accommodation")
loJson.UpdateString("ratePlan.transactionDetails.transactionCode","1000")
loJson.UpdateString("ratePlan.transactionDetails.currencyCode","USD")
loJson.UpdateBool("ratePlan.transactionDetails.rateIncludesTax",1)
loJson.UpdateNewObject("ratePlan.rateCommission")
loJson.UpdateString("ratePlan.roomTypeList[0].code","ECO")
loJson.UpdateString("ratePlan.roomTypeList[1].code","SGL")
loJson.UpdateString("ratePlan.roomTypeList[2].code","DBL")
loJson.UpdateString("ratePlan.roomTypeList[3].code","SUP")
loJson.UpdateString("ratePlan.roomTypeList[4].code","JSUI")
loJson.UpdateString("ratePlan.roomTypeList[5].code","SUI")
loJson.UpdateNewArray("ratePlan.ratePackages.packages")
loJson.UpdateNewArray("ratePlan.ratePackages.packageGroups")
loJson.UpdateString("ratePlan.controls.sell.minimumStayThrough","1")
loJson.UpdateString("ratePlan.controls.sell.minimumLengthOfStay","1")
loJson.UpdateString("ratePlan.controls.yield.yieldable","NonYieldable")
loJson.UpdateBool("ratePlan.distribution.restrictionUpdate",0)
loJson.UpdateBool("ratePlan.distribution.rateUpdate",0)
loJson.UpdateBool("ratePlan.distribution.myFidelioUploadAllowed",0)
loJson.UpdateBool("ratePlan.distribution.channelRateMappingExists",0)
loJson.UpdateBool("ratePlan.distribution.channelAllowed",0)
loJson.UpdateString("ratePlan.ratePlanBasedOnRates[0].basedOnRatePlanType","None")
loJson.UpdateBool("ratePlan.mobileCheckinAllowed",0)
loJson.UpdateBool("ratePlan.mobileCheckoutAllowed",0)
loJson.UpdateString("ratePlan.hotelId","{{HotelId}}")
loJson.UpdateString("ratePlan.ratePlanCode","RACK123")
loJson.UpdateBool("ratePlan.supressRate",0)
loJson.UpdateBool("ratePlan.printRate",1)
loJson.UpdateBool("ratePlan.discountAllowed",0)
loJson.UpdateBool("ratePlan.redemption",0)
loJson.UpdateBool("ratePlan.bARRate",0)
loJson.UpdateBool("ratePlan.daily",0)
loJson.UpdateBool("ratePlan.tiered",0)
loJson.UpdateBool("ratePlan.dayUse",0)
loJson.UpdateBool("ratePlan.dayType",0)
loJson.UpdateBool("ratePlan.complimentary",0)
loJson.UpdateBool("ratePlan.houseUse",0)
loJson.UpdateBool("ratePlan.negotiated",0)
loJson.UpdateBool("ratePlan.ownerRate",0)
loJson.UpdateBool("ratePlan.membershipEligible",1)
loJson.UpdateBool("ratePlan.advancedDailyBase",0)
loJson.UpdateBool("ratePlan.advancedDailyRate",0)

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

loResp = loHttp.PostJson3("https://domain.com/rtp/v0/hotels/{{HotelId}}/ratePlans","application/json;charset=UTF-8",loJson)
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJson
    CANCEL
ENDIF

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

RELEASE loHttp
RELEASE loJson

Curl Command

curl -X POST
	-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": "Rate Code Description Goes Here"
            },
            "startSellDate": "2021-01-03",
            "endSellDate": "2021-12-31",
            "privilegedRate": false,
            "privilegedRateRestriction": false,
            "lockStatus": "Unlocked"
        },
        "classifications": {
            "rateCategory": "HOTEL",
            "marketCode": "LEISURE"
        },
        "transactionDetails": {
            "folioText": {
                "defaultText": "Accommodation"
            },
            "transactionCode": "1000",
            "currencyCode": "USD",
            "rateIncludesTax": true
        },
        "rateCommission": {},
        "roomTypeList": [
            {
                "code": "ECO"
            },
            {
                "code": "SGL"
            },
            {
                "code": "DBL"
            },
            {
                "code": "SUP"
            },
            {
                "code": "JSUI"
            },
            {
                "code": "SUI"
            }
        ],
        "ratePackages": {
            "packages": [],
            "packageGroups": []
        },
        "controls": {
            "sell": {
                "minimumStayThrough": "1",
                "minimumLengthOfStay": "1"
            },
            "yield": {
                "yieldable": "NonYieldable"
            }
        },
        "distribution": {
            "restrictionUpdate": false,
            "rateUpdate": false,
            "myFidelioUploadAllowed": false,
            "channelRateMappingExists": false,
            "channelAllowed": false
        },
        "ratePlanBasedOnRates": [
            {
                "basedOnRatePlanType": "None"
            }
        ],
        "approvalNotes": [
            {}
        ],
        "mobileCheckinAllowed": false,
        "mobileCheckoutAllowed": false,
        "hotelId": "{{HotelId}}",
        "ratePlanCode": "RACK123",
        "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

Postman Collection Item JSON

{
  "name": "Create a new Rate Plans",
  "request": {
    "auth": {
      "type": "bearer",
      "bearer": [
        {
          "key": "token",
          "value": "{{Token}}",
          "type": "string"
        }
      ]
    },
    "method": "POST",
    "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\": \"Rate Code Description Goes Here\"\r\n            },\r\n            \"startSellDate\": \"2021-01-03\",\r\n            \"endSellDate\": \"2021-12-31\",\r\n            \"privilegedRate\": false,\r\n            \"privilegedRateRestriction\": false,\r\n            \"lockStatus\": \"Unlocked\"\r\n        },\r\n        \"classifications\": {\r\n            \"rateCategory\": \"HOTEL\",\r\n            \"marketCode\": \"LEISURE\"\r\n        },\r\n        \"transactionDetails\": {\r\n            \"folioText\": {\r\n                \"defaultText\": \"Accommodation\"\r\n            },\r\n            \"transactionCode\": \"1000\",\r\n            \"currencyCode\": \"USD\",\r\n            \"rateIncludesTax\": true\r\n        },\r\n        \"rateCommission\": {},\r\n        \"roomTypeList\": [\r\n            {\r\n                \"code\": \"ECO\"\r\n            },\r\n            {\r\n                \"code\": \"SGL\"\r\n            },\r\n            {\r\n                \"code\": \"DBL\"\r\n            },\r\n            {\r\n                \"code\": \"SUP\"\r\n            },\r\n            {\r\n                \"code\": \"JSUI\"\r\n            },\r\n            {\r\n                \"code\": \"SUI\"\r\n            }\r\n        ],\r\n        \"ratePackages\": {\r\n            \"packages\": [],\r\n            \"packageGroups\": []\r\n        },\r\n        \"controls\": {\r\n            \"sell\": {\r\n                \"minimumStayThrough\": \"1\",\r\n                \"minimumLengthOfStay\": \"1\"\r\n            },\r\n            \"yield\": {\r\n                \"yieldable\": \"NonYieldable\"\r\n            }\r\n        },\r\n        \"distribution\": {\r\n            \"restrictionUpdate\": false,\r\n            \"rateUpdate\": false,\r\n            \"myFidelioUploadAllowed\": false,\r\n            \"channelRateMappingExists\": false,\r\n            \"channelAllowed\": false\r\n        },\r\n        \"ratePlanBasedOnRates\": [\r\n            {\r\n                \"basedOnRatePlanType\": \"None\"\r\n            }\r\n        ],\r\n        \"approvalNotes\": [\r\n            {}\r\n        ],\r\n        \"mobileCheckinAllowed\": false,\r\n        \"mobileCheckoutAllowed\": false,\r\n        \"hotelId\": \"{{HotelId}}\",\r\n        \"ratePlanCode\": \"RACK123\",\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",
      "host": [
        "{{HostName}}"
      ],
      "path": [
        "rtp",
        "v0",
        "hotels",
        "{{HotelId}}",
        "ratePlans"
      ]
    }
  },
  "response": [
  ]
}