Email Address Data policy

Forum|Forum|1 year ago
April 29, 2024
3 replies
1094 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);
}

C

costa_n11

Adobe Employee

Hi @dhanam1 ,

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

Thanks

Denis

ParthaSarathy

Accepted solution

Community Advisor

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

Level 2

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.