Schedule an Appointment email using SOAP API

%%[
SET @EventDate = Format(Now(),"MMddyyyy")

var @xml

SET @xml = XML_Feed

SET @rowSET = BuildRowsetFromXml(@xml, "//Record",1)
SET @FamilyTotal = Rowcount(@rowset)

If not empty(@FamilyTotal) then

FOR @i = 1 TO Rowcount(@rowset) DO

SET @row = Row(@rowset,@i)
SET @HOHid = Field(@row,"HOHID_att")
SET @rAppointmentID = Field(@row,"AppointmentId_att")
SET @familyid = Field(@row,"FamilyId_att")
SET @ApptSubcriberKey = Field(@row,"PatientId_att")
SET @SubjectLine = Field(@row,"SubjectLine_att")
SET @SubjectLine = Replace(Replace(Replace(Replace(@SubjectLine,'<','<'),'>','>'),'%iexcl;','¡'),'%iquest;','¿')
SET @PreHeader = Field(@row,"Preheader_att")
SET @Header = Field(@row,"Header_att")
SET @Header = Replace(Replace(Replace(Replace(@Header,'<','<'),'>','>'),'%iexcl;','¡'),'%iquest;','¿')
SET @HeroImage = Field(@row,"HeroImage_att")
SET @MobileImage = Field(@row,"MobileImage_att")
SET @HeroLink = Field(@row,"HeroLink_att")
SET @MessageBody = Field(@row,"MessageBody_att")
SET @MessageBody = Replace(Replace(Replace(Replace(@MessageBody,'<','<'),'>','>'),'%iexcl;','¡'),'%iquest;','¿')
SET @Callout = Field(@row,"Callout_att")
SET @Callout = Replace(Replace(Replace(Replace(@Callout,'<','<'),'>','>'),'%iexcl;','¡'),'%iquest;','¿')
SET @BelowCallout = Field(@row,"BelowCallout_att")
SET @BelowCallout = Replace(Replace(Replace(Replace(@BelowCallout,'<','<'),'>','>'),'%iexcl;','¡'),'%iquest;','¿')
SET @ClinicAlert = Field(@row,"ClinicAlert_att")
SET @HeroText = Field(@row,"HeroText_att")
SET @HeroText = Replace(Replace(Replace(Replace(@HeroText,'<','<'),'>','>'),'%iexcl;','¡'),'%iquest;','¿')
SET @ButtonColor = Field(@row,"ButtonColor_att")
SET @CalloutColor = Field(@row,"CalloutColor_att")
SET @MessageGUID = Field(@row,"MessageGUID_att")

/* Default */
If @HeroImage =="" OR EMPTY(@HeroImage) THEN
SET @HeroImage = "http://image.e.example.com/lib/fe9713707565077471/m/2/lapsed-hero-touch-4.jpg"
ENDIF
IF @ButtonColor == "" OR EMPTY(@ButtonColor) THEN
SET @ButtonColor = "#00A96C"
ENDIF
IF @CalloutColor == "" OR EMPTY(@CalloutColor) THEN
SET @CalloutColor = "#00A96C"
ENDIF

IF @i == 1 THEN

SET @AppointmentTime = Field(@row,"AppointmentDateTime_att")
SET @FamilyApptTime = @AppointmentTime
SET @ApptDMY = Concat(Format(@FamilyApptTime,"dddd"), ', ', Format(@FamilyApptTime,"MMM"),' ',
Format(@FamilyApptTime,"dd"), @DateTense,' ',Format(@FamilyApptTime,"yyyy"))
SET @ApptMDY = Concat(Format(@FamilyApptTime,"MMMM"),' ',Format(@FamilyApptTime,"dd"),
@DateTense,' ',Format(@FamilyApptTime,"yyyy"))
SET @ApptInfo = Concat(Format(@FamilyApptTime,"dddd"), ', ', Format(@FamilyApptTime,"MMM"),' ',
Format(@FamilyApptTime,"dd"), @DateTense,' at ',Lowercase(Format(@FamilyApptTime,"h:mmtt")))
SET @FamilyApptDay = Format(@FamilyApptTime,"dddd")
SET @FamilyApptMonth = Format(@FamilyApptTime,"MMMM dd, yyyy")
SET @FamilyApptDate = Format(@FamilyApptTime,"dd")
SET @StartTime = Format(@FamilyApptTime,"h:mm tt")
SET @SubjectDate = Format(@FamilyApptTime,"MMM dd")
SET @ApptDisplay = Concat(@FamilyApptDay,", ",@FamilyApptMonth," ",@FamilyApptDate," at ",@StartTime,"")
SET @SubjectLineDate = Concat(Format(@FamilyApptTime,"MMMM"),' ',Replace(@FamilyApptDate,"0",""),'',@DateTense)
SET @H_PrimaryInsuranceType = Field(@row,"PayerTypeCode_att")
SET @H_InsuranceVerificationStatus = Field(@row,"InsuranceStatusCode_att")
SET @RescheduleYN = Field(@row,"RescheduleYN_att")
SET @AppointmentTypeCode = Field(@row,"AppointmentTypeCode_att")
SET @PatientFirstName = Field(@row,"FirstName_att")
SET @CellPhone = Field(@row,"CellPhone_att")
SET @MessageId = Field(@row,"MessageId_att")
SET @insuranceformslink = "https://www.example.com/campaign/medpatientforms"

SET @ApptClinicID = Field(@row,"ClinicID_att")
IF @ClinicAlert == 'lasCruces' THEN
SET @ApptClinicID = '99'
ELSEIF @ApptClinicID == "71" THEN
SET @ApptClinicID = "109"
ELSEIF @ApptClinicID == "42" THEN
SET @ApptClinicID = "99"
ELSEIF @ApptClinicID == "" OR EMPTY(@ApptClinicID) THEN
SET @ApptClinicID = "-1"
ENDIF
ENDIF

Next @i
ELSE
RaiseError("Missing subscriber information.",true)
ENDIF

SET @RescheduleURL = Concat("https://www.example.com/l/reschedule_appointment?guid=",@MessageGUID)

IF @HeroLink == "" OR EMPTY(@HeroLink) THEN
SET @HeroLink = @RescheduleURL
ENDIF

]%%
<!doctype html>
<html>
<head>
<meta charset="UTF-8">

<meta http-equiv="X-UA-Compatible" content="IE=edge">

<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title></title>
<style type="text/css">
body {
Margin: 0;
padding: 0;
min-width: 100%;
font-family: Helvetica, 'Helvetica Neue', Arial, sans-serif; -webkit-font-smoothing: antialiased;
mso-line-height-rule: exactly;
‑webkit‑text‑size‑adjust: 100%; -ms-text-size-adjust: 100%;
}
table {
border-spacing: 0;
color: #595959;
font-family: Helvetica, 'Helvetica Neue', Arial, sans-serif; mso-table-lspace: 0px;
mso-table-rspace: 0px;
}
img {
border: 0;
}
.ExternalClass * {
line-height: 100%;
}
.appleLinksWhite, .appleLinksWhite a {
color: #ffffff;
text-decoration: none;
}
.appleLinksGrey, .appleLinksGrey a {
color: #595959;
text-decoration: none;
}
span.MsoHyperlink {
mso-style-priority: 99;
color: inherit;
}
span.MsoHyperlinkFollowed {
mso-style-priority: 99;
color: inherit;
}
a {
text-decoration:none;
}
a[x-apple-data-detectors] {
color:inherit !important;
text-decoration:none !important;
font-size:inherit !important;
font-family:inherit !important;
font-weight:inherit !important;
line-height:inherit !important;
}
.wrapper {
width: 100%;
table-layout: fixed;
-webkit-text-size-adjust: 100%;
-ms-text-size-adjust: 100%;
}
.outer {
Margin: 0 auto;
width: 100%;
max-width: 600px;
}
.full-width-image img {
width: 100%;
max-width: 600px;
height: auto;
}
.inner {
padding-bottom: 10px;
padding-right: 10px;
padding-left: 10px;
padding-top: 10px;
}
@media screen and (max-width: 400px) {
.centered {
width: 100% !important;
text-align: center !important;
Margin: 0 auto !important;
}
.nopadding {
width: 100% !important;
text-align: center !important;
Margin: 0 auto !important;
padding-left: 20px !important;
padding-right: 20px !important;
}
.left-align {
text-align: left !important;
}
.mobile-hide {
display: none !important;
}
}
</style>


</head>
<body style="Margin:0; padding-top:0; padding-bottom:0; padding-right:0; padding-left:0; min-width:100%; background-color:#f5f3f0; -webkit-font-smoothing:antialiased; mso-line-height-rule:exactly; font-family:Arial, sans-serif; " >
<center class="wrapper" style="width: 100%; table-layout: fixed; -webkit-text-size-adjust: 100%; -ms-text-size-adjust: 100%;">
<table style="background-color: #f5f3f0;" width="100%" bgcolor="#f5f3f0" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table class="outer" style="border-spacing: 0; font-family: Helvetica, 'Helvetica Neue', Arial, sans-serif; color: #595959; Margin: 0 auto; width: 100%; max-width: 600px;" align="center" bgcolor="#f5f3f0" border="0" cellpadding="0" cellspacing="0">
<div style="max-width: 600px !important;">
<tr>
<td style="padding: 0;">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" align="center" bgcolor="#f5f3f0">
<table class="one-column" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" width="100%" style="border-spacing:0;max-width: 600px;">
<tr>
<td height="15" width="100%" style="font-size: 15px; line-height: 15px;"> 
</td>
</tr>
<tr>
<td align="center" valign="top"><a href="%%=RedirectTo(@HeroLink)=%%" target="_blank"><img src="%%=v(@HeroImage)=%%" width="580" title="%%=v(@HeroText)=%%" alt="%%=v(@HeroText)=%%" style="border:none;display:block;"></a></td>
</tr>
</table>
<table class="one-column" style="background-color: #ffffff;padding:20px 15px 15px 15px;" width="100%" bgcolor="#FFFFFF" border="0" cellpadding="0" cellspacing="0">
<tr>
<td style="text-align: center;">
<table style="border-spacing: 0;" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<table align="center" style="border-spacing: 0;" width="100%" border="0" cellpadding="0" cellspacing="0">
%%[IF NOT EMPTY(@Header) THEN]%%
<tr>
<td style="font-family:'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif; color: #323232;font-size: 20px; mso-line-height-rule: exactly; line-height: 20px; text-align: center; padding: 15px 30px 0 30px;font-weight:bold;"><span style="font-family:'Varela Round', 'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif !important;">%%=v(@Header)=%%</span></td>
</tr>
%%[ENDIF]%%
<tr>
<td style="font-family:'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif; color: #323232;font-size: 16px; mso-line-height-rule: exactly; line-height: 20px; text-align: center; padding: 15px 30px 5px 30px;"><span style="font-family:'Varela Round', 'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif !important;">%%=v(@MessageBody)=%%</span></td>
</tr>
</table>
</td>
</tr>
%%[IF NOT EMPTY(@Callout) THEN]%%
<tr>
<td style="text-align: center;padding: 0 20px;">
<center>
<table align="center" width="100%">
<tr>
<td>
<table align="center" border="0" cellpadding="0" cellspacing="0" style="Margin:0 auto;">
<tr>
<td align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" width="100%" style="font-size: 20px; line-height: 20px;"> 
</td>
</tr>
</table>
<table align="center" class="transparent" style="Margin: 0 auto;" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="330" height="40" align="center" style="background-color: %%=v(@ButtonColor)=%%;border-radius: 3px; -webkit-border-radius: 3px; -moz-border-radius: 3px;"><a href="%%=RedirectTo(@RescheduleURL)=%%" title="%%=v(@Callout)=%%" target="_blank" style="mso-padding-alt: 5px 10px; width: 300px; display: block; text-decoration: none; text-align: center;font-weight: bold; font-size: 17px; font-family:'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif; color: #ffffff; mso-line-height-rule: exactly; line-height: 17px; text-transform: uppercase; padding-top: 12px;padding-right: 10px; padding-bottom: 12px; padding-left: 10px;"><span style="font-family:'Varela Round', 'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif !important;">%%=v(@Callout)=%%</span></a></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="15" width="100%" style="font-size: 15px; line-height: 15px;"> 
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="15" width="100%" style="font-size: 15px; line-height: 15px;"> 
</td>
</tr>
</table>
</td>
</tr>
%%[ENDIF]%%
%%[IF NOT EMPTY(@BelowCallout) THEN]%%
<tr>
<td align="center" style="font-family:'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif; color: %%=v(@CalloutColor)=%%;font-size: 18px; mso-line-height-rule: exactly; line-height: 20px; text-align: center; padding: 0 30px 0 30px;-webkit-font-smoothing: antialiased;text-align: center;font-weight: bold;"><span style="font-family:'Varela Round', 'Trebuchet MS', Helvetica, 'Helvetica Neue', Arial, sans-serif !important;color: %%=v(@CalloutColor)=%%;text-decoration:none;">%%=v(@BelowCallout)=%%</span>
</td>
</tr>
%%[ENDIF]%%
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" width="100%" style="font-size: 20px; line-height: 20px;"> 
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table class="one-column" style="background-color: #ffffff;" width="100%" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" bgcolor="#ffffff">
<tr>
<td width="100%" align="center" valign="top" style="padding:25px 20px; color:#515151; font-family:Arial, Helvetica, sans-serif; font-size:11px; line-height: 150%;">To unsubscribe from future emails <a href="%%subscription_center_url%%" target="_blank" style="color:#515151;text-decoration:underline;">click here</a>.
<br />
<br />
<span class="appleLinksGrey">%%Member_Addr%%, %%Member_City%%, %%Member_State%%, %%Member_PostalCode%%, %%Member_Country%%
<br />
<br />
© %%=Format(Now(),"yyyy")=%%</span>. All rights reserved. <a href="https://www.example.com/privacy" target="_blank" style=" text-decoration:underline; color:#515151;">Privacy Statement</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
<custom name="opencounter" type="tracking">
</body>
</html>