Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Passing personalized fields to javascript API function call

Ramaswami
Level 4
Level 4

Hi Guys, 

 

I have email template with the feilds in recipient table like <%= recipient.firstname%>, <%=targetData.anneversary%> 

 

Currently I am passing email field to SubmitNotification API call like below : 

 

Note: When i pass @ID instead of @email  my recipient.firstname piped correctly. But the question is how can i get a personalized feild that is "anneversary" which i calculated in additional data of query activity into email template through API. Do we have any tags for this like <targetData> etc..,, 

 

var emailCondition = "@email = 'XXX-email from tempTable of query activity-XXX'";


var deliveryId = nms.delivery.SubmitDelivery("Email_Template_Name",
<delivery>
<targets >
<deliveryTarget >
<targetPart exclusion='false' ignoreDeleteStatus='false'>
<where>
<condition expr={emailCondition} />
</where>
</targetPart>
</deliveryTarget>
</targets>
</delivery>);

 

now how to i pass the variables firstname, anneversary to this function call so that my delivery will be populated with firstname and anneversary values.?

4 Replies
wodnicki
Community Advisor
Community Advisor

Hi,

 

The SubmitNotification() method documentation explains it:

"""

It is possible to explicity[sic] define the target (in reality the content of the file used as the target):

<delivery>
  <targets fromExternalSource='true'>
    <externalSource>MsgId|ClientId|Title|Name|FirstName|Mobile|Email|Market_segment|Product_propensity1|Product_propensity2|Product_propensity3|Product_propensity4|Support_Number|Amount|Threshold1|
                    000001234|M.|Martin|Peter|0650201020|pmartin@neolane.com|1|A1|A2|A3|A4|E12|120000|100000
    </externalSource>
  </targets>
</delivery>

 

Thanks,

-Jon

Ramaswami
Level 4
Level 4

@wodnicki,

 

I am not using the contents of external file here. All i need to do is to send the below circled variable which is just a calcualted feild in additional data to API so that it can pipe in email template : 

 

Ramaswami_0-1605879624488.png

 

 

Ramaswami_2-1605879675723.png

 

my javascript which i kept after a query activity : 

 

Ramaswami_3-1605879726303.png

 

i want to pipe in the delivery there : 

 

Ramaswami_4-1605879806745.png