// ------------------------------------------------------------
// Name: SetBouncesToUnsubscribed
// Abstract: Retrieve new customers
// ------------------------------------------------------------
public static void SetBouncesToUnsubscribed()
{
try
{
ET_Subscriber GetSubscriber = new ET_Subscriber();
GetSubscriber.AuthStub = m_etcTDClient;
GetSubscriber.Props = new string[] { "SubscriberKey", "EmailAddress", "Status" };
//GetSubscriber.SearchFilter = new SimpleFilterPart() { Property = "EmailAddress", SimpleOperator = SimpleOperators.equals, Value = new string[] { "*****@*****.**" } };
GetSubscriber.Attributes = new FuelSDK.ET_ProfileAttribute[] { new ET_ProfileAttribute() { Name = "Bounce Count", Value = "3" } };
GetReturn GetResponse = GetSubscriber.Get();
Console.WriteLine("Get Status: " + GetResponse.Status.ToString());
Console.WriteLine("Message: " + GetResponse.Message.ToString());
Console.WriteLine("Code: " + GetResponse.Code.ToString());
Console.WriteLine("Results Length: " + GetResponse.Results.Length);
foreach (ET_Subscriber sub in GetResponse.Results)
{
Console.WriteLine("--EmailAddress: " + sub.EmailAddress + " Status: " + sub.Status.ToString());
}
}
catch (Exception excError)
{
Console.WriteLine("Error: " + excError.ToString());
}
}
static void TestET_Subscriber()
{
ET_Client myclient = new ET_Client();
Console.WriteLine("--- Testing Subscriber ---");
string SubscriberTestEmail = "*****@*****.**";
Console.WriteLine("\n Create Subscriber");
ET_Subscriber postSub = new ET_Subscriber();
postSub.AuthStub = myclient;
postSub.EmailAddress = SubscriberTestEmail;
postSub.Attributes = new FuelSDK.ET_ProfileAttribute[] {new ET_ProfileAttribute(){ Name= "First Name", Value = "ExactTarget Example"} };
PostReturn postResponse = postSub.Post();
Console.WriteLine("Post Status: " + postResponse.Status.ToString());
Console.WriteLine("Message: " + postResponse.Message.ToString());
Console.WriteLine("Code: " + postResponse.Code.ToString());
Console.WriteLine("Results Length: " + postResponse.Results.Length);
if (postResponse.Results.Length > 0)
{
Console.WriteLine("--NewID: " + postResponse.Results[0].NewID.ToString());
foreach (ET_ProfileAttribute attr in ((ET_Subscriber)postResponse.Results[0].Object).Attributes)
{
Console.WriteLine("Name: " + attr.Name + ", Value: " + attr.Value);
}
}
Console.WriteLine("\n Retrieve newly created Subscriber");
ET_Subscriber getSub = new ET_Subscriber();
getSub.AuthStub = myclient;
getSub.Props = new string[] { "SubscriberKey", "EmailAddress", "Status" };
getSub.SearchFilter = new SimpleFilterPart() { Property = "SubscriberKey", SimpleOperator = SimpleOperators.equals, Value = new string[] { SubscriberTestEmail } };
GetReturn getResponse = getSub.Get();
Console.WriteLine("Get Status: " + getResponse.Status.ToString());
Console.WriteLine("Message: " + getResponse.Message.ToString());
Console.WriteLine("Code: " + getResponse.Code.ToString());
Console.WriteLine("Results Length: " + getResponse.Results.Length);
foreach (ET_Subscriber sub in getResponse.Results) {
Console.WriteLine("--EmailAddress: " + sub.EmailAddress + " Status: " + sub.Status.ToString());
}
Console.WriteLine("\n Update Subscriber");
ET_Subscriber patchSub = new ET_Subscriber();
patchSub.AuthStub = myclient;
patchSub.EmailAddress = SubscriberTestEmail;
patchSub.Status = SubscriberStatus.Unsubscribed;
patchSub.Attributes = new FuelSDK.ET_ProfileAttribute[] { new ET_ProfileAttribute() { Name = "First Name", Value = "ExactTarget Example" } };
PatchReturn pathResponse = patchSub.Patch();
Console.WriteLine("Patch Status: " + pathResponse.Status.ToString());
Console.WriteLine("Message: " + pathResponse.Message.ToString());
Console.WriteLine("Code: " + pathResponse.Code.ToString());
Console.WriteLine("Results Length: " + pathResponse.Results.Length);
foreach (ResultDetail rd in pathResponse.Results){
ET_Subscriber sub = (ET_Subscriber)rd.Object;
Console.WriteLine("--EmailAddress: " + sub.EmailAddress + " Status: " + sub.Status.ToString());
}
Console.WriteLine("\n Retrieve Subscriber that should have status unsubscribed now");
getResponse = getSub.Get();
Console.WriteLine("Get Status: " + getResponse.Status.ToString());
Console.WriteLine("Message: " + getResponse.Message.ToString());
Console.WriteLine("Code: " + getResponse.Code.ToString());
Console.WriteLine("Results Length: " + getResponse.Results.Length);
foreach (ET_Subscriber sub in getResponse.Results)
{
Console.WriteLine("--EmailAddress: " + sub.EmailAddress + " Status: " + sub.Status.ToString());
}
Console.WriteLine("\n Delete Subscriber");
ET_Subscriber deleteSub = new ET_Subscriber();
deleteSub.AuthStub = myclient;
deleteSub.EmailAddress = SubscriberTestEmail;
DeleteReturn deleteResponse = deleteSub.Delete();
Console.WriteLine("Delete Status: " + deleteResponse.Status.ToString());
Console.WriteLine("Message: " + deleteResponse.Message.ToString());
Console.WriteLine("Code: " + deleteResponse.Code.ToString());
Console.WriteLine("Results Length: " + deleteResponse.Results.Length);
Console.WriteLine("\n Retrieve Subscriber to confirm deletion");
getResponse = getSub.Get();
Console.WriteLine("Get Status: " + getResponse.Status.ToString());
Console.WriteLine("Message: " + getResponse.Message.ToString());
Console.WriteLine("Code: " + getResponse.Code.ToString());
Console.WriteLine("Results Length: " + getResponse.Results.Length);
foreach (ET_Subscriber sub in getResponse.Results)
{
Console.WriteLine("--EmailAddress: " + sub.EmailAddress + " Status: " + sub.Status.ToString());
}
}
// ------------------------------------------------------------
// Name: UpdateConvertedProspects
// Abstract: Retrieve subscribers from a list
// ------------------------------------------------------------
public static void SetVerifiedEmailStatus()
{
Dictionary<string, string> dctAllSubscribers = new Dictionary<string, string>();
Dictionary<string, string> dctDataExtensionSubscribers = new Dictionary<string, string>();
Dictionary<string, string> dctNewsletterListSubscribers = new Dictionary<string, string>();
Dictionary<string, string> dctDENewsletterSubscribers = new Dictionary<string, string>();
Dictionary<string, string> dctRemindersListSubscribers = new Dictionary<string, string>();
Dictionary<string, string> dctDERemindersSubscribers = new Dictionary<string, string>();
List<string> alstrValidSubscriberKeys = new List<string>();
try
{
string strSubscriberKey = "";
string strEmail = "";
string strCustomerNumber = "";
string strStatus = "";
string strDEStatus = "";
int intUpdateRecordCount = 0;
// Data
DateTime dtmCreatedDate = DateTime.Now;
// Get subscriber dates
ET_Subscriber getSub = new ET_Subscriber();
getSub.AuthStub = m_etcTDClientShared;
getSub.Props = new string[] { "SubscriberKey", "EmailAddress", "Status", "CreatedDate" };
GetReturn getResponse = getSub.Get();
Console.WriteLine("Get Status: " + getResponse.Status.ToString());
Console.WriteLine("Message: " + getResponse.Message.ToString());
Console.WriteLine("Code: " + getResponse.Code.ToString());
Console.WriteLine("Results Length: " + getResponse.Results.Length);
int intResults = getResponse.Results.Length;
// Get all subscriber keys associated with active subscribers
while (getResponse.MoreResults == true || intResults > 0)
{
foreach (ET_Subscriber sub in getResponse.Results)
{
strStatus = sub.Status.ToString();
dctAllSubscribers.Add(sub.SubscriberKey, strStatus);
Console.WriteLine("Added EmailAddress: " + sub.EmailAddress + " Status: " + strStatus);
}
getResponse = getSub.GetMoreResults();
intResults = getResponse.Results.Length;
}
// Get all customers and their 'VerifiedEmail' field from CustomerBaseDatabase
Console.WriteLine("\n Retrieve All Rows from DataExtension");
ET_DataExtensionRow deRowGet = new ET_DataExtensionRow();
deRowGet.AuthStub = m_etcTDClientShared;
deRowGet.DataExtensionName = "CustomerDatabase";
deRowGet.Props = new string[] { "SubscriberKey", "VerifiedEmail" };
GetReturn grRow = deRowGet.Get();
Console.WriteLine("Get Status: " + grRow.Status.ToString());
Console.WriteLine("Message: " + grRow.Message.ToString());
Console.WriteLine("Code: " + grRow.Code.ToString());
Console.WriteLine("Results Length: " + grRow.Results.Length);
intResults = grRow.Results.Length;
string x;
while (grRow.MoreResults == true || intResults > 0)
{
foreach (ET_DataExtensionRow column in grRow.Results)
{
strSubscriberKey = column.ColumnValues["SubscriberKey"];
strStatus = column.ColumnValues["VerifiedEmail"];
if (dctAllSubscribers.TryGetValue(strSubscriberKey, out x) == true)
{
dctDataExtensionSubscribers.Add(strSubscriberKey, strStatus);
Console.WriteLine("Added customer: " + strSubscriberKey);
}
}
grRow = deRowGet.GetMoreResults();
intResults = grRow.Results.Length;
}
// Update statuses
ET_DataExtensionRow deRowPatch = null;
foreach (KeyValuePair<string, string> entry in dctDataExtensionSubscribers)
{
strSubscriberKey = entry.Key;
strDEStatus = entry.Value;
// if our status = active, set to true
strStatus = dctAllSubscribers[strSubscriberKey];
if (strStatus.Equals("Active") == true)
{
strStatus = "True";
}
else
{
strStatus = "False";
}
// Is the status of our subscriber the same on the All Subscribers list as it is on the Data Extension?
if (strDEStatus.Equals(strStatus) == false)
{
intUpdateRecordCount += 1;
// No, update the verified email field
deRowPatch = new ET_DataExtensionRow();
deRowPatch.AuthStub = m_etcTDClientShared;
deRowPatch.DataExtensionCustomerKey = "CustomerDBKey";
deRowPatch.ColumnValues.Add("SubscriberKey", strSubscriberKey);
deRowPatch.ColumnValues.Add("VerifiedEmail", strStatus);
PatchReturn patchRowResponse = deRowPatch.Patch();
Console.WriteLine("Post Status: " + patchRowResponse.Status.ToString());
Console.WriteLine("Count: " + intUpdateRecordCount.ToString());
}
}
Console.WriteLine("Done editing email statuses!");
}
catch (Exception excError)
{
// Display Error
Console.WriteLine("Error: " + excError.ToString());
}
}
// ------------------------------------------------------------
// Name: UpdateConvertedProspects
// Abstract: Retrieve subscribers from a list
// ------------------------------------------------------------
public static Dictionary<string, string> GetDuplicateSubscribers()
{
Dictionary<string, string> dctDuplicateSubscribers = new Dictionary<string, string>();
Dictionary<string, string> dctSubscribers = new Dictionary<string, string>();
Dictionary<string, string> dctAllSubscribers = new Dictionary<string, string>();
try
{
string strCustomerNumber = "";
string strSubscriberKey = "";
string strEmail = "";
// Get subscriber dates
ET_Subscriber getSub = new ET_Subscriber();
getSub.AuthStub = m_etcTDClient;
getSub.Props = new string[] { "SubscriberKey", "EmailAddress" };
GetReturn getResponse = getSub.Get();
Console.WriteLine("Get Status: " + getResponse.Status.ToString());
Console.WriteLine("Message: " + getResponse.Message.ToString());
Console.WriteLine("Code: " + getResponse.Code.ToString());
Console.WriteLine("Results Length: " + getResponse.Results.Length);
while (getResponse.MoreResults == true)
{
foreach (ET_Subscriber sub in getResponse.Results)
{
Console.WriteLine("SubscriberKey: " + sub.SubscriberKey);
// Add to our list
dctAllSubscribers.Add(sub.SubscriberKey, sub.EmailAddress);
}
getResponse = getSub.GetMoreResults();
}
foreach (KeyValuePair<string, string> entry in dctAllSubscribers)
{
strSubscriberKey = entry.Key;
strEmail = entry.Value;
// Add to duplicates if email already exists
if (dctSubscribers.ContainsValue(strEmail) == true)
{
// Get customer number from duplicate if duplicate hasn't been logged
if (dctDuplicateSubscribers.ContainsValue(strEmail) == false)
{
strCustomerNumber = dctSubscribers.FirstOrDefault(x => x.Value == strEmail).Key;
// Add (both) duplicate entries
dctDuplicateSubscribers.Add(strSubscriberKey, strEmail);
dctDuplicateSubscribers.Add(strCustomerNumber, strEmail);
}
else
{
dctDuplicateSubscribers.Add(strSubscriberKey, strEmail);
}
}
else
{
// Add to our list
dctSubscribers.Add(strSubscriberKey, strEmail);
}
}
}
catch (Exception excError)
{
// Display Error
Console.WriteLine("Error: " + excError.ToString());
}
return dctDuplicateSubscribers;
}
// ------------------------------------------------------------
// Name: UpdateConvertedProspects
// Abstract: Retrieve subscribers from a list
// ------------------------------------------------------------
public static Dictionary<string, string> UpdateConvertedProspects(Dictionary<string, string> dctSubscriberList, Dictionary<string, string> dctSubscriberKeys,
List<string> alstrConvertedKey, List<string> alstrConvertedEmail, List<string> alstrConvertedSubscriberKey)
{
Dictionary<string, string> dctSubscribers = new Dictionary<string, string>();
try
{
string strSubscriberKey = "";
string strEmail = "";
string strCustomerNumber = "";
// Loop through each converted prospect
foreach (KeyValuePair<string, string> entry in dctSubscriberList)
{
// Data
DateTime dtmCreatedDate = DateTime.Now;
// Get customer number and email
strCustomerNumber = entry.Key;
strEmail = entry.Value;
// Get subscriber key based on that email
strSubscriberKey = dctSubscriberKeys[strEmail];
// Get subscriber dates
ET_Subscriber getSub = new ET_Subscriber();
getSub.AuthStub = m_etcTDClient;
getSub.Props = new string[] { "SubscriberKey", "EmailAddress", "Status", "CreatedDate" };
getSub.SearchFilter = new SimpleFilterPart() { Property = "SubscriberKey", SimpleOperator = SimpleOperators.equals, Value = new string[] { strSubscriberKey } };
GetReturn getResponse = getSub.Get();
Console.WriteLine("Get Status: " + getResponse.Status.ToString());
Console.WriteLine("Message: " + getResponse.Message.ToString());
Console.WriteLine("Code: " + getResponse.Code.ToString());
Console.WriteLine("Results Length: " + getResponse.Results.Length);
foreach (ET_Subscriber sub in getResponse.Results)
{
Console.WriteLine("--EmailAddress: " + sub.EmailAddress + " Status: " + sub.Status.ToString());
dtmCreatedDate = sub.CreatedDate;
}
// Create subscriber with same information but correct SubscriberKey
Console.WriteLine("\n Create Subscriber");
ET_Subscriber postSub = new ET_Subscriber();
postSub.AuthStub = m_etcTDClient;
postSub.EmailAddress = strEmail;
postSub.SubscriberKey = strCustomerNumber;
postSub.CreatedDate = dtmCreatedDate;
PostReturn postResponse = postSub.Post();
Console.WriteLine("Post Status: " + postResponse.Status.ToString());
Console.WriteLine("Message: " + postResponse.Message.ToString());
Console.WriteLine("Code: " + postResponse.Code.ToString());
Console.WriteLine("Results Length: " + postResponse.Results.Length);
// Add Subscriber to Newsletter and Reminders List
// Newsletter ListID: 2726; Reminders ListID: 2727
FuelReturn hrAddSub = m_etcTDClient.AddSubscribersToList(strEmail, strCustomerNumber, new List<int>() { 2726 });
Console.WriteLine("Helper Status: " + hrAddSub.Status.ToString());
Console.WriteLine("Message: " + hrAddSub.Message.ToString());
Console.WriteLine("Code: " + hrAddSub.Code.ToString());
hrAddSub = m_etcTDClient.AddSubscribersToList(strEmail, strCustomerNumber, new List<int>() { 2727 });
Console.WriteLine("Helper Status: " + hrAddSub.Status.ToString());
Console.WriteLine("Message: " + hrAddSub.Message.ToString());
Console.WriteLine("Code: " + hrAddSub.Code.ToString());
// Delete old subscriber
ET_Subscriber deleteSub = new ET_Subscriber();
deleteSub.AuthStub = m_etcTDClient;
deleteSub.EmailAddress = strEmail;
deleteSub.SubscriberKey = strSubscriberKey;
DeleteReturn deleteResponse = deleteSub.Delete();
Console.WriteLine("Delete Status: " + deleteResponse.Status.ToString());
Console.WriteLine("Message: " + deleteResponse.Message.ToString());
Console.WriteLine("Code: " + deleteResponse.Code.ToString());
Console.WriteLine("Results Length: " + deleteResponse.Results.Length);
// Add to array list
alstrConvertedKey.Add(strCustomerNumber);
alstrConvertedEmail.Add(strEmail);
alstrConvertedSubscriberKey.Add(strSubscriberKey);
}
}
catch (Exception excError)
{
// Display Error
Console.WriteLine("Error: " + excError.ToString());
}
return dctSubscribers;
}
// ------------------------------------------------------------
// Name: RetrieveSubscribersFromList
// Abstract: Retrieve subscribers from a list
// ------------------------------------------------------------
public static Dictionary<string, string> RetrieveSubscribersFromList()
{
Dictionary<string, string> dctSubscribers = new Dictionary<string, string>();
try
{
int intIndex = 0;
string strSubscriberKey = "";
Console.WriteLine("\n Retrieve all Subscribers on the List");
ET_List_Subscriber getListSub = new ET_List_Subscriber();
getListSub.AuthStub = m_etcTDClient;
getListSub.Props = new string[] { "ObjectID", "SubscriberKey", "CreatedDate", "Client.ID", "Client.PartnerClientKey", "ListID", "Status" };
getListSub.SearchFilter = new SimpleFilterPart() { Property = "ListID", SimpleOperator = SimpleOperators.equals, Value = new string[] { "3075" } };
GetReturn getResponse = getListSub.Get();
Console.WriteLine("Get Status: " + getResponse.Status.ToString());
Console.WriteLine("Message: " + getResponse.Message.ToString());
Console.WriteLine("Code: " + getResponse.Code.ToString());
Console.WriteLine("Results Length: " + getResponse.Results.Length);
ET_Subscriber getSub = new ET_Subscriber();
getSub.AuthStub = m_etcTDClient;
getSub.Props = new string[] { "SubscriberKey", "EmailAddress", "Status" };
// Loop through subscribers on the list and add their keys to our array
foreach (ET_List_Subscriber ResultListSub in getResponse.Results)
{
// Subscriber Key
strSubscriberKey = ResultListSub.SubscriberKey;
// Get information on that subscriber
getSub.SearchFilter = new SimpleFilterPart() { Property = "SubscriberKey", SimpleOperator = SimpleOperators.equals, Value = new string[] { strSubscriberKey } };
GetReturn getSubResponse = getSub.Get();
foreach (ET_Subscriber sub in getSubResponse.Results)
{
if (dctSubscribers.TryGetValue(sub.EmailAddress.ToUpper(), out strSubscriberKey) == false && dctSubscribers.ContainsKey(sub.EmailAddress.ToUpper()) == false)
{
intIndex += 1;
if (intIndex == 1323)
{
Console.WriteLine("EHY");
}
dctSubscribers.Add(sub.EmailAddress.ToUpper(), ResultListSub.SubscriberKey);
Console.WriteLine("Count: " + intIndex.ToString() + "; Subscriber Key: " + ResultListSub.SubscriberKey);
}
}
}
}
catch (Exception excError)
{
// Display Error
Console.WriteLine("Error: " + excError.ToString());
}
return dctSubscribers;
}
// ------------------------------------------------------------
// Name: GetSubscriberEmails
// Abstract: Get subscriber keys and emails
// ------------------------------------------------------------
public static Dictionary<string, string> GetSubscriberEmails()
{
Dictionary<string, string> dctAllSubscribers = new Dictionary<string, string>();
try
{
ET_Subscriber getSub = new ET_Subscriber();
getSub.AuthStub = m_etcTDClientShared;
getSub.Props = new string[] { "SubscriberKey", "EmailAddress" };
GetReturn getResponse = getSub.Get();
Console.WriteLine("Get Status: " + getResponse.Status.ToString());
Console.WriteLine("Message: " + getResponse.Message.ToString());
Console.WriteLine("Code: " + getResponse.Code.ToString());
Console.WriteLine("Results Length: " + getResponse.Results.Length);
int intResults = getResponse.Results.Length;
// Get all subscriber keys associated with active subscribers
while (getResponse.MoreResults == true || intResults > 0)
{
foreach (ET_Subscriber sub in getResponse.Results)
{
dctAllSubscribers.Add(sub.SubscriberKey, sub.EmailAddress);
}
getResponse = getSub.GetMoreResults();
intResults = getResponse.Results.Length;
}
}
catch (Exception excError)
{
// Display Error
Console.WriteLine("Error: " + excError.ToString());
}
return dctAllSubscribers;
}
