Flight segments data model
When you create a batch file, ensure that you include all required attributes from the order item data model in addition to any flight segments attributes from the following table:
Attribute |
Description |
Type |
Example(s) |
Required/optional |
Upsert |
Migration |
---|---|---|---|---|---|---|
|
An ID to identify the flight segment. |
string |
|
Required |
Not supported |
Not supported |
|
The IATA airport or city origin code of the flight segment. |
IATA airport or city code (uppercase) |
|
Required |
Not supported |
Not supported |
|
The IATA airport or city destination code of the flight segment. |
IATA airport or city code (uppercase) |
|
Required |
Not supported |
Not supported |
|
The local departure date and time of the flight segment. You must pass this value in as the local departure date/time and include the Z at the end, even though it is not UTC time. |
ISO 8601 date/time |
|
Required |
Not supported |
Not supported |
|
The local arrival date and time of the flight segment. You must pass this value in as the local departure date/time and include the Z at the end, even though it is not UTC time. |
ISO 8601 date/time |
|
Required |
Not supported |
Not supported |
|
The marketing flight number for the flight segment. |
string |
|
Required |
Not supported |
Not supported |
|
The fare class of the flight segment. |
string (title case recommended) |
|
Required |
Not supported |
Not supported |
|
The fare family of the flight segment. |
string (title case recommended) |
|
Optional |
Not supported |
Not supported |
|
The booking class of the flight segment. |
string (uppercase) |
|
Optional |
Not supported |
Not supported |
|
The equipment type of the flight segment. |
string (uppercase) |
|
Optional |
Not supported |
Not supported |
|
The marketing carrier code for the flight segment. |
IATA airline code (uppercase) |
|
Required |
Not supported |
Not supported |
|
The origin and destination of the flight segment. |
string (uppercase) |
|
Optional |
Not supported |
Not supported |
|
The operating carrier code for the flight segment. |
IATA airline code (uppercase) |
|
Optional |
Not supported |
Not supported |
|
The operating carrier flight number for the flight segment. |
string |
|
Optional |
Not supported |
Not supported |
{
"ref":"056621C2-C955-492D-B7EE-C77C6BDDFDEE",
"schema":"order",
"mode":"insert",
"value":{
"referenceId":"B94TXY",
"status":"PURCHASED",
"orderedAt":"2024-03-07T16:15:11.000Z",
"currencyCode":"EUR",
"price":100,
"paymentType":"Card",
"cardType":"Visa",
"contact":{
"title":"Mr",
"firstName":"John",
"lastName":"Doe",
"gender":"male",
"dateOfBirth":"1985-12-24T00:00Z",
"email":"[email protected]",
"phoneNumbers":[
"+353161123345",
"+353861123311"
],
"identifiers":[
{
"provider":"SITECORE_IDENTITY_SYSTEM",
"id":"B7524AE6-CF1C-440F-B1A2-0C9D42F5CB41",
"expiryDate":"2025-08-23T16:17:16.000Z"
},
{
"provider":"Sitecore Loyalty Program",
"id":"123456789t"
}
]
},
"consumers":[
{
"title":"Mr",
"firstName":"John",
"lastName":"Doe",
"identifiers":[
{
"provider":"SITECORE_IDENTITY_SYSTEM",
"id":"B7524AE6-CF1C-440F-B1A2-0C9D42F5CB41",
"expiryDate":"2025-08-23T16:17:16.000Z"
}
],
"orderItems":[
{
"referenceId":"B94TXY-1"
}
]
}
],
"orderItems":[
{
"type":"FLIGHT",
"productId":"DUB-LAS",
"orderedAt":"2024-03-07T16:15:11.000Z",
"quantity":1,
"price":100.00,
"currencyCode":"EUR",
"originalPrice":100.00,
"originalCurrencyCode":"EUR",
"referenceId":"B94TXY-1",
"status":"PURCHASED",
"consumerTypeCode":"ADT",
"flightSegments":[
{
"id":"1234",
"origin":"DUB",
"destination":"LHR",
"departureDateTime":"2024-08-15T16:00Z",
"arrivalDateTime":"2024-08-15T17:20Z",
"flightNumber":"459",
"fareClass":"Economy",
"fareFamily":"Plus",
"carrier":"FR",
"originDestination":"DUB-LHR"
},
{
"id":"1235",
"origin":"LHR",
"destination":"LAS",
"departureDateTime":"2024-08-15T20:00Z",
"arrivalDateTime":"2024-08-15T22:30Z",
"flightNumber":"460",
"fareClass":"Economy",
"fareFamily":"Plus",
"carrier":"FR",
"originDestination":"LHR-LAS"
}
]
}
]
}
}