Skip to main content
Luca_Lattarini
Level 9
Aug 11, 2021 2:57 AM UTC
Solved

Personalization Block delivery issue

Hello guys, I am trying to use the personalization block mentioned below but I am facing an issue during deliverying . If I execute the preview I have no issue. Any idea?

var article = xtk.queryDef.create(<queryDef schema="xxx:ArticleCatalog" operation="select">                                            <select>                                             <node expr={"@articleName"}/>                                             <node expr={"@articleDesc"}/>                                             <node expr={"@articlePageURL"}/>                                             <node expr={"@articleURL"}/>                                            </select>                                                                                    </queryDef>).ExecuteQuery()                                                 var articleName=article[0].@articleName 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Marcel_Szimonisz
Marcel_SzimoniszAccepted solution
Community Advisor
Aug 11, 2021 7:08 AM UTC

Hello @luca_lattarini,

preview will fail every time you use anything more than variables. try to send yourself a proof and if it works it works.

 

Also mind that doing query in personalization will cause decrease in delivery processing speed. As you query database for each recipients.

 

It Would be better to append this article before delivery to the targeting dimension or even better if same article is used for more recipients inject the article array as json string to the delivery from the delivery object modification script and then use it as variable?

 

Follow this article:

https://blog.floriancourgey.com/2018/05/how-to-add-variables-from-a-workflow-in-a-delivery



How to add variables to delivery find here

2 replies

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity AdvisorAccepted solution
Community Advisor
Aug 11, 2021 7:08 AM UTC

Hello @luca_lattarini,

preview will fail every time you use anything more than variables. try to send yourself a proof and if it works it works.

 

Also mind that doing query in personalization will cause decrease in delivery processing speed. As you query database for each recipients.

 

It Would be better to append this article before delivery to the targeting dimension or even better if same article is used for more recipients inject the article array as json string to the delivery from the delivery object modification script and then use it as variable?

 

Follow this article:

https://blog.floriancourgey.com/2018/05/how-to-add-variables-from-a-workflow-in-a-delivery



How to add variables to delivery find here

Translate
Sukrity_Wadhwa
Level 4
Aug 26, 2021 9:15 AM UTC

Hi @luca_lattarini,

 

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

 

Thanks!

Translate
Sukrity Wadhwa