{"id":31428,"date":"2018-04-21T15:47:46","date_gmt":"2018-04-21T15:47:46","guid":{"rendered":"https:\/\/ampscript.guide\/transformxml\/"},"modified":"2023-06-22T13:09:04","modified_gmt":"2023-06-22T13:09:04","slug":"transformxml","status":"publish","type":"post","link":"https:\/\/ampscript.guide\/transformxml\/","title":{"rendered":"TransformXML"},"content":{"rendered":"

TransformXML<\/h2>\n

This function applies an XSL transformation to the specified XML data.<\/p>\n

Arguments<\/h3>\n

TransformXML(1,2)<\/code><\/p>\n\n\n\n\n\n\n
Ordinal<\/th>\nType<\/th>\nRequired<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nString<\/td>\nTrue<\/td>\nXML content to transform<\/td>\n<\/tr>\n
2<\/td>\nString<\/td>\nTrue<\/td>\nXSL document used to transform the XML content<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

NOTE: This function supports the XPATH 1.0 specification<\/a>.<\/p>\n

TIP: Generally speaking, XSL transformations are powerful and flexible when it comes to transforming XML, especially if you leverage AMPscript within them. However, it’s advisable to limit the use of these in Marketing Cloud. The emails that use them can be particularly hard to maintain as the HTML code is not readily changeable in the Classic Content and Content Builder editors. It is recommended that the development of XSL emails should be done outside of Marketing Cloud using an appropriate IDE.<\/p>\n

NOTE: The TransformXML function as illustrated in Example 1 below was designed to work with XSL templates that are uploaded as Portfolio items in Classic Content. Referencing XSL templates as Content Blocks will result in an error<\/a> in the current release of Marketing Cloud. See Example 2 for a work-around for using this function with Content Builder assets.<\/p>\n<\/blockquote>\n

Example 1<\/h3>\n

Below is a sample XSL file named LoyaltyRewards.xsl<\/code> that has been uploaded to the Portfolio. It has a Customer\/External Key of LoyaltyRewards<\/code>. This XSL file retrieves the elements from the XML, and outputs the repeating reward line items in a different order. It also totals all of the reward amounts and displays them in the last row of the table.<\/p>\n

<?xml version=\"1.0\"?>\n<xsl:stylesheet xmlns:xsl=\"http:\/\/www.w3.org\/1999\/XSL\/Transform\" version=\"1.0\">\n    <xsl:output method=\"html\" indent=\"yes\"\/>\n    <xsl:template match=\"\/loyaltyRewards\">\n    <p>Hi, %%=properCase('<xsl:value-of select=\"firstName\"\/>')=%%!<\/p>\n    <p>Here's your reward statement:<\/p>\n    <table cellspacing=\"0\" cellpadding=\"5\" border=\"1\">\n        <tr>\n            <th>Reward Date<\/th>\n            <th>Name<\/th>\n            <th>Description<\/th>\n            <th>Amount<\/th>\n        <\/tr>\n        <xsl:for-each select=\"rewards\/reward\">\n            <xsl:sort select=\".\/rewardDate\" order=\"descending\" data-type=\"text\"\/>\n            <tr>\n                <td><xsl:value-of select=\"rewardDate\"\/><\/td>\n                <td><xsl:value-of select=\"name\"\/><\/td>\n                <td><xsl:value-of select=\"description\"\/><\/td>\n                <td align=\"right\"><xsl:value-of select=\"amount\"\/><\/td>\n            <\/tr>\n        <\/xsl:for-each>\n        <tr>\n            <td colspan=\"3\" align=\"right\"><b>Total<\/b><\/td>\n            <td align=\"right\"><b><xsl:value-of select=\"format-number(sum(rewards\/reward\/amount), '0.00')\"\/><\/b><\/td>\n        <\/tr>\n    <\/table>\n  <\/xsl:template>\n<\/xsl:stylesheet><\/code><\/pre>\n
The TransformXML function will apply the logic in the XSL to the XML payload specified.  The TreatAsContent<\/a> function causes the AMPscript to be evaluated in the result.<\/p>\n
%%[\n\nvar @xml, @xsl\nset @xsl = GetPortfolioItem(\"LoyaltyRewards\")\n\nset @xml = AttributeValue(\"XML\") \/* value from attribute or DE column in send context *\/\nset @xml = \"\" \/* or a literal value *\/\nset @xml = concat(@xml,'<?xml version=\"1.0\"?>')\nset @xml = concat(@xml,'<loyaltyRewards>')\nset @xml = concat(@xml,'    <emailAddress><![CDATA[suzy@limedash.com]]><\/emailAddress>')\nset @xml = concat(@xml,'    <firstName><![CDATA[Suzy]]><\/firstName>')\nset @xml = concat(@xml,'    <rewards>')\nset @xml = concat(@xml,'        <reward>')\nset @xml = concat(@xml,'            <rewardDate><![CDATA[2017-10-15]]><\/rewardDate>')\nset @xml = concat(@xml,'            <name><![CDATA[Purchase]]><\/name>')\nset @xml = concat(@xml,'            <description><![CDATA[Purchase cash back]]><\/description>')\nset @xml = concat(@xml,'            <amount><![CDATA[3.21]]><\/amount>')\nset @xml = concat(@xml,'        <\/reward>')\nset @xml = concat(@xml,'        <reward>')\nset @xml = concat(@xml,'            <rewardDate><![CDATA[2017-10-01]]><\/rewardDate>')\nset @xml = concat(@xml,'            <name><![CDATA[Visit]]><\/name>')\nset @xml = concat(@xml,'            <description><![CDATA[October visit reward]]><\/description>')\nset @xml = concat(@xml,'            <amount><![CDATA[12.34]]><\/amount>')\nset @xml = concat(@xml,'        <\/reward>')\nset @xml = concat(@xml,'        <reward>')\nset @xml = concat(@xml,'            <rewardDate><![CDATA[2017-12-01]]><\/rewardDate>')\nset @xml = concat(@xml,'            <name><![CDATA[Referral]]><\/name>')\nset @xml = concat(@xml,'            <description><![CDATA[Referral bonus]]><\/description>')\nset @xml = concat(@xml,'            <amount><![CDATA[43.21]]><\/amount>')\nset @xml = concat(@xml,'        <\/reward>')\nset @xml = concat(@xml,'    <\/rewards>')\nset @xml = concat(@xml,'<\/loyaltyRewards>')\n\n]%%\n%%=TreatAsContent(TransformXML(@xml,@xsl))=%%\n<\/code><\/pre>\n
Output<\/h4>\n
<p>Hi, Suzy!<\/p>\n<p>Here's your reward statement:<\/p>\n<table cellspacing=\"0\" cellpadding=\"5\" border=\"1\">\n  <tr>\n    <th>Reward Date<\/th>\n    <th>Name<\/th>\n    <th>Description<\/th>\n    <th>Amount<\/th>\n  <\/tr>\n  <tr>\n    <td>2017-12-01<\/td>\n    <td>Referral<\/td>\n    <td>Referral bonus<\/td>\n    <td align=\"right\">43.21<\/td>\n  <\/tr>\n  <tr>\n    <td>2017-10-15<\/td>\n    <td>Purchase<\/td>\n    <td>Purchase cash back<\/td>\n    <td align=\"right\">3.21<\/td>\n  <\/tr>\n  <tr>\n    <td>2017-10-01<\/td>\n    <td>Visit<\/td>\n    <td>October visit reward<\/td>\n    <td align=\"right\">12.34<\/td>\n  <\/tr>\n  <tr>\n    <td colspan=\"3\" align=\"right\"><b>Total<\/b><\/td>\n    <td align=\"right\"><b>58.76<\/b><\/td>\n  <\/tr>\n<\/table><\/code><\/pre>\n
Example 2<\/h3>\n
Here is a method for leveraging XSL and XML content using Content Builder.  While it may not be reasonable in a workflow to Base64 encode<\/a> XSL and XML assets, it does enable the use Content Builder as a source for this function.<\/p>\n
\n\n\n\t\n\t
\n\n\t\t\n\t\t