EMAIL DETAILS CAPTURED TO DE

/* Email Details (i.e. Email Name, Created Date, Modified date and Email ID etc…) captured to Data Extension by using SSJS.*/

Platform.Load(“core”,”1″);
try
{
var EmailDE;
var EmailData;
var EDetails = Folder.Retrieve({Property:”ContentType”,SimpleOperator:”equals”,Value:”email”});
for(var i=0; EDetails.length>i; i++)
{
var Ename = Email.Retrieve({Property:”CategoryID”,SimpleOperator:”equals”,Value:EDetails[i].ID});
for(var j=0; Ename.length>j; j++)
{
EmailDE = DataExtension.Init(“EmailDE”);
EmailData = EmailDE.Rows.Lookup([“EmailID”], [Ename[j].ID]);

if(EmailData.length>0)
{
EmailDE.Rows.Update({EmailName:Ename[j].Name,CreatedDate:Ename[j].CreatedDate},[“EmailID”]:[Ename[j].ID]);
}
else
{
EmailDE.Rows.Add({EmailName:Ename[j].Name,EmailID:Ename[j].ID,CreatedDate:Ename[j].CreatedDate});
}

}

}

//Write(“Email Data Updated/Added”)
}
catch(e)
{
Write(e.message);
}

Leave a comment

Create a free website or blog at WordPress.com.

Up ↑