Thanks Mark. What i will do is to upload contacts to ctct, then have a next step to grab those contacts and update my database. Thay way, if 350 contacts gets added to ctct, then 350 contacts will be updated in my database thus making the statistics better.   I have some questions on getting the members from a contact list but I will create a new post for that as its a different topic.   Thanks for your help on this. It was great to learn more about the process. ... View more

Hi Mark,   Its great that duplicates are not added to constant and contact and we like it that way. We do weekly mailings via ctct. I have a list that i use all the time for sending these mails out weekly. Prior to I do the export, I clear out the list. Using the sql data reader, I start adding contacts one by one to ctct. When they are added, i then mark a flag in my database with a datetime stamp indicating that this contact was mailed out. What happens inside ctct, we get that report later once they get mailed. But for our reporting, we tell the client that so and so number of records were mailed out. For my own data validity, if  I have 300 contacts to send to ctct, what happens right now is even i have any duplicates, the response from the api comes back saying created. Say there are 5 contacts with the same email address on my list to export, when i check in ctct after my routine has run, only 1 show up and the remaining 4 are not there which is perfect. But in my database, the flag is already datetimestamped, so client sees 5 being mailed, in reality only one goes out.    I need to track these 4 via ctct api that they were not added. If there is anything that ctct tells me that these 4 records were ignored, were dupes, not added any sort of status, then i could tweak my routine to not date stamp these records. That way the results are accurate to clients and they see only 1 email being sent out. I know these dupes could be taken care of when i create the list but if there are some bad emails, emails that ctct didn't import, they could fall into this as well. Let me know if I am asking for too much. If there is not a way to capture the status during the bulk upload, then thats not a problem. There are so many feature via API that we can do after the list is uploaded..i was checking to make sure i am not missing anything in the bulk upload.   Thanks!! ... View more

Thanks for the explanation. I tried testing this by adding two duplicate emails to constant contact via API. As i was debugging through this code: 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();  ..found out that the Response.StatusCode and response.StatusDescritpion was set to created for both of the duplicate contacts. When i looked into constant contact list, only one was created. Would i be able to capture somewhere here in the code that tells me anything about the contact whether it was duplicate or bad email or not added, so I could update that contact in my db? It would be very helpful if I can get anything out of constant contact that would be more specific about that contact. Let me know if I did not make myself clear. ... View more

Thanks Dave. Also, thanks for the explanation. That solved it. ... View more

Its when getting all the campaigns.  string uName = "abc"; string pWord = "xyz"; string APIKey = "apikey"; ////Response.Redirect("Flyer2.aspx?dealerid=" + txtLogin.Text); 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 + "/campaigns"); request.Credentials = LoginCredentials; HttpWebResponse response = (HttpWebResponse)request.GetResponse(); Stream str = response.GetResponseStream(); byte[] inBuf = new byte[100000]; try { int bytesToRead = Convert.ToInt32(inBuf.Length); int bytesRead = 0; while (bytesToRead > 0) { int n = str.Read(inBuf, bytesRead, bytesToRead); if (n == 0) { break; // TODO: might not be correct. Was : Exit While } bytesRead += n; bytesToRead -= n; } FileStream fstr = new FileStream(@"\\User\Desktop\Campaigns.xml", FileMode.OpenOrCreate, FileAccess.Write); fstr.Write(inBuf, 0, bytesRead); str.Close(); fstr.Close(); } catch (Exception ex) { throw new Exception("Exception: " + ex.Message); }   ... View more

When i hardcoded the date to November, then it worked.    I changed the scheduled date to 2011-4-11, but it still says Schedule cannot be in the past. It works for November but not for 3 days from today.  I can try some other dates too.. ... View more

I forgot to give you the full error. The error says "Schedule cannot be in the past".   I changed the scheduledTime to be 3 days from today. Is that not set correct?   Also, this campaign has a list attached to it. Also, its in Draft status.  ... View more

Sure I can post it here.      This is my XML. string createCampaign = @"<?xml version=""1.0"" encoding=""UTF-8"" ?> <entry xmlns=""http://www.w3.org/2005/Atom""> <link href=""/ws/customers/abc/campaigns/" + campaignId + @"/schedules/1"" rel=""edit"" /> <id>http://api.constantcontact.com/ws/customers/abc/campaigns/" + campaignId + "/schedules/1" + @"</id> <title type=""text"">2010-11-13T15:03:35Z</title> <updated>2010-11-13T20:03:35.000Z</updated> <author> <name>Constant Contact</name> </author> <content type=""application/vnd.ctct+xml""> <Schedule xmlns=""http://ws.constantcontact.com/ns/1.0/"" id=""http://api.constantcontact. com/ws/customers/abc/campaigns/" + campaignId + @"/schedules/1""> <ScheduledTime>" + DateTime.Now.AddDays(3) + @"T20:03:35.000Z</ScheduledTime> </Schedule> </content> </entry>";   I am getting a 400 Bad Error request.   ... View more

Thanks Dave.   I have emailed to App team answering all your questions. Looking forward to hear from you guys. Once again, thanks a bunch for all your help. ... View more

Thank You very much. It now copied the campaign. One last question, would i be able to schedule this copied campaign to run a particular date using the API..or is this something i have to do via the web interface.   Thanks again for your tremendous support on this. Your help is very much appreciated. ... View more

This is my xml. All I did was made changes to <Name>...     <?xml version="1.0" encoding="UTF-8" ?> - <entry xmlns="http://www.w3.org/2005/Atom"> <link href="/ws/customers/abc/campaigns/1105077954923" rel="edit" /> <id>http://api.constantcontact.com/ws/customers/abc/campaigns/1105077954923</id> <title type="text">Test Custom Template Email - 4</title> <updated>2011-04-07T14:45:20.019Z</updated> - <author> <name>Constant Contact</name> </author> - <content type="application/vnd.ctct+xml"> - <Campaign xmlns="http://ws.constantcontact.com/ns/1.0/" id="http://api.constantcontact.com/ws/customers/abc/campaigns/1105077954923"> <Name>Test Custom Template Email - 4</Name> <Status>Sent</Status> <Date>2011-04-07T14:45:20.019Z</Date> <LastEditDate>2011-04-07T14:50:05.454Z</LastEditDate> <LastRunDate>2011-04-07T14:45:19.999Z</LastRunDate> <Sent>7</Sent> <Opens>0</Opens> <Clicks>0</Clicks> <Bounces>0</Bounces> <Forwards>0</Forwards> <OptOuts>0</OptOuts> <SpamReports>0</SpamReports> <SharePageURL /> <Subject>PD Survey Test</Subject> <FromName>ABC</FromName> <CampaignType>CUSTOM</CampaignType> <ViewAsWebpage>YES</ViewAsWebpage> <ViewAsWebpageLinkText>Click here</ViewAsWebpageLinkText> <ViewAsWebpageText>Having trouble viewing this email?</ViewAsWebpageText> <PermissionReminder>NO</PermissionReminder> <GreetingSalutation>Dear</GreetingSalutation> <GreetingName>FirstName</GreetingName> <GreetingString>Greetings!</GreetingString> <OrganizationName>ABC</OrganizationName> <OrganizationAddress1>123 Main St</OrganizationAddress1> <OrganizationAddress2>Suite 100</OrganizationAddress2> <OrganizationAddress3 /> <OrganizationCity>Chicago</OrganizationCity> <OrganizationState>IL</OrganizationState> <OrganizationInternationalState /> <OrganizationCountry>us</OrganizationCountry> <OrganizationPostalCode>99999</OrganizationPostalCode> <IncludeForwardEmail>YES</IncludeForwardEmail> <ForwardEmailLinkText>Forward email</ForwardEmailLinkText> <IncludeSubscribeLink>YES</IncludeSubscribeLink> <SubscribeLinkText>Subscribe me!</SubscribeLinkText> <EmailContentFormat>XHTML</EmailContentFormat> <EmailContent><html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml" xmlns:cctd="http://www.constantcontact.com/cctd"> <body><CopyRight>Copyright (c) 1996-2011 Constant Contact. All rights reserved. Except as permitted under a separate written agreement with Constant Contact, neither the Constant Contact software, nor any content that appears on any Constant Contact site, including but not limited to, web pages, newsletters, or templates may be reproduced, republished, repurposed, or distributed without the prior written permission of Constant Contact. For inquiries regarding reproduction or distribution of any Constant Contact material, please contact legal@constantcontact.com.</CopyRight> <OpenTracking/> <!-- Do NOT delete previous line if you want to get statistics on the number of opened emails --> <CustomBlock name="letter.intro" title="Personalization"> <Greeting/> </CustomBlock> <b>Please click on the survey link below.</b> <Property name="Subscriber.CustomText1" /><br /> <Property name="Subscriber.CustomText2" /> </body> </html></EmailContent> <EmailTextContent><Text><Greeting/></Text></EmailTextContent> <StyleSheet /> <ArchiveStatus /> <ArchiveURL /> + <ContactLists> - <ContactList id="http://api.constantcontact.com/ws/customers/abc/lists/4"> <link xmlns="http://www.w3.org/2005/Atom" href="/ws/customers/abc/lists/4" rel="self" /> </ContactList> </ContactLists> - <FromEmail> - <Email id="http://api.constantcontact.com/ws/customers/abc/settings/emailaddresses/1"> <link xmlns="http://www.w3.org/2005/Atom" href="/ws/customers/abc/settings/emailaddresses/1" rel="self" /> </Email> <EmailAddress>xyz@abc.com</EmailAddress> </FromEmail> - <ReplyToEmail> - <Email id="http://api.constantcontact.com/ws/customers/abc/settings/emailaddresses/1"> <link xmlns="http://www.w3.org/2005/Atom" href="/ws/customers/abc/settings/emailaddresses/1" rel="self" /> </Email> <EmailAddress>xyz@abc.com</EmailAddress> </ReplyToEmail> </Campaign> </content> - <source> <id>http://api.constantcontact.com/ws/customers/abc/campaigns</id> <title type="text">Campaigns for customer: abc</title> <link href="campaigns" /> <link href="campaigns" rel="self" /> - <author> <name>abc</name> </author> <updated>2011-04-07T14:50:05.494Z</updated> </source> </entry>     ... View more

Thanks Dave for the guide. I was able to build a custom template and pass the required custom fields in my body of the email. However, when I try to make a copy of this campaign via API, I run into the following error.     WebException: ProtocolErrorWith response: The remote server returned an error: (400) Bad Request.Full Detail: Error 400: Error: Line 6: cvc-complex-type.2.4.a: Invalid content was found starting with element 'LastRunDate'. One of '{"http://ws.constantcontact.com/ns/1.0/":PermissionReminder, "http://ws.constantcontact.com/ns/1.0/":PermissionReminderText, "http://ws.constantcontact.com/ns/1.0/":Subject, "http://ws.constantcontact.com/ns/1.0/":FromName, "http://ws.constantcontact.com/ns/1.0/":ViewAsWebpage, "http://ws.constantcontact.com/ns/1.0/":ViewAsWebpageLinkText, "http://ws.constantcontact.com/ns/1.0/":ViewAsWebpageText, "http://ws.constantcontact.com/ns/1.0/":Sent, "http://ws.constantcontact.com/ns/1.0/":Opens, "http://ws.constantcontact.com/ns/1.0/":Clicks, "http://ws.constantcontact.com/ns/1.0/":Bounces, "http://ws.constantcontact.com/ns/1.0/":Forwards, "http://ws.constantcontact.com/ns/1.0/":OptOuts, "http://ws.constantcontact.com/ns/1.0/":SpamReports, "http://ws.constantcontact.com/ns/1.0/":CampaignType, "http://ws.constantcontact.com/ns/1.0/":EmailContent, "http://ws.constantcontact.com/ns/1.0/":EmailTextContent, "http://ws.constantcontact.com/ns/1.0/":EmailContentFormat, "http://ws.constantcontact.com/ns/1.0/":StyleSheet, "http://ws.constantcontact.com/ns/1.0/":ContactLists, "http://ws.constantcontact.com/ns/1.0/":FromEmail, "http://ws.constantcontact.com/ns/1.0/":ReplyToEmail, "http://ws.constantcontact.com/ns/1.0/":GreetingSalutation, "http://ws.constantcontact.com/ns/1.0/":GreetingName, "http://ws.constantcontact.com/ns/1.0/":GreetingString, "http://ws.constantcontact.com/ns/1.0/":OrganizationName, "http://ws.constantcontact.com/ns/1.0/":OrganizationAddress1, "http://ws.constantcontact.com/ns/1.0/":OrganizationAddress2, "http://ws.constantcontact.com/ns/1.0/":OrganizationAddress3, "http://ws.constantcontact.com/ns/1.0/":OrganizationCity, "http://ws.constantcontact.com/ns/1.0/":OrganizationState, "http://ws.constantcontact.com/ns/1.0/":OrganizationInternationalState, "http://ws.constantcontact.com/ns/1.0/":OrganizationPostalCode, "http://ws.constantcontact.com/ns/1.0/":OrganizationCountry, "http://ws.constantcontact.com/ns/1.0/":IncludeForwardEmail, "http://ws.constantcontact.com/ns/1.0/":ForwardEmailLinkText, "http://ws.constantcontact.com/ns/1.0/":IncludeSubscribeLink, "http://ws.constantcontact.com/ns/1.0/":SubscribeLinkText, "http://ws.constantcontact.com/ns/1.0/":ArchiveStatus, "http://ws.constantcontact.com/ns/1.0/":ArchiveURL, "http://ws.constantcontact.com/ns/1.0/":SharePageURL, "http://ws.constantcontact.com/ns/1.0/":NextRunDate, "http://ws.constantcontact.com/ns/1.0/":Urls}' is expected. Error: Line 39: cvc-type.3.1.2: Element 'EmailContent' is a simple type, so it must have no element information item [children]. Error: Line 40: cvc-type.3.1.2: Element 'EmailTextContent' is a simple type, so it must have no element information item [children].     ... View more

Hi Dave,   If i do a custom template, would i be able to drag fields to the body? There are few fields that i have to pass from the list to the body of an email. When i was building a custom template, i didn't see an option to add fields to the body.   Also, since i will be copying a campaign via API, do I need to create the body each time i do that or is that a one time thing. Where by passing the campaign ID, the contents as well as the list will all be copied.    Not sure if I explained myself very clear here. ... View more

So, i would have to create an email template in constant and contact using custom html template then, correct? Is there an option where i can do that rather than having you guys create it?    I see a button "Want a custom template? Let us create it" but don't see anywhere i could create one of my own. Please let me know. ... View more

This is what i get now.   WebException: ProtocolErrorWith response: The remote server returned an error: (400) Bad Request.Full Detail: Error 400: The request contains errors in the common Atom sections, which lie outside <entry> or <Content>, such as <feed>, <id>, <author> or <updated>. ... View more

I changed my content type to "application/atom+xml", and now i get a 400 Bad Request error. ... View more

 I tried the code below to copy a new campaign but i get an error when i execute my code. "Web Exception: Unsupported media types".     public void CreateCampaign(string APIKey, string uName, string pWord)     {         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 + "/campaigns");         request.Credentials = LoginCredentials;         string createCampaign = @"<?xml version=""1.0"" encoding=""UTF-8"" ?>          <entry xmlns=""http://www.w3.org/2005/Atom"">         <link href=""/ws/customers/lennoxpd/campaigns/1105057009223"" rel=""edit"" />          <id>http://api.constantcontact.com/ws/customers/abc/campaigns/1105057009223</id>          <title type=""text"">" + DateTime.Now.ToShortDateString() + " Email Campaign" + @"</title>          <updated>2011-04-04T20:05:07.856Z</updated>          <author>         <name>Constant Contact</name>          </author>         <content type=""application/vnd.ctct+xml"">         <Campaign xmlns=""http://ws.constantcontact.com/ns/1.0/"" id=""http://api.constantcontact.com/ws/customers/abc/campaigns/1105057009223"">         <Name>" + DateTime.Now.ToShortDateString() + " Email Campaign" + @"</Name>          <Status>Sent</Status>          <Date>2011-04-07T20:05:07.856Z</Date>          <LastEditDate>2011-04-06T14:44:56.956Z</LastEditDate>          <LastRunDate>2011-04-04T20:05:06.375Z</LastRunDate>          <Sent>7</Sent>          <Opens>0</Opens>          <Clicks>0</Clicks>          <Bounces>4</Bounces>          <Forwards>0</Forwards>          <OptOuts>0</OptOuts>          <SpamReports>0</SpamReports>          <SharePageURL>http://myemail.constantcontact.com/Survey-program-test.html?soid=1104293819483&aid=PnEBRSkYmOc</SharePageURL>          <Subject>Survey program test</Subject>          <FromName>Comp A</FromName>          <CampaignType>STOCK</CampaignType>          <ViewAsWebpage>YES</ViewAsWebpage>          <ViewAsWebpageLinkText>Click here</ViewAsWebpageLinkText>          <ViewAsWebpageText>Having trouble viewing this email?</ViewAsWebpageText>          <PermissionReminder>YES</PermissionReminder>          <PermissionReminderText />          <GreetingSalutation />          <GreetingString />          <OrganizationName />          <OrganizationAddress1>6123 Main St</OrganizationAddress1>          <OrganizationAddress2>Suite 985</OrganizationAddress2>          <OrganizationAddress3 />          <OrganizationCity>City</OrganizationCity>          <OrganizationState>State</OrganizationState>          <OrganizationInternationalState />          <OrganizationCountry>us</OrganizationCountry>          <OrganizationPostalCode>99999</OrganizationPostalCode>          <IncludeForwardEmail>YES</IncludeForwardEmail>          <ForwardEmailLinkText>Forward email</ForwardEmailLinkText>          <IncludeSubscribeLink>YES</IncludeSubscribeLink>          <SubscribeLinkText>Subscribe me!</SubscribeLinkText>          <ArchiveStatus />          <ArchiveURL />          <ContactLists>         <ContactList id=""http://api.constantcontact.com/ws/customers/abc/lists/4"">         <link xmlns=""http://www.w3.org/2005/Atom"" href=""/ws/customers/abc/lists/4"" rel=""self"" />          </ContactList>         </ContactLists>         <FromEmail>         <Email id=""http://api.constantcontact.com/ws/customers/abc/settings/emailaddresses/1"">         <link xmlns=""http://www.w3.org/2005/Atom"" href=""/ws/customers/abc/settings/emailaddresses/1"" rel=""self"" />          </Email>         <EmailAddress>abc@compa.com</EmailAddress>          </FromEmail>         <ReplyToEmail>         <Email id=""http://api.constantcontact.com/ws/customers/abc/settings/emailaddresses/1"">         <link xmlns=""http://www.w3.org/2005/Atom"" href=""/ws/customers/abc/settings/emailaddresses/1"" rel=""self"" />          </Email>         <EmailAddress>abc@compa.com</EmailAddress>          </ReplyToEmail>         </Campaign>         </content>         <source>         <id>http://api.constantcontact.com/ws/customers/abc/campaigns</id>          <title type=""text"">Campaigns for customer: abc</title>          <link href=""campaigns"" />          <link href=""campaigns"" rel=""self"" />          <author>         <name>abc</name>          </author>         <updated>2011-04-06T14:44:56.999Z</updated>          </source>         </entry>";         request.Method = "POST";         request.ContentType = "text/xml";         UTF8Encoding encoding = new UTF8Encoding();         byte[] byteArray = encoding.GetBytes(createCampaign);         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)         {             throw new WebException("WebException: " + e.Status + "With response: " + e.Message);         }         catch (Exception e)         {             throw new Exception("Exception: " + e.Message);         }     }     ... View more