Email Address Data policy

[Dhanam1]

Hi ,

I'm facing an error in JavaScript activity while attempting to remove invalid email addresses from the data loading activity.

Technical workflow:

This is the code I used to identify invalid email addresses from the data loading activity:

The error is :

[costa_n11]

Hi @Dhanam1 ,

In your query dataPlocy activity, you need to add the email address as Additional data.....

Thanks

Denis

[ParthaSarathy · Accepted solution]

Hi @Dhanam1 ,

In data loading activity > click here to change the file format > See the internal name of 'email' column. 

If the internal name is 'email', then in JS modify the select node @email as email

Example,

var query = xtk.queryDef.create(
<queryDef schema="temp:fileImport" operation="select" >
<select>
<node expr="email"/>
</select>
</queryDef>
);
var record = query.ExecuteQuery();
for each (var variable in record) {
vars.emailID = variable.email;
logInfo("emailID:  "+vars.emailID);
}

[Dhanam1]

Hi @ParthaSarathy  ,
I can retrieve both valid and invalid email addresses from the Javascript activity, but I want to separate them into different transitions—one for valid (true) and one for invalid (false)—using the Test activity.

[CampaignerForLife]

Have you checked the definition of datapolicy? maybe the expression is "@email" or even "email"

[Dhanam1]

the expression is "email" only.

[CampaignerForLife]

Nice! So, is your problem solved already?