Passing personalized fields to javascript API functio...

[Ramaswami]

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.?

[Ramaswami]

hi @sukrity @milan @isahore @Dareen @DavidKangni @anupk2111

Any suggestions here. 

[Jonathon_wodnicki]

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]

@Jonathon_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 : 

my javascript which i kept after a query activity : 

i want to pipe in the delivery there : 

[Ramaswami]

Hi @Dareen @Jonathon_wodnicki any update here