# Confirm Purchases with Triggered Sends
This page contains conceptual and scenario information about using triggered sends to confirm online purchases. You can use the information in this document as a model to create your own triggered sends using the SOAP API.
## Scenario
Northern Trail Outfitters uses an internal system to process work-related airline tickets for their employees. When the employees book their travel via the internal site, they receive an email confirmation that includes a summary of the information regarding their travel plans. To make this system work, Northern Trail Outfitters performs the following tasks:
1. Create the confirmation email.
2. Created the data extension used to store the confirmation information.
3. Create the triggered send used to send the confirmation email.
4. Create the API call.
The internal system submits the triggered send using a Java API call that includes the email address of the subscriber, the subscriber key, and confirmation information in XML format.
## Create the Confirmation Email
The email itself uses AMPscript to display information taken from the confirmation XML. This example uses the [BuildRowSetFromXML() AMPscript function](/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-content/mc-ampscript-reference-content-build-rowset-from-xml.md) to create each record row for the email message, and it formats date and currency values automatically.
```js
%%[
var @xml, @subject, @tempxml
var @passengers, @passengers_rows, @passenger_count, @passenger_rows
var @first_name, @middle_name, @last_name, @account_number, @ticket_number
var @confirmation_date, @confirmation_number
var @flights, @flights_rows, @flight_count, @flight_rows, @flight_xml, @flight_date, @flight_number
var @depart_time, @depart_airport, @arrive_time, @arrive_airport, @stops
var @trip_price, @taxes, @trip_flex, @seat_selections, @bag_fees, @total_cost
var @line_bgcolor
set @line_bgcolor = "#cbdadf"
set @xml = confirmation_xml
set @subject = Field(Row(BuildRowSetFromXML(@xml, "/confirmation/subject"), 1), 'value')
set @passengers = BuildRowSetFromXML(@xml, "/confirmation/passengers")
set @tempxml = concat("", Field(Row(@passengers, 1), "xml"), "")
set @passengers_rows = BuildRowSetFromXML(@tempxml, "//passenger")
set @passenger_count = RowCount(@passengers_rows)
set @confirmation_date = Format(Field(Row(BuildRowSetFromXML(@xml, "/confirmation/confirmation_date"), 1), 'value'), "MMMM d, yyyy")
set @confirmation_number = Field(Row(BuildRowSetFromXML(@xml, "/confirmation/confirmation_number"), 1), 'value')
set @flights = BuildRowSetFromXML(@xml, "/confirmation/flights")
set @tempxml = concat("", Field(Row(@flights, 1), "xml"), "")
set @flights_rows = BuildRowSetFromXML(@tempxml, "//flight")
set @flight_count = RowCount(@flights_rows)
set @trip_price = Format(Field(Row(BuildRowsetFromXml(@xml, "/confirmation/trip_price"), 1), "Value"), "$#,#.00;-$#,#.00")
set @taxes = Format(Field(Row(BuildRowsetFromXml(@xml, "/confirmation/taxes"), 1), "Value"), "$#,#.00;-$#,#.00")
set @trip_flex = Format(Field(Row(BuildRowsetFromXml(@xml, "/confirmation/trip_flex"), 1), "Value"), "$#,#.00;-$#,#.00")
set @seat_selections = Format(Field(Row(BuildRowsetFromXml(@xml, "/confirmation/seat_selections"), 1), "Value"), "$#,#.00;-$#,#.00")
set @bag_fees = Format(Field(Row(BuildRowsetFromXml(@xml, "/confirmation/bag_fees"), 1), "Value"), "$#,#.00;-$#,#.00")
set @total_cost = Format(Field(Row(BuildRowsetFromXml(@xml, "/confirmation/total_cost"), 1), "Value"), "$#,#.00;-$#,#.00")
]%%
```
The next section provides the header for the email message.
```html
```
The next section retrieves all passengers on the reservation using for/do loops to pull back all customer information.
```html
|
%%[ for @p = 1 to @passenger_count do set @passenger_rows = Row(@passengers_rows, @p)
set @passenger_xml = concat("", Field(@passenger_rows, "xml"), "") set
@first_name = Field(Row(BuildRowsetFromXml(@passenger_xml, "//first_name"), 1), "Value")
set @middle_name = Field(Row(BuildRowsetFromXml(@passenger_xml, "//middle_name"), 1),
"Value") set @last_name = Field(Row(BuildRowsetFromXml(@passenger_xml, "//last_name"),
1), "Value") ]%% %%=v(@last_name)=%% / %%=v(@first_name)=%% %%=v(@middle_name)=%%
%%[ next ]%%
|
Confirmation Date:
%%=v(@confirmation_date)=%% |
Confirmation Number:
%%=v(@confirmation_number)=%%
|
|
|
|
```
The next section lists all ticket numbers and frequent flyer accounts for all reservations. The code alternates background colors for each line to aid readability of the information.
```html
|
| Passenger(s) |
Account Number |
Ticket Number |
%%[ for @p = 1 to @passenger_count do set @passenger_rows = Row(@passengers_rows, @p) set
@passenger_xml = concat("", Field(@passenger_rows, "xml"), "") set @first_name = Field(Row(BuildRowsetFromXml(@passenger_xml, "//first_name"), 1),
"Value") set @middle_name = Field(Row(BuildRowsetFromXml(@passenger_xml, "//middle_name"), 1),
"Value") set @last_name = Field(Row(BuildRowsetFromXml(@passenger_xml, "//last_name"), 1),
"Value") set @account_number = Field(Row(BuildRowsetFromXml(@passenger_xml,
"//account_number"), 1), "Value") set @ticket_number =
Field(Row(BuildRowsetFromXml(@passenger_xml, "//ticket_number"), 1), "Value") if @line_bgcolor
== "#cbdadf" then Set @line_bgcolor = "#e0e9ec" else Set @line_bgcolor = "#cbdadf" endif ]%%
| %%=v(@first_name)=%% %%=v(@middle_name)=%% %%=v(@last_name)=%% |
%%=v(@account_number)=%% |
%%=v(@ticket_number)=%% |
%%[ next ]%%
|
|
|
```
The next section displays all relevant flight information, including numbers, arrival and departure times, and number of stops.
```html
| Date |
Flight |
Flight Information |
Stops |
%%[ for @p = 1 to @flight_count do set @flight_rows = Row(@flights_rows, @p) set @flight_xml =
concat("", Field(@flight_rows, "xml"), "") set @flight_date = Format(Field(Row(BuildRowsetFromXml(@flight_xml, "//flight_date"), 1),
"Value"), "ddd MMM d") set @flight_number = Field(Row(BuildRowsetFromXml(@flight_xml,
"//flight_number"), 1), "Value") set @depart_time = Field(Row(BuildRowsetFromXml(@flight_xml,
"//depart_time"), 1), "Value") set @depart_airport = Field(Row(BuildRowsetFromXml(@flight_xml,
"//depart_airport"), 1), "Value") set @arrive_time = Field(Row(BuildRowsetFromXml(@flight_xml,
"//arrive_time"), 1), "Value") set @arrive_airport = Field(Row(BuildRowsetFromXml(@flight_xml,
"//arrive_airport"), 1), "Value") set @stops = Field(Row(BuildRowsetFromXml(@flight_xml,
"//stops"), 1), "Value") if @line_bgcolor == "#cbdadf" then Set @line_bgcolor = "#e0e9ec" else
Set @line_bgcolor = "#cbdadf" endif ]%%
| %%=v(@flight_date)=%% |
%%=v(@flight_number)=%% |
Depart %%=v(@depart_airport)=%% at %%=v(@depart_time)=%%
Arrive %%=v(@arrive_airport)=%% at %%=v(@arrive_time)=%%
|
%%=v(@stops)=%% |
%%[ next ]%%
|
|
|
```
The next section of code itemizes any costs associated with the reservation.
```html
| Trip Price |
= |
%%=v(@trip_price)=%% |
| Taxes |
= |
%%=v(@taxes)=%% |
| Trip Flex |
= |
%%=v(@trip_flex)=%% |
| Seat Selections |
= |
%%=v(@seat_selections)=%% |
| Baggage Fees |
= |
%%=v(@bag_fees)=%% |
| Total Cost |
= |
%%=v(@total_cost)=%% |
|
```
The next section of code places a disclaimer in the email.
```html
|
|
All fares in US dollars
Fares shown are the lowest available and may fluctuate until purchased and confirmed. The
lowest fare available on your selected date is displayed and includes any advertised discount
available for booking online. Base prices don't include PFC, segment fees or September 11th
security fee of up to $10.70 per segment. A segment is one take-off and one landing. A
convenience fee of $10.00 per passenger, per segment applies when booked on example.com. A
convenience fee of $10.00 per passenger, per segment, plus $14.99 per segment, applies when
purchased through our call center. Purchases made at any NTO office do not incur a convenience
or call center fee. When purchased at time of booking, a checked bag fee of up to $29.99 per
bag, per segment applies for the first two(2) checked bags. If purchased at flight check-in, a
fee of $35 per checked bag, per person, per segment applies for the first two bags checked. In
all cases more higher fees applies for three or more checked bags. Fare rules, routes and
schedules are subject to change without notice. Fares are non-refundable. No credit or refund
is given for fare differences or fluctuations after reservation is purchased. Seats are
limited and subject to availability. Restrictions apply. Any credits for future travel
resulting from changes or cancelations of this reservation can be used for online/web
reservations and therefore can be applied to any web-only fares or web discounts. Any changes
to travel date may result in a higher price in addition to change fee(s). Customers with
credits may call Reservations to make their reservation and is charged the lowest available
non-web fare plus any applicable fees.
Click Here for our Baggage Policy.
|
```
The next section of code puts a footer in the email message.
```html
|
Thanks for using our travel system. Have a great flight!
|
|
 
|
| |
This is a post-only mailing from Northern Trail Outfitters. Please don't respond to this message.
Please add email@example.com to your Safe Senders list to ensure our mailers deliver to your inbox.
Visit our website for more information.
Northern Trail Outfitters
123 Example Way
Indianapolis,I
You received this message because you voluntarily provided us with your email address.
If you don't wish to receive any special deals manage your subscriptions here.
|
```
The next section of code puts a menu at the bottom of the email message.
```
