Level 4

Solved

Dynamic Product Listing in Adobe Campaign Classic Transactional Emails

Forum|Forum|2 years ago
September 1, 2023
1 reply
1016 views

Hi Team,

We have a requirement to list all product details in the email body shared in the ctx payload,

the payload is as below

<ctx>

<firstName>Shine</firstName>

<ctaLink>https://www.test.com </ctaLink>

<orderId>TESTORDERID001 </orderId>

<advanceId>ADVANCEID001 </advanceId>

</orderDetails>

<productName>product1 </productName>

<productImageUrl>https://product1.jpg</productImageUrl>

</product1>

<productName>product2 </productName>

<productImageUrl>https://product2.jpg</productImageUrl>

</product2>

</productDetails>

</ctx>

The required output in the email body is as below :

Product 1

productName :

productImage :

productPrice :

Product 2

productName :

productImage :

productPrice :

Product 3

productName :

productImage :

productPrice :

.

etc

There can be n number of products and all of the products must be displayed in the email. Trying to loop through the xml code like below :

<% var ctx = XML(rtEvent.ctx); %>

<% for(var i=1;i <= ctx.productDetails.childNodes.length;i++){%>
<%=escapeXmlStr(ctx["product"+i+".productName"])%> <%=escapeXmlStr(ctx["product"+i+".productImageUrl"])%>

<% } %>

but i am not getting any out put,

Please help me on the same, Thanks in advance.

Thanks,

Shine v.v

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by jorgeferreira

Hello Shine,

On your XML, you can't have tags as <product1>... <product2>. It needs to be always just <product>. The correct XML would be:

<ctx>
    <orderDetails>
        <firstName>Shine</firstName>
        <lastName>vv</lastName>
        <ctaLink>https://www.test.com </ctaLink>
        <pickUpDate>28 Aug 2023 </pickUpDate>
        <pickUpStore>XXYY </pickUpStore>
        <orderId>TESTORDERID001 </orderId>
        <subTotal>22001.00 </subTotal>
        <discount>5000.00 </discount>
        <tax>1200.00 </tax>
        <total>20000.00 </total>
        <advanceId>ADVANCEID001 </advanceId>
        <advanceAmountPaid>5000.00 </advanceAmountPaid>
        
    </orderDetails>
    <productDetails>
        <product>
            <productName>product1 </productName>
            <productImageUrl>https://product1.jpg</productImageUrl>
            <productPrice>18000.00 </productPrice>
        </product>
        <product>
            <productName>product2 </productName>
            <productImageUrl>https://product2.jpg</productImageUrl>
            <productPrice>18000.00 </productPrice>
        </product>
    </productDetails>
</ctx>

With that in mind, you just need to do a for each loop in the productDetails vector, like such:

<% var xml = new XML(rtEvent.ctx); %>

</br>
<% for each (var item in xml.productDetails.product) { %>

productName: <%= item.productName.toString() %>
</br>
productImageUrl: <%= item.productImageUrl.toString() %>
</br>
productPrice: <%= item.productPrice.toString() %>

</br>
</br>
<% } %>

If you need a count or prefer a for loop, the syntax would be:

<% for (var i = 0; i < xml.productDetails.product.length; i++) {%>

productName: <%= xml.productDetails.product[i].productName.toString() %>
</br>
productImageUrl: <%= xml.productDetails.product[i].productImageUrl.toString() %>
</br>
productPrice: <%= xml.productDetails.product[i].productPrice.toString() %>

</br>
</br>

<% } %>

Let me know if that works for you.

Jorge

jorgeferreiraAccepted solution

Level 3

Hello Shine,

On your XML, you can't have tags as <product1>... <product2>. It needs to be always just <product>. The correct XML would be:

<ctx>
    <orderDetails>
        <firstName>Shine</firstName>
        <lastName>vv</lastName>
        <ctaLink>https://www.test.com </ctaLink>
        <pickUpDate>28 Aug 2023 </pickUpDate>
        <pickUpStore>XXYY </pickUpStore>
        <orderId>TESTORDERID001 </orderId>
        <subTotal>22001.00 </subTotal>
        <discount>5000.00 </discount>
        <tax>1200.00 </tax>
        <total>20000.00 </total>
        <advanceId>ADVANCEID001 </advanceId>
        <advanceAmountPaid>5000.00 </advanceAmountPaid>
        
    </orderDetails>
    <productDetails>
        <product>
            <productName>product1 </productName>
            <productImageUrl>https://product1.jpg</productImageUrl>
            <productPrice>18000.00 </productPrice>
        </product>
        <product>
            <productName>product2 </productName>
            <productImageUrl>https://product2.jpg</productImageUrl>
            <productPrice>18000.00 </productPrice>
        </product>
    </productDetails>
</ctx>

With that in mind, you just need to do a for each loop in the productDetails vector, like such:

<% var xml = new XML(rtEvent.ctx); %>

</br>
<% for each (var item in xml.productDetails.product) { %>

productName: <%= item.productName.toString() %>
</br>
productImageUrl: <%= item.productImageUrl.toString() %>
</br>
productPrice: <%= item.productPrice.toString() %>

</br>
</br>
<% } %>

If you need a count or prefer a for loop, the syntax would be:

<% for (var i = 0; i < xml.productDetails.product.length; i++) {%>

productName: <%= xml.productDetails.product[i].productName.toString() %>
</br>
productImageUrl: <%= xml.productDetails.product[i].productImageUrl.toString() %>
</br>
productPrice: <%= xml.productDetails.product[i].productPrice.toString() %>

</br>
</br>

<% } %>

Let me know if that works for you.

Jorge

S

ShineV_Author

Level 4

Hi @jorgeferreira ,

Thank you so much for your help, it is working fine.

Thanks,

Shine v.v

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded