Email Address Data policy

Forum|Forum|1 year ago
April 29, 2024
3 replies
1091 views

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 :

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 ParthaSarathy

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);
}

CampaignerForLife

New Participant

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

D

Dhanam1Author

New Participant

the expression is "email" only.

CampaignerForLife

New Participant

Nice! So, is your problem solved already?

ParthaSarathyAccepted solution

New Participant

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);
}

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

D

Dhanam1Author

New Participant

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.