Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
-- 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": "Smith",
-- "birthDate": "1970-01-23",
-- "passengerCode": "ADT"
-- },
-- {
-- "givenName": "All",
-- "surname": "Smith",
-- "birthDate": "2000-01-23",
-- "passengerCode": "CNN"
-- }
-- ],
-- "contactInfo": {
-- "emails": [
-- "travel@sabre.com",
-- "travel2@sabre.com"
-- ],
-- "phones": [
-- "+123456"
-- ]
-- },
-- "flightDetails": {
-- "flights": [
-- {
-- "flightNumber": 463,
-- "airlineCode": "EY",
-- "fromAirportCode": "MEL",
-- "toAirportCode": "AUH",
-- "departureDate": "{{start_date}}",
-- "departureTime": "16:55",
-- "bookingClass": "Y",
-- "marriageGroup": false,
-- "flightStatusCode": "NN"
-- },
-- {
-- "flightNumber": 462,
-- "airlineCode": "EY",
-- "fromAirportCode": "AUH",
-- "toAirportCode": "MEL",
-- "departureDate": "{{end_date}}",
-- "departureTime": "09:00",
-- "bookingClass": "Y",
-- "marriageGroup": false,
-- "flightStatusCode": "NN"
-- }
-- ],
-- "flightPricing": [
-- {
-- "priceComparisons": [
-- {
-- "desiredAmount": "5300.00",
-- "comparisonType": "INCREASE_BY_AMOUNT",
-- "amount": "30.00"
-- },
-- {
-- "desiredAmount": "5300.00",
-- "comparisonType": "DECREASE_BY_AMOUNT",
-- "amount": "30.00"
-- }
-- ]
-- }
-- ]
-- },
-- "payment": {
-- "billingAddress": {
-- "name": "John Smith",
-- "street": "1230 Ellen Ave, apt 10",
-- "city": "Dallas",
-- "stateProvince": "TX",
-- "postalCode": "75063",
-- "countryCode": "US"
-- }
-- }
-- }
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'agency.address.name', 'John Smith'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'agency.address.street', '1230 Ellen Ave, apt 10'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'agency.address.city', 'Dallas'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'agency.address.stateProvince', 'TX'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'agency.address.postalCode', '75063'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'agency.address.countryCode', 'US'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'agency.address.freeText', 'John Smith' + CHAR(10) + '1230 Ellen Ave, apt 10' + CHAR(10) + 'Dallas, TX 75063' + CHAR(10) + 'US'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'agency.agencyCustomerNumber', '1234567'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'agency.ticketingPolicy', 'TODAY'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'travelers[0].givenName', 'John'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'travelers[0].surname', 'Smith'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'travelers[0].birthDate', '1970-01-23'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'travelers[0].passengerCode', 'ADT'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'travelers[1].givenName', 'All'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'travelers[1].surname', 'Smith'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'travelers[1].birthDate', '2000-01-23'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'travelers[1].passengerCode', 'CNN'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'contactInfo.emails[0]', 'travel@sabre.com'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'contactInfo.emails[1]', 'travel2@sabre.com'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'contactInfo.phones[0]', '+123456'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'flightDetails.flights[0].flightNumber', 463
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[0].airlineCode', 'EY'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[0].fromAirportCode', 'MEL'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[0].toAirportCode', 'AUH'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[0].departureDate', '{{start_date}}'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[0].departureTime', '16:55'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[0].bookingClass', 'Y'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'flightDetails.flights[0].marriageGroup', 0
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[0].flightStatusCode', 'NN'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'flightDetails.flights[1].flightNumber', 462
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[1].airlineCode', 'EY'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[1].fromAirportCode', 'AUH'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[1].toAirportCode', 'MEL'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[1].departureDate', '{{end_date}}'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[1].departureTime', '09:00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[1].bookingClass', 'Y'
EXEC sp_OAMethod @json, 'UpdateBool', @success OUT, 'flightDetails.flights[1].marriageGroup', 0
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flights[1].flightStatusCode', 'NN'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flightPricing[0].priceComparisons[0].desiredAmount', '5300.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flightPricing[0].priceComparisons[0].comparisonType', 'INCREASE_BY_AMOUNT'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flightPricing[0].priceComparisons[0].amount', '30.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flightPricing[0].priceComparisons[1].desiredAmount', '5300.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flightPricing[0].priceComparisons[1].comparisonType', 'DECREASE_BY_AMOUNT'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'flightDetails.flightPricing[0].priceComparisons[1].amount', '30.00'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payment.billingAddress.name', 'John Smith'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payment.billingAddress.street', '1230 Ellen Ave, apt 10'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payment.billingAddress.city', 'Dallas'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payment.billingAddress.stateProvince', 'TX'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payment.billingAddress.postalCode', '75063'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payment.billingAddress.countryCode', 'US'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Conversation-ID', '{{conv_id}}'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Type', 'application/json'
-- Adds the "Authorization: Bearer <access_token>" header.
EXEC sp_OASetProperty @http, 'AuthToken', '<access_token>'
DECLARE @resp int
EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://domain.com/v1/trip/orders/createBooking', 'application/json', @json
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT @iTmp0
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
END
GO
Curl Command
curl -X POST
-H "Authorization: Bearer <access_token>"
-H "Content-Type: application/json"
-H "Conversation-ID: {{conv_id}}"
-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": "Smith",
"birthDate": "1970-01-23",
"passengerCode": "ADT"
},
{
"givenName": "All",
"surname": "Smith",
"birthDate": "2000-01-23",
"passengerCode": "CNN"
}
],
"contactInfo":
{
"emails": [
"travel@sabre.com",
"travel2@sabre.com"
],
"phones": [
"+123456"
]
},
"flightDetails": {
"flights": [
{
"flightNumber": 463,
"airlineCode": "EY",
"fromAirportCode": "MEL",
"toAirportCode": "AUH",
"departureDate": "{{start_date}}",
"departureTime": "16:55",
"bookingClass": "Y",
"marriageGroup": false,
"flightStatusCode": "NN"
},
{
"flightNumber": 462,
"airlineCode": "EY",
"fromAirportCode": "AUH",
"toAirportCode": "MEL",
"departureDate": "{{end_date}}",
"departureTime": "09:00",
"bookingClass": "Y",
"marriageGroup": false,
"flightStatusCode": "NN"
}
],
"flightPricing": [
{
"priceComparisons": [
{
"desiredAmount": "5300.00",
"comparisonType": "INCREASE_BY_AMOUNT",
"amount": "30.00"
},
{
"desiredAmount": "5300.00",
"comparisonType": "DECREASE_BY_AMOUNT",
"amount": "30.00"
}
]
}
]
},
"payment": {
"billingAddress": {
"name": "John Smith",
"street": "1230 Ellen Ave, apt 10",
"city": "Dallas",
"stateProvince": "TX",
"postalCode": "75063",
"countryCode": "US"
}
}
}'
https://domain.com/v1/trip/orders/createBooking
Postman Collection Item JSON
{
"name": "createBooking - Air with price comparison",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"type": "text",
"value": "application/json"
},
{
"key": "Conversation-ID",
"type": "text",
"value": "{{conv_id}}"
}
],
"body": {
"mode": "raw",
"raw": "{\n\t \"agency\": {\n\t\t\"address\": {\n\t\t\t\"name\": \"John Smith\",\n\t\t\t\"street\": \"1230 Ellen Ave, apt 10\",\n\t\t\t\"city\": \"Dallas\",\n\t\t\t\"stateProvince\": \"TX\",\n\t\t\t\"postalCode\": \"75063\",\n\t\t\t\"countryCode\": \"US\",\n\t\t\t\"freeText\": \"John Smith\\n1230 Ellen Ave, apt 10\\nDallas, TX 75063\\nUS\"\n\t\t},\n\t\t\"agencyCustomerNumber\": \"1234567\",\n\t\t\"ticketingPolicy\": \"TODAY\"\n \t},\n\t\"travelers\": [\n\t\t{\n\t\t\t\"givenName\": \"John\",\n\t\t\t\"surname\": \"Smith\",\n\t\t\t\"birthDate\": \"1970-01-23\",\n\t\t\t\"passengerCode\": \"ADT\"\n\t\t},\n {\n\t\t\t\"givenName\": \"All\",\n\t\t\t\"surname\": \"Smith\",\n\t\t\t\"birthDate\": \"2000-01-23\",\n\t\t\t\"passengerCode\": \"CNN\"\n\t\t}\n\t],\n\t\"contactInfo\":\n {\n \"emails\": [\n \"travel@sabre.com\",\n\t\t\"travel2@sabre.com\"\n ],\n \"phones\": [\n \"+123456\"\n ]\n },\n\t\"flightDetails\": {\n\t\t\"flights\": [\n\t\t\t{\n\t\t\t\t\"flightNumber\": 463,\n\t\t\t\t\"airlineCode\": \"EY\",\n\t\t\t\t\"fromAirportCode\": \"MEL\",\n\t\t\t\t\"toAirportCode\": \"AUH\",\n\t\t\t\t\"departureDate\": \"{{start_date}}\",\n\t\t\t\t\"departureTime\": \"16:55\",\n\t\t\t\t\"bookingClass\": \"Y\",\n\t\t\t\t\"marriageGroup\": false,\n\t\t\t\t\"flightStatusCode\": \"NN\"\n\t\t\t},\n\t\t\t{\n\t\t\t\t\"flightNumber\": 462,\n\t\t\t\t\"airlineCode\": \"EY\",\n\t\t\t\t\"fromAirportCode\": \"AUH\",\n\t\t\t\t\"toAirportCode\": \"MEL\",\n\t\t\t\t\"departureDate\": \"{{end_date}}\",\n\t\t\t\t\"departureTime\": \"09:00\",\n\t\t\t\t\"bookingClass\": \"Y\",\n\t\t\t\t\"marriageGroup\": false,\n\t\t\t\t\"flightStatusCode\": \"NN\"\n\t\t\t}\n\t\t],\n \"flightPricing\": [\n {\n \"priceComparisons\": [\n {\n \"desiredAmount\": \"5300.00\",\n \"comparisonType\": \"INCREASE_BY_AMOUNT\",\n \"amount\": \"30.00\"\n },\n {\n \"desiredAmount\": \"5300.00\",\n \"comparisonType\": \"DECREASE_BY_AMOUNT\",\n \"amount\": \"30.00\"\n }\n ]\n }\n ]\n\t},\n \"payment\": {\n \"billingAddress\": {\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}"
},
"url": {
"raw": "{{rest_endpoint}}/v1/trip/orders/createBooking",
"host": [
"{{rest_endpoint}}"
],
"path": [
"v1",
"trip",
"orders",
"createBooking"
]
},
"description": "[//]: # \"Start\"\n\n<b>[Description](https://developer.sabre.com/docs/rest_apis/trip/orders/booking_management), [Resources](https://developer.sabre.com/docs/rest_apis/trip/orders/booking_management/reference-documentation), [Help](https://developer.sabre.com/docs/rest_apis/trip/orders/booking_management/help)</b>\n\n[//]: # \"End\""
},
"response": [
]
}
