Add recipient data to delivery variables | Community
Skip to main content
R
Ragsthenos
Level 2
December 20, 2023
Solved

Add recipient data to delivery variables

  • December 20, 2023
  • 4 replies
  • 1976 views

I've been trying to resolve a problem for several days but I think it's just an Adobe limitation.

 

If in doubt, here is my question:

 

Is it possible to put recipient data in the variables of a delivery?

Let me explain, I would like my variable (which I am going to call gridVersion) to take the value of one of the fields in my recipient table, but I realize that in the delivery variables I cannot access the recipient table, nor even the temporary table (which would be ideal) as the values of my variable are "0","1" or "2", I thought of a ternary function but here too the conditions are made on the recipients table.

 

Thanks to anyone who can help me, I don't know if I was clear.

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 isahore

Hi @isahore 

 

Thank you for your answer, indeed in this way I could use the syntax <%= targetData.gridVersion %> in the HTML to display the value in the email, but in my case I am not trying to display it in the email, I just want to have a diffusion variable (named offerCode) and that the value of this variable can be different depending on certain criteria

 

 

 

 


Hi @ragsthenos,

What you are asking here cannot be done as this variable can have different values for different recipients, so it cannot be set on the delivery level.

If you want this value to be on the delivery, then you better split your workflow into three deliveries based on the offerCode above and then populate this variable. This way it would be static for each delivery.

You can do this by using a split activity, and then instantiate a variable in the advanced tab of the split activity or the delivery activity itself, like this:

delivery.variables._var[0].stringValue = 'hardcoded_offerCode_value1';

 

Regards,

Ishan

4 replies

V
vt0509
Level 3
December 21, 2023

Hi @ragsthenos ,

I think your query has been resolved in below discussion!
https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-display-a-workflow-variable-value-in-email-delivery/td-p/256527

 

Regards
Vishal

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
December 21, 2023

Hello @ragsthenos 

 

There is one delivery but possible options are 3. How do you want this to work?

 

If there are 3 recipients with 3 different values. Which value do you want to set in delivery variables?

 

Note: The delivery variable value will be static for all recipients.

Manoj     Find me on LinkedIn
R
RagsthenosAuthor
Level 2
December 22, 2023

Thank you for your response,

 

in fact I explained the problem poorly because I had to get home quickly. To explain better, in my workflow I have a JavaScript code in which I add a field to the temporary table.

 

sqlExec("UPDATE " + vars.tableName + " SET sGriddVersion="+ gridVersion +" where sMongoId= '" + mongoId + "'")

 

For each lead the value can differ between "0", "1" and "2" and I would like my broadcast variable to be able to take the value of the lead.

 

But I think there is a limitation of the tool

isahore
Community Advisor
isahoreCommunity Advisor
Community Advisor
January 4, 2024

Hi @ragsthenos,

Adding data to the temporary work table can be done via the OOTB workflow activities as well. You can add an attribute in the temp table via the enrichment activity like this:

Iif(targetData.mongoId = 'xxx', val1, Iif(targetData.mongoId = 'yyy', val2, Iif(targetData.mongoId = 'zzz', val3, 'defaultVal')))

Then the data is available in the delivery for personalization as a targetData attribute. If you use SQL to update the temp table, then it should be available for personalization too, but might not be visible like that on the console. You can manually type the attribute like this:

<%= targetData.gridVersion %>

 

Regards,

Ishan

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity Advisor
Community Advisor
December 21, 2023

Hello @ragsthenos,

you can access recipient variables also variables that create down the line in your workflow and if not happy you can insert adobe list records or pass own variables into delivery directly

In any template you can see recipient data.

If you plug the template to any workflow you will be able to see also variables you created within workflow

 

 

Marcel

 

 

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    January 2, 2024

    Hi @ragsthenos,

    Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
    Thanks!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...