SFMC AMPScript Flexible Content Areas with XML Interfaces 1

sfmc-ampscript-flexible-content-areas-with-xml1.amp

%%[

set @products = LookupOrderedRows("ProductDE",6, "AvgCustomerRating desc" ,"ApprovedForEmail","true")
set @productCount = rowcount(@products)

set @productXML = "<products>"

for @i = 1 to @productCount do

    set @product = Row(@products, @i)

    set @productImageURL = Field(@product, "ProductImageURL")

    set @productXML = concat(@productXML,"<product>")
    set @productXML = concat(@productXML,"<productImageURL><![CDATA[",@productImageURL,"]]></productImageURL>")
    set @productXML = concat(@productXML,"</product>")

next @i

set @productXML = concat(@productXML,"</products>")

]%%