Personalization Block delivery issue | Community
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
New Participant
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

Sukrity_Wadhwa
Employee
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
Marcel_Szimonisz
Marcel_SzimoniszAccepted solution
New Participant
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