About siddhuoops

Hi David, I am looking for the bounces from a particular email campaign. So, basically we are trying to get the customer information like their email and other fields from constant and contact that have bounced. Please let me know if you need further clarification. Thanks!!  ... View more

Hi Dave,   Since our campaign hasn't started yet, I don't have any bounces to check the xml file. But would the field names be the same as what they are in constant contact. Like would the outputted xml file have Email Address, First Name, Last Name, Custom Field 1..the fields that constant and contact provide. Or would they be the different. I would need to program my piece in place so that can be used once our email campaign starts running. Thanks for all your help.  ... View more

Cool. So, the result that gets returned from const and contact is an xml. Now, all I would have to do is get the data from an xml file and output it the way i want (csv, xls) and so on. Thanks once again.  ... View more

That was the problem then. I ran it this morning without any problem. Thanks David.  ... View more

 Hi David, This was working fine few days ago. I added about 50-60 contacts in my list. I tried this 4-5 times and it worked. But today when i tried to run this, I was getting an exception. FYI - I have been using trial version (60 days free) account on constant and contact. Not sure if that would have caused the problem. Here is my code.   public void Bulk_POST(string APIKey, string uName, string pWord)         {             SqlConnection scon = new SqlConnection(@"connection string goes here");             SqlCommand scmd = new SqlCommand("SELECT * FROM Table WHERE LEN() > 0", scon);             SqlDataReader sdr;             try             {                 scon.Open();                 sdr = scmd.ExecuteReader();                 while (sdr.Read())                 {                     CredentialCache LoginCredentials = new CredentialCache();                     LoginCredentials.Add(new Uri("https://api.constantcontact.com/ws/customers/" + uName), "Basic", new NetworkCredential(APIKey + '%' + uName, pWord));                     HttpWebRequest request = (HttpWebRequest)WebRequest.Create("https://api.constantcontact.com/ws/customers/" +                         uName + "/activities");                     request.Credentials = LoginCredentials;                     request.Method = "POST";                     request.ContentType = "application/x-www-form-urlencoded";                     sListUri = "https://api.constantcontact.com/ws/customers/" + uName + "/lists/3";                     StringBuilder data = new StringBuilder();                     data.Append("activityType=" + HttpUtility.UrlEncode("SV_ADD", Encoding.UTF8));                     data.Append("&data=" + HttpUtility.UrlEncode(("Email Address,First Name,Last Name,Company Name,CUSTOM FIELD 1" + "\n"), Encoding.UTF8));                     data.Append(HttpUtility.UrlEncode((sdr.ToString() + "," + sdr.ToString() + "," + sdr.ToString() + "," + "SA" + "," + sdr.ToString()), Encoding.UTF8));                     data.Append("&lists=" + HttpUtility.UrlEncode(sListUri));                     byte[] byteArray = Encoding.UTF8.GetBytes(data.ToString());                     try                     {                         request.ContentLength = byteArray.Length;                         string XMLResponse = "Bytes to send: " + byteArray.Length;                         Stream streamRequest = request.GetRequestStream();                         streamRequest.Write(byteArray, 0, byteArray.Length);                         streamRequest.Close();                         HttpWebResponse Response = (HttpWebResponse)request.GetResponse();                         //THE EXCEPTION IS THROWN IN THE LINE BELOW.                         StreamReader Reader = new StreamReader(Response.GetResponseStream());                         XMLResponse += Response.StatusCode + Response.StatusDescription + Reader.ReadToEnd();                         Reader.Close();                         Response.Close();                         //return XMLResponse;                     }                     catch (WebException e)                     {                         throw new WebException ("WebException: " + e.Status + "With response: " + e.Message);                     }                       catch (Exception e)                     {                         throw new Exception ("Exception: " + e.Message);                     }                 }                 sdr.Close();              }              catch (Exception ex)             {                 throw new Exception("Error occured: " + ex);             }             finally             {                scon.Close();             }         } This same code was working fine like couple days ago. Please let me know if you want any further information. Thanks!   ... View more

Thank You very much on pointing my mistakes. That worked like a charm. Thanks once again.   ... View more

 Thats all I needed to know. Thanks a lot David. ... View more

Hi David, Thanks a bunch for your reply.  So, here https://api.constantcontact.com/ws/customers/{user-name}/lists/1, where would the name of the email campaign go?  If I create an email campaign called EmailBlast, do I need to put this name anywhere? We have several email campaigns that exist on constant and contact right now. So, by putting in just ID, will the contacts get added to the right list then? ... View more

  public string Bulk_POST(string APIKey, string uName, string pWord)     {         CredentialCache LoginCredentials = new CredentialCache();         LoginCredentials.Add(new Uri("https://api.constantcontact.com/ws/customers/USERNAME" + uName), "Basic", new NetworkCredential(APIKey + '%' + uName, pWord));         HttpWebRequest request = (HttpWebRequest)WebRequest.Create("https://api.constantcontact/com/ws/customers/" +             uName + "/activities");         request.Method = "POST";         request.ContentType = "application/x-www-form-urlencoded";         request.Credentials = LoginCredentials;         sListUri = "https://api.constantcontact.com/ws/customers/" + uName + "/lists/TestContact";         StringBuilder data = new StringBuilder();         data.Append("activityType=" + HttpUtility.UrlEncode("SV_ADD", Encoding.UTF8));         data.Append("&data=" + HttpUtility.UrlEncode(("Email Address,Email Type,First Name,Last Name,Company Name" + "\n"), Encoding.UTF8));         //get the data from db and append that to the stringbuilder         SqlConnection scon = new SqlConnection(ConfigurationManager.ConnectionStrings.ConnectionString);         SqlCommand scmd = new SqlCommand("SELECT * FROM CustomerSurveyTemp WHERE IS NOT NULL", scon);         SqlDataReader sdr;         try         {             scon.Open();             sdr = scmd.ExecuteReader();             sdr.Read();             data.Append(HttpUtility.UrlEncode((sdr.ToString() + ",HTML," + sdr.ToString() + "," + sdr.ToString() + "," + "SA"), Encoding.UTF8));         }         catch (Exception ex)         {             throw new Exception("Error occured: " + ex);         }         finally         {             scon.Close();         }         data.Append("&lists=" + HttpUtility.UrlEncode(sListUri));           byte[] byteArray = Encoding.UTF8.GetBytes(data.ToString());         try         {             request.ContentLength = byteArray.Length;             string XMLResponse = "Bytes to send: " + byteArray.Length;             Stream streamRequest = request.GetRequestStream();             streamRequest.Write(byteArray, 0, byteArray.Length);             streamRequest.Close();             HttpWebResponse Response = (HttpWebResponse)request.GetResponse();             StreamReader Reader = new StreamReader(Response.GetResponseStream());             XMLResponse += Response.StatusCode + Response.StatusDescription + Reader.ReadToEnd();             Reader.Close();             Response.Close();             return XMLResponse;         }         catch (WebException e)         {             return ("WebException: " + e.Status + "With response: " + e.Message);         }           catch (Exception e)         {             return ("Exception: " + e.Message);         }     }   I assume this will help me in adding multiple emails to an email campaign called TestList. Does this look complete?   ... View more

 Thanks for the reply. What i want to know is how this is going to work. The way i need to set up is we get a list from the customer weekly. That list includes customer's email, contact information. Since this has to be automated, i am setting up a job in sql server that will load the spreadsheet into the database. Using the database, i will be then adding the customers' info on constant and contact via the API. So, i will have to create a email campaign inside constant and contact. Using my app, I will have to upload a list through the automated process in this campaign.  An email template has to be created inside cons and contact that will get the variable fields from the list. And I assume that campaign then can be scheduled to run weekly. The .Net application will have to feed the fresh data every week to the same place where this template is going to get the data from. Please correct me if I am saying something that can't be done. I just want to get the idea clear before i start programming my piece. Will this even work? ... View more