I'm trying to create an email that pulls XML from a field in a data extension but my ampscript knowledge is very limited.
The DE field that the XML is under is a text field called 'attribute' and here is the XML file:
<abandonedcart>
<orderitems>
<item>
<itemid_att>1</itemid_att>
<quantity_att>1</quantity_att>
<totalprice_att>10.99</totalprice_att>
<imageurl_att>https:\\image1.img</imageurl_att>
<type_att>template</type_att>
<size_att>12x8</size_att>
<material_att>Corro</material_att>
<ppi_att>10.99</ppi_att>
</item>
<item>
<itemid_att>2</itemid_att>
<quantity_att>2</quantity_att>
<totalprice_att>20.18</totalprice_att>
<imageurl_att>https:\\image2.img</imageurl_att>
<type_att>template</type_att>
<size_att>12x8</size_att>
<material_att>Corro</material_att>
<ppi_att>10.09</ppi_att>
</item>
</orderitems>
</abandonedcart>
I know that I need to use the BuildRowsetFromXml function but I'm getting varying suggestions from different sources and would love some advice!