Chilkat Online Tools

Foxpro / Booking Management API v2021.12 / createBooking - CSL hotel with payment card

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.

* 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.

* {
*   "agency": {
*     "address": {
*       "name": "John Smith",
*       "street": "1230 Ellen Ave, apt 10",
*       "city": "Dallas",
*       "stateProvince": "TX",
*       "postalCode": "75063",
*       "countryCode": "US",
*       "freeText": "John Smith\n1230 Ellen Ave, apt 10\nDallas, TX 75063\nUS"
*     },
*     "agencyCustomerNumber": "1234567",
*     "ticketingPolicy": "TODAY"
*   },
*   "travelers": [
*     {
*       "givenName": "John",
*       "surname": "Kowalski",
*       "passengerCode": "ADT"
*     },
*     {
*       "givenName": "Mary",
*       "surname": "Kowalski",
*       "passengerCode": "ADT"
*     },
*     {
*       "givenName": "Ann",
*       "surname": "Kowalski",
*       "passengerCode": "INS",
*       "age": 3
*     }
*   ],
*   "contactInfo": {
*     "emails": [
*       "travel@sabre.com",
*       "travel2@sabre.com"
*     ],
*     "phones": [
*       "+123456"
*     ]
*   },
*   "hotel": {
*     "useCsl": true,
*     "bookingKey": "{{bookingKey}}",
*     "corporateDiscountCode": 6878700,
*     "rooms": [
*       {
*         "isSmoking": true,
*         "bedTypeCode": 3,
*         "physicalDisabilityCode": 3,
*         "travelerIndices": [
*           1,
*           2,
*           3
*         ]
*       }
*     ],
*     "specialInstruction": "Need a wi-fi in the room.",
*     "paymentPolicy": "DEPOSIT",
*     "formOfPayment": 1
*   },
*   "payment": {
*     "formsOfPayment": [
*       {
*         "type": "PAYMENTCARD",
*         "cardTypeCode": "VI",
*         "cardNumber": "4487971000000006",
*         "cardSecurityCode": "123",
*         "expiryDate": "2022-10",
*         "cardHolder": {
*           "givenName": "John",
*           "surname": "Smith",
*           "email": "john@smith.family.priv",
*           "phone": "+1-555-123-4567",
*           "address": {
*             "street": "1230 Ellen Ave, apt 10",
*             "city": "Dallas",
*             "stateProvince": "TX",
*             "postalCode": "75063",
*             "countryCode": "US"
*           }
*         }
*       },
*       {
*         "type": "VIRTUAL_CARD",
*         "virtualCard": {
*           "customerAccountCode": "John",
*           "agencyEmail": "john@smith.family.priv",
*           "hotelFax": "john@smith.family.priv",
*           "hotelName": "Ilia Hotel and Luxury Suites",
*           "roomType": "2 double beds",
*           "roomDescription": "Deluxe Room, 2 Double Beds",
*           "rateAmount": {
*             "amount": "100.00",
*             "currencyCode": "USD"
*           },
*           "virtualCardCharges": [
*             "Breakfast"
*           ]
*         }
*       },
*       {
*         "type": "AGENCY_NAME",
*         "agencyAddress": {
*           "name": "John Smith",
*           "street": "1230 Ellen Ave, apt 10",
*           "city": "Dallas",
*           "stateProvince": "TX",
*           "postalCode": "75063",
*           "countryCode": "US"
*         }
*       },
*       {
*         "type": "AGENCY_IATA",
*         "agencyIataNumber": "129345738"
*       },
*       {
*         "type": "CORPORATE",
*         "corporateId": "CC006"
*       },
*       {
*         "type": "COMPANY_NAME",
*         "companyAddress": {
*           "name": "John Smith",
*           "street": "1230 Ellen Ave, apt 10",
*           "city": "Dallas",
*           "stateProvince": "TX",
*           "postalCode": "75063",
*           "countryCode": "US"
*         }
*       }
*     ]
*   }
* }

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("agency.address.name","John Smith")
loJson.UpdateString("agency.address.street","1230 Ellen Ave, apt 10")
loJson.UpdateString("agency.address.city","Dallas")
loJson.UpdateString("agency.address.stateProvince","TX")
loJson.UpdateString("agency.address.postalCode","75063")
loJson.UpdateString("agency.address.countryCode","US")
loJson.UpdateString("agency.address.freeText","John Smith" + CHR(10) + "1230 Ellen Ave, apt 10" + CHR(10) + "Dallas, TX 75063" + CHR(10) + "US")
loJson.UpdateString("agency.agencyCustomerNumber","1234567")
loJson.UpdateString("agency.ticketingPolicy","TODAY")
loJson.UpdateString("travelers[0].givenName","John")
loJson.UpdateString("travelers[0].surname","Kowalski")
loJson.UpdateString("travelers[0].passengerCode","ADT")
loJson.UpdateString("travelers[1].givenName","Mary")
loJson.UpdateString("travelers[1].surname","Kowalski")
loJson.UpdateString("travelers[1].passengerCode","ADT")
loJson.UpdateString("travelers[2].givenName","Ann")
loJson.UpdateString("travelers[2].surname","Kowalski")
loJson.UpdateString("travelers[2].passengerCode","INS")
loJson.UpdateInt("travelers[2].age",3)
loJson.UpdateString("contactInfo.emails[0]","travel@sabre.com")
loJson.UpdateString("contactInfo.emails[1]","travel2@sabre.com")
loJson.UpdateString("contactInfo.phones[0]","+123456")
loJson.UpdateBool("hotel.useCsl",1)
loJson.UpdateString("hotel.bookingKey","{{bookingKey}}")
loJson.UpdateInt("hotel.corporateDiscountCode",6878700)
loJson.UpdateBool("hotel.rooms[0].isSmoking",1)
loJson.UpdateInt("hotel.rooms[0].bedTypeCode",3)
loJson.UpdateInt("hotel.rooms[0].physicalDisabilityCode",3)
loJson.UpdateInt("hotel.rooms[0].travelerIndices[0]",1)
loJson.UpdateInt("hotel.rooms[0].travelerIndices[1]",2)
loJson.UpdateInt("hotel.rooms[0].travelerIndices[2]",3)
loJson.UpdateString("hotel.specialInstruction","Need a wi-fi in the room.")
loJson.UpdateString("hotel.paymentPolicy","DEPOSIT")
loJson.UpdateInt("hotel.formOfPayment",1)
loJson.UpdateString("payment.formsOfPayment[0].type","PAYMENTCARD")
loJson.UpdateString("payment.formsOfPayment[0].cardTypeCode","VI")
loJson.UpdateString("payment.formsOfPayment[0].cardNumber","4487971000000006")
loJson.UpdateString("payment.formsOfPayment[0].cardSecurityCode","123")
loJson.UpdateString("payment.formsOfPayment[0].expiryDate","2022-10")
loJson.UpdateString("payment.formsOfPayment[0].cardHolder.givenName","John")
loJson.UpdateString("payment.formsOfPayment[0].cardHolder.surname","Smith")
loJson.UpdateString("payment.formsOfPayment[0].cardHolder.email","john@smith.family.priv")
loJson.UpdateString("payment.formsOfPayment[0].cardHolder.phone","+1-555-123-4567")
loJson.UpdateString("payment.formsOfPayment[0].cardHolder.address.street","1230 Ellen Ave, apt 10")
loJson.UpdateString("payment.formsOfPayment[0].cardHolder.address.city","Dallas")
loJson.UpdateString("payment.formsOfPayment[0].cardHolder.address.stateProvince","TX")
loJson.UpdateString("payment.formsOfPayment[0].cardHolder.address.postalCode","75063")
loJson.UpdateString("payment.formsOfPayment[0].cardHolder.address.countryCode","US")
loJson.UpdateString("payment.formsOfPayment[1].type","VIRTUAL_CARD")
loJson.UpdateString("payment.formsOfPayment[1].virtualCard.customerAccountCode","John")
loJson.UpdateString("payment.formsOfPayment[1].virtualCard.agencyEmail","john@smith.family.priv")
loJson.UpdateString("payment.formsOfPayment[1].virtualCard.hotelFax","john@smith.family.priv")
loJson.UpdateString("payment.formsOfPayment[1].virtualCard.hotelName","Ilia Hotel and Luxury Suites")
loJson.UpdateString("payment.formsOfPayment[1].virtualCard.roomType","2 double beds")
loJson.UpdateString("payment.formsOfPayment[1].virtualCard.roomDescription","Deluxe Room, 2 Double Beds")
loJson.UpdateString("payment.formsOfPayment[1].virtualCard.rateAmount.amount","100.00")
loJson.UpdateString("payment.formsOfPayment[1].virtualCard.rateAmount.currencyCode","USD")
loJson.UpdateString("payment.formsOfPayment[1].virtualCard.virtualCardCharges[0]","Breakfast")
loJson.UpdateString("payment.formsOfPayment[2].type","AGENCY_NAME")
loJson.UpdateString("payment.formsOfPayment[2].agencyAddress.name","John Smith")
loJson.UpdateString("payment.formsOfPayment[2].agencyAddress.street","1230 Ellen Ave, apt 10")
loJson.UpdateString("payment.formsOfPayment[2].agencyAddress.city","Dallas")
loJson.UpdateString("payment.formsOfPayment[2].agencyAddress.stateProvince","TX")
loJson.UpdateString("payment.formsOfPayment[2].agencyAddress.postalCode","75063")
loJson.UpdateString("payment.formsOfPayment[2].agencyAddress.countryCode","US")
loJson.UpdateString("payment.formsOfPayment[3].type","AGENCY_IATA")
loJson.UpdateString("payment.formsOfPayment[3].agencyIataNumber","129345738")
loJson.UpdateString("payment.formsOfPayment[4].type","CORPORATE")
loJson.UpdateString("payment.formsOfPayment[4].corporateId","CC006")
loJson.UpdateString("payment.formsOfPayment[5].type","COMPANY_NAME")
loJson.UpdateString("payment.formsOfPayment[5].companyAddress.name","John Smith")
loJson.UpdateString("payment.formsOfPayment[5].companyAddress.street","1230 Ellen Ave, apt 10")
loJson.UpdateString("payment.formsOfPayment[5].companyAddress.city","Dallas")
loJson.UpdateString("payment.formsOfPayment[5].companyAddress.stateProvince","TX")
loJson.UpdateString("payment.formsOfPayment[5].companyAddress.postalCode","75063")
loJson.UpdateString("payment.formsOfPayment[5].companyAddress.countryCode","US")

loHttp.SetRequestHeader("accept","application/json")
loHttp.SetRequestHeader("x-request-id","dnjas82bd102bd912requestid")
loHttp.SetRequestHeader("X-Sabre-Group","G7RE")
loHttp.SetRequestHeader("X-Sabre-Current-City","G7RE")
loHttp.SetRequestHeader("ConversationId","dnjas82bd102bd912conversationid")
loHttp.SetRequestHeader("Content-Type","application/json")
* Adds the "Authorization: Bearer <access_token>" header.
loHttp.AuthToken = "<access_token>"

loResp = loHttp.PostJson3("https://domain.com/","application/json",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 "accept: application/json"
	-H "Content-Type: application/json"
	-H "X-Sabre-Group: G7RE"
	-H "X-Sabre-Current-City: G7RE"
	-H "x-request-id: dnjas82bd102bd912requestid"
	-H "ConversationId: dnjas82bd102bd912conversationid"
	-d '{
  "agency": {
    "address": {
      "name": "John Smith",
      "street": "1230 Ellen Ave, apt 10",
      "city": "Dallas",
      "stateProvince": "TX",
      "postalCode": "75063",
      "countryCode": "US",
      "freeText": "John Smith\n1230 Ellen Ave, apt 10\nDallas, TX 75063\nUS"
    },
    "agencyCustomerNumber": "1234567",
    "ticketingPolicy": "TODAY"
  },
  "travelers": [
    {
      "givenName": "John",
      "surname": "Kowalski",
      "passengerCode": "ADT"
    },
    {
      "givenName": "Mary",
      "surname": "Kowalski",
      "passengerCode": "ADT"
    },
    {
      "givenName": "Ann",
      "surname": "Kowalski",
      "passengerCode": "INS",
      "age": 3
    }
  ],
  "contactInfo": {
    "emails": [
      "travel@sabre.com",
      "travel2@sabre.com"
    ],
    "phones": [
      "+123456"
    ]
  },
  "hotel": {
    "useCsl": true,
    "bookingKey": "{{bookingKey}}",
    "corporateDiscountCode": 6878700,
    "rooms": [
      {
        "isSmoking": true,
        "bedTypeCode": 3,
        "physicalDisabilityCode": 3,
        "travelerIndices": [
          1,2,3
        ]
      }
    ],
    "specialInstruction": "Need a wi-fi in the room.",
    "paymentPolicy": "DEPOSIT",
    "formOfPayment": 1
  },
  "payment": {
    "formsOfPayment": [
      {
        "type": "PAYMENTCARD",
        "cardTypeCode": "VI",
        "cardNumber": "4487971000000006",
        "cardSecurityCode": "123",
        "expiryDate": "2022-10",
        "cardHolder": {
          "givenName": "John",
          "surname": "Smith",
          "email": "john@smith.family.priv",
          "phone": "+1-555-123-4567",
          "address": {
            "street": "1230 Ellen Ave, apt 10",
            "city": "Dallas",
            "stateProvince": "TX",
            "postalCode": "75063",
            "countryCode": "US"
          }
        }
      },
      {
        "type": "VIRTUAL_CARD",
        "virtualCard": {
          "customerAccountCode": "John",
          "agencyEmail": "john@smith.family.priv",
          "hotelFax": "john@smith.family.priv",
          "hotelName": "Ilia Hotel and Luxury Suites",
          "roomType": "2 double beds",
          "roomDescription": "Deluxe Room, 2 Double Beds",
          "rateAmount": {
            "amount": "100.00",
            "currencyCode": "USD"
          },
          "virtualCardCharges": [
            "Breakfast"
          ]
        }
      },
      {
        "type": "AGENCY_NAME",
        "agencyAddress": {
          "name": "John Smith",
          "street": "1230 Ellen Ave, apt 10",
          "city": "Dallas",
          "stateProvince": "TX",
          "postalCode": "75063",
          "countryCode": "US"
        }
      },
      {
        "type": "AGENCY_IATA",
        "agencyIataNumber": "129345738"
      },
      {
        "type": "CORPORATE",
        "corporateId": "CC006"
      },
      {
        "type": "COMPANY_NAME",
        "companyAddress": {
          "name": "John Smith",
          "street": "1230 Ellen Ave, apt 10",
          "city": "Dallas",
          "stateProvince": "TX",
          "postalCode": "75063",
          "countryCode": "US"
        }
      }
    ]
  }
}'
https://domain.com/

Postman Collection Item JSON

{
  "name": "createBooking - CSL hotel with payment card",
  "event": [
    {
      "listen": "test",
      "script": {
        "exec": [
          "pm.test(\"response is ok\", function () {\r",
          "    pm.response.to.be.ok;\r",
          "    pm.response.to.have.status(200);\r",
          "});\r",
          "\r",
          "pm.test(\"response must be valid and have a body\", function () {\r",
          "    // this assertion also checks if a body  exists\r",
          "     pm.response.to.be.json; \r",
          "});\r",
          "\r",
          "pm.test(\"passed and returned values of x-request-id and ConversationId must be equal\", function () {\r",
          "    pm.expect(pm.response.headers.get('x-request-id')).to.eql('dnjas82bd102bd912requestid');\r",
          "    pm.expect(pm.response.headers.get('ConversationId')).to.eql('dnjas82bd102bd912conversationid');\r",
          "\r",
          "});"
        ],
        "type": "text/javascript"
      }
    }
  ],
  "request": {
    "method": "POST",
    "header": [
      {
        "key": "accept",
        "type": "text",
        "value": "application/json"
      },
      {
        "key": "Content-Type",
        "name": "Content-Type",
        "type": "text",
        "value": "application/json"
      },
      {
        "key": "X-Sabre-Group",
        "value": "G7RE",
        "type": "text"
      },
      {
        "key": "X-Sabre-Current-City",
        "value": "G7RE",
        "type": "text"
      },
      {
        "key": "x-request-id",
        "value": "dnjas82bd102bd912requestid",
        "type": "text"
      },
      {
        "key": "ConversationId",
        "value": "dnjas82bd102bd912conversationid",
        "type": "text"
      }
    ],
    "body": {
      "mode": "raw",
      "raw": "{\n  \"agency\": {\n    \"address\": {\n      \"name\": \"John Smith\",\n      \"street\": \"1230 Ellen Ave, apt 10\",\n      \"city\": \"Dallas\",\n      \"stateProvince\": \"TX\",\n      \"postalCode\": \"75063\",\n      \"countryCode\": \"US\",\n      \"freeText\": \"John Smith\\n1230 Ellen Ave, apt 10\\nDallas, TX 75063\\nUS\"\n    },\n    \"agencyCustomerNumber\": \"1234567\",\n    \"ticketingPolicy\": \"TODAY\"\n  },\n  \"travelers\": [\n    {\n      \"givenName\": \"John\",\n      \"surname\": \"Kowalski\",\n      \"passengerCode\": \"ADT\"\n    },\n    {\n      \"givenName\": \"Mary\",\n      \"surname\": \"Kowalski\",\n      \"passengerCode\": \"ADT\"\n    },\n    {\n      \"givenName\": \"Ann\",\n      \"surname\": \"Kowalski\",\n      \"passengerCode\": \"INS\",\n      \"age\": 3\n    }\n  ],\n  \"contactInfo\": {\n    \"emails\": [\n      \"travel@sabre.com\",\n      \"travel2@sabre.com\"\n    ],\n    \"phones\": [\n      \"+123456\"\n    ]\n  },\n  \"hotel\": {\n    \"useCsl\": true,\n    \"bookingKey\": \"{{bookingKey}}\",\n    \"corporateDiscountCode\": 6878700,\n    \"rooms\": [\n      {\n        \"isSmoking\": true,\n        \"bedTypeCode\": 3,\n        \"physicalDisabilityCode\": 3,\n        \"travelerIndices\": [\n          1,2,3\n        ]\n      }\n    ],\n    \"specialInstruction\": \"Need a wi-fi in the room.\",\n    \"paymentPolicy\": \"DEPOSIT\",\n    \"formOfPayment\": 1\n  },\n  \"payment\": {\n    \"formsOfPayment\": [\n      {\n        \"type\": \"PAYMENTCARD\",\n        \"cardTypeCode\": \"VI\",\n        \"cardNumber\": \"4487971000000006\",\n        \"cardSecurityCode\": \"123\",\n        \"expiryDate\": \"2022-10\",\n        \"cardHolder\": {\n          \"givenName\": \"John\",\n          \"surname\": \"Smith\",\n          \"email\": \"john@smith.family.priv\",\n          \"phone\": \"+1-555-123-4567\",\n          \"address\": {\n            \"street\": \"1230 Ellen Ave, apt 10\",\n            \"city\": \"Dallas\",\n            \"stateProvince\": \"TX\",\n            \"postalCode\": \"75063\",\n            \"countryCode\": \"US\"\n          }\n        }\n      },\n      {\n        \"type\": \"VIRTUAL_CARD\",\n        \"virtualCard\": {\n          \"customerAccountCode\": \"John\",\n          \"agencyEmail\": \"john@smith.family.priv\",\n          \"hotelFax\": \"john@smith.family.priv\",\n          \"hotelName\": \"Ilia Hotel and Luxury Suites\",\n          \"roomType\": \"2 double beds\",\n          \"roomDescription\": \"Deluxe Room, 2 Double Beds\",\n          \"rateAmount\": {\n            \"amount\": \"100.00\",\n            \"currencyCode\": \"USD\"\n          },\n          \"virtualCardCharges\": [\n            \"Breakfast\"\n          ]\n        }\n      },\n      {\n        \"type\": \"AGENCY_NAME\",\n        \"agencyAddress\": {\n          \"name\": \"John Smith\",\n          \"street\": \"1230 Ellen Ave, apt 10\",\n          \"city\": \"Dallas\",\n          \"stateProvince\": \"TX\",\n          \"postalCode\": \"75063\",\n          \"countryCode\": \"US\"\n        }\n      },\n      {\n        \"type\": \"AGENCY_IATA\",\n        \"agencyIataNumber\": \"129345738\"\n      },\n      {\n        \"type\": \"CORPORATE\",\n        \"corporateId\": \"CC006\"\n      },\n      {\n        \"type\": \"COMPANY_NAME\",\n        \"companyAddress\": {\n          \"name\": \"John Smith\",\n          \"street\": \"1230 Ellen Ave, apt 10\",\n          \"city\": \"Dallas\",\n          \"stateProvince\": \"TX\",\n          \"postalCode\": \"75063\",\n          \"countryCode\": \"US\"\n        }\n      }\n    ]\n  }\n}"
    },
    "url": {
      "raw": "{{createBooking_endpoint}}",
      "host": [
        "{{createBooking_endpoint}}"
      ]
    },
    "description": "### <br>"
  },
  "response": [
  ]
}