Andrew, How can I view what you replied on the webservice ticket? I have not received anything from them. ... View more

Andrew, We have received your sample converted it and it is working great. Do you have a sample of the uploading of a csv file to a list? (multipart/form-data) ... View more

Andrew, Yes, I only use the dataset becuase that is what I have always done and it has always worked until this read. Please send me the code. Very Much Appreciated. ... View more

Andrew, The vb.net (3.5) dataset xml reader will not read the response returned by the uri. That's what lead me to try and parse out the counts, but that would be a thing that nightmares are made of. When we try and read the response into our dataset xml reader we get an illegal character in path error. Do you have any suggestions on this or do you know of another way we can get the counts we need? I very much appreiate your help with this! ... View more

Andrew, We re not getting the same xml as your example when we do an HTTP GET to your suggested uri. Here is a sample of the uri we used and below it is a sample of the string returned: No where in the returned string is there any counts or count tags. https://api.constantcontact.com/ws/customers/our use name/campaigns/1103693687862 http://api.constantcontact.com/ws/customers/our user name/campaigns/1103693687862 2010-10-04T23:10:15.530Z Constant Contact 2010 Q3 New Template Sent 2010-10-04T23:10:15.530Z 2010-09-17T01:14:24.247Z 2010-10-04T23:10:15.493Z 104 23 6 18 0 1 0 http://myemail.constantcontact.com/Latest-Edition-of-efsNews--With-New-Easy-to-Read-Look-.html?soid=1101594189982&aid=OpunUx1WtAk Latest Edition of efsNews (With New Easy-to-Read Look)   ... View more

Andrew, When we view the responseText returned, it appears as if we are not getting all the text. But even more interesting is that it appears to be text from the email that was sent. There are no Bounce, Optout, Send, or Open counts in the responseText. Could you please verify the uri format you gave use should be returning counts? If not please provide the correct format. Thank you very much, Charles Dim responseStream As Stream = theResponse.GetResponseStream() Dim streamReader As StreamReader = New StreamReader(responseStream) Dim responseText As String = streamReader.ReadToEnd Dim contents As String = responseText.ToString() If contents.Length = 0 Then Exit Sub lblContent.Text = contents.ToString() ... View more

Andrew, We were excited for a moment, but we get the same error as we had previously; Can you take a look and make a suggestion? Thank you, We also tried viewing the responseText and did not see any counts in the string returned: Dim responseStream As Stream = theResponse.GetResponseStream() Dim streamReader As StreamReader = New StreamReader(responseStream) Dim responseText As String = streamReader.ReadToEnd Dim contents As String = responseText.ToString If contents.Length = 0 Then Exit Sub lblContents.Text = contents.ToString() Nested table 'link' which inherits its namespace cannot have multiple parent tables in different namespaces. We tried your suggested uri below, using our code also listed below. This is where we get the error. https://api.constantcontact.com/ws/customers/{username}/campaigns/{campaignID} Dim sUri As String = "https://api.constantcontact.com/ws/customers/" & ctu & "/campaigns/" & strCampaignID Dim sAPIKey As String = "???????" 'setup httpWebReqeust to send the request Dim address As New Uri(sUri) Dim theRequest As HttpWebRequest = TryCast(WebRequest.Create(address), HttpWebRequest) theRequest.Credentials = New NetworkCredential((sAPIKey & "%" & ctu), ctp) theRequest.Method = "GET" theRequest.ContentType = "application/vnd.ctct+xml" Using theResponse As HttpWebResponse = TryCast(theRequest.GetResponse(), HttpWebResponse) 'load dataset with xml response Dim xtr As New XmlTextReader(theResponse.GetResponseStream()) xtr.ReadString() Dim dscte As New DataSet() dscte.ReadXml(xtr) 'Create the xml file to check what we are receiving. dscte.WriteXml("C:\Documents\Data.xml") End Using ... View more

Ben, We use asp.net and vb.net, so we typically use a dataset to read the xml responses from an api. This has served us well until we had to read your event xml response with nested links. So we found a way around it by parsing out the email addresses from the response returned by bounces, opens, sends, etc.. and doing a count in code. But now that we know that a response will only return 50 eamils at time. I'm not sure how we will get the next group of emails and add them to the previous or previous groups. We are simply trying to dispaly the results of a selected email on our asp.net web page. Anything you can sare would be very appreciated.   Dim sUri As String = "https://api.constantcontact.com" & strURI Dim sAPIKey As String = "?????" 'setup httpWebReqeust to send the request Dim address As New Uri(sUri) Dim theRequest As HttpWebRequest = TryCast(WebRequest.Create(address), HttpWebRequest) theRequest.Credentials = New NetworkCredential((sAPIKey & "%" & ctu), ctp) theRequest.Method = "GET" theRequest.ContentType = "application/vnd.ctct+xml" Using theResponse As HttpWebResponse = TryCast(theRequest.GetResponse(), HttpWebResponse) Dim responseStream As Stream = theResponse.GetResponseStream() Dim streamReader As StreamReader = New StreamReader(responseStream) Dim responseText As String = streamReader.ReadToEnd Dim contents As String = responseText.ToString If contents.Length = 0 Then Exit Sub ' search for email addresses Dim i As Integer = 0 Dim intCount As Integer = 0 Dim emails As String() Dim email As String Dim results As New StringBuilder emails = ExtractEmailAddressesFromString(contents) For Each email In emails intCount += 1 results.Append(email & vbNewLine) Next   ... View more

David, Just wanted you to know that we have been able to retieve the email addresses from the responseText string. I will contact you again should we require addtional assistance. Thank you, Charles ... View more

David, At this point no, but I'm not sure how I would parse out just the email addresses from the string response. Thank you, Charles ... View more

Our goal is to present the user with separate lists of the email addresses for Bounces, Optouts, Clicks, and Opens for a selected campaign. This will allow us to then take the appropriate action in our system. Thank you, David ... View more

Good Morning David, Any progress on this topic? We are eager to integrate this feature assoon as possible. Thank you, Charles ... View more

David, Thank you and I look forward to your reply and a resolution.   Charles ... View more

David, Sorry, but we are now back to getting the original error: Nested table 'link' which inherits its namespace cannot have multiple parent tables in different namespaces. The error is on the dscte.ReadXml(xtr) line. I also wanted to add that using our origianl code we are able to successfuly retreive a list of our last 90 day campaigns and the events for the campaign. So my thinking is that there must be some difference in the structure of the bounce and optout xml response being returned. Perhaps some unusual formatting of the xml. Thank you, Charles ... View more

Wanted you to also know that we were able to copy the content of the responseText to notepad and save it as an xml file. When we opened it in the browser, this is what we get: Not sure this any help. The XML page cannot be displayed Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later. Invalid at the top level of the document. Error processing resource 'file:///C:/Documents/test3.xml'. L... "<?xml version="1.0" encoding="UTF-8"?> <feed xmlns="http://www.w3.org/2005/Atom"> <id>http://api.consta... Thank you, Charles ... View more

David, Much appreciate your help with this. I tried your suggestion, however I now get an 'Illegal characters in path' error. Is the string returned to responseText in xml format?  The error is being returned on this line:         Using theResponse As HttpWebResponse = TryCast(theRequest.GetResponse(), HttpWebResponse)             Dim responseStream As Stream = theResponse.GetResponseStream()             Dim streamReader As StreamReader = New StreamReader(responseStream)             Dim responseText As String = streamReader.ReadToEnd             Dim xtr As New XmlTextReader(responseText)             xtr.ReadString()             'load dataset with xml response             Dim dscte As New DataSet()             dscte.ReadXml(xtr) 'Illegal characters in path.             'Create the xml file to check what we are receiving.             dscte.WriteXml("C:\Documents\Data.xml")         End Using Thank you, Charles   XmlTextReader(responseText) ... View more

We are now being told that the xml in your response is not correctly formatted. Can you provide any assistance? The error is "Nested table 'link' which inherits its namespace cannot have multiple parent tables in different namespaces."   ... View more

we have tried the suggested uri and validated that it is complete and correct. it contains the correct user name and campaign id. But our xml file contains only the following ines:   <? xml version="1.0" standalone="yes" ?>   < NewDataSet /> Here is our code     Protected Sub ddCampaigns_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)         Dim ConnectStr As String = _         ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString         'Try         Dim ctu As String = GetCTU()         Dim ctp As String = GetCTP()         'check if user has ct's         If String.IsNullOrEmpty(ctu) Then             Exit Sub         End If         If String.IsNullOrEmpty(ctp) Then             Exit Sub         End If         'this returns an xml info for selected Campaign (email)         Dim strCampaignID As String         Dim s As String = ddCampaigns.SelectedValue.ToString()         Dim index As Integer = s.LastIndexOf("/")         If index >= 0 And (index + 1) < s.Length Then             strCampaignID = s.Substring(index + 1)         End If         Dim sUri As String = "https://api.constantcontact.com/ws/customers/" & ctu & "/campaigns/" & strCampaignID & "/events/bounces" 'optouts" 'clicks"         Dim sAPIKey As String = "///////"         'setup httpWebReqeust to send the request         Dim address As New Uri(sUri)         Dim theRequest As HttpWebRequest = TryCast(WebRequest.Create(address), HttpWebRequest)         theRequest.Credentials = New NetworkCredential((sAPIKey & "%" & ctu), ctp)         theRequest.Method = "GET"         theRequest.ContentType = "application/vnd.ctct+xml"         Using theResponse As HttpWebResponse = TryCast(theRequest.GetResponse(), HttpWebResponse)             'load dataset with xml response             Dim xtr As New XmlTextReader(theResponse.GetResponseStream())             xtr.ReadString()             Dim dscte As New DataSet()             'dscte.ReadXml(xtr) ', XmlReadMode.IgnoreSchema)             dscte.ReadXml(xtr, XmlReadMode.IgnoreSchema)             dscte.WriteXml("C:\Documents\Data.xml")         End Using         'Catch ex As Exception         '    HttpContext.Current.Response.Write(ex.Message)         'End Try     End Sub ... View more

Dave, This may sound funny, but does this return an xml file? I get this error when trying to read the returned result. https://api.constantcontact.com/ws/customers/{username}/campaigns/{campaign-id} Nested table 'link' which inherits its namespace cannot have multiple parent tables in different namespaces.         Dim sUri As String = "https://api.constantcontact.com/ws/customers/" & ctu & "/campaigns/" & strCampaignID         Dim sAPIKey As String = ""         'setup httpWebReqeust to send the request         Dim address As New Uri(sUri)         Dim theRequest As HttpWebRequest = TryCast(WebRequest.Create(address), HttpWebRequest)         theRequest.Credentials = New NetworkCredential((sAPIKey & "%" & ctu), ctp)         theRequest.Method = "GET"         theRequest.ContentType = "application/vnd.ctct+xml"         Using theResponse As HttpWebResponse = TryCast(theRequest.GetResponse(), HttpWebResponse)             'load dataset with xml response             Dim xtr As New XmlTextReader(theResponse.GetResponseStream())             xtr.ReadString()             Dim dscte As New DataSet()             dscte.ReadXml(xtr)             'Create the xml file to check what we are receiving.             dscte.WriteXml("C:\Data.xml")         End Using     ... View more

Dave, I much appreciate your help. I tried what you suggested for the campaign stats, but I get the following error. At this point I was just trying to send the result to an xml file to see what is returned. Any suggestions or thought on where I'm going wrong? The remote server returned an error: (404) Not Found.         Dim sUri As String = "https://api.constantcontact.com/ws/customers/" & ctu & "/campaigns/" & strCampaignID & "/events/clicks"         Dim sAPIKey As String = ""         'setup httpWebReqeust to send the request         Dim address As New Uri(sUri)         Dim theRequest As HttpWebRequest = TryCast(WebRequest.Create(address), HttpWebRequest)         theRequest.Credentials = New NetworkCredential((sAPIKey & "%" & ctu), ctp)         theRequest.Method = "GET"         theRequest.ContentType = "application/vnd.ctct+xml"         Using theResponse As HttpWebResponse = TryCast(theRequest.GetResponse(), HttpWebResponse)             'load dataset with xml response             Dim xtr As New XmlTextReader(theResponse.GetResponseStream())             xtr.ReadString()             Dim dscte As New DataSet()             dscte.ReadXml(xtr) ', XmlReadMode.IgnoreSchema             'Dim dataView As DataView = dscte.Tables("workspace").DefaultView             'Create the xml file to check what we are receiving.             dscte.WriteXml("C:\Data.xml")         End Using   ... View more

Dave, I can get a list of all campaigns, however I would like to limit it to the most current, maybe the current month or last 90 days since that really all we can work with any way. I'm having an issue with the way the datetime is returned 2009-09-30T00:15:13.157Z. Not sure How I would filter on this in a dataview. Any suggestions? 'setup httpWebReqeust to send the request         Dim address As New Uri(sUri)         Dim theRequest As HttpWebRequest = TryCast(WebRequest.Create(address), HttpWebRequest)         theRequest.Credentials = New NetworkCredential((sAPIKey & "%" & ctu), ctp)         theRequest.Method = "GET"         theRequest.ContentType = "application/vnd.ctct+xml"         Using theResponse As HttpWebResponse = TryCast(theRequest.GetResponse(), HttpWebResponse)             'load dataset with xml response             Dim xtr As New XmlTextReader(theResponse.GetResponseStream())             xtr.ReadString()             Dim dsct As New DataSet()             dsct.ReadXml(xtr)             Dim dataView As DataView = dsct.Tables("Campaign").DefaultView             dataView.RowFilter = "Date >= '" & DateTime.Today.Year.ToString() & "-" & DateTime.Today.AddMonths(-1).Month.ToString() & "-1' AND Date <='" & DateTime.Today.Year.ToString() & "-" & DateTime.Today.Month.ToString() & "-1'"            ddCampaigns.DataSource = DataView             ddCampaigns.DataTextField = "Name"             ddCampaigns.DataValueField = "id"             ddCampaigns.DataBind()             ddCampaigns.Items.Insert(0, "")           End Using   ALSO I'm trying to return an xml file that includes the stats for a selected campaign. I can use this to return the service document, but I'm not sure what to do next in order to return the stats for the selected campaign (email).         Dim sUri As String = "https://api.constantcontact.com/ws/customers/" & ctu & "/campaigns/" & strCampaignID & "/events/"         Dim sAPIKey As String = ""         'setup httpWebReqeust to send the request         Dim address As New Uri(sUri)         Dim theRequest As HttpWebRequest = TryCast(WebRequest.Create(address), HttpWebRequest)         theRequest.Credentials = New NetworkCredential((sAPIKey & "%" & ctu), ctp)         theRequest.Method = "GET"         theRequest.ContentType = "application/vnd.ctct+xml"         Using theResponse As HttpWebResponse = TryCast(theRequest.GetResponse(), HttpWebResponse)             'load dataset with xml response             Dim xtr As New XmlTextReader(theResponse.GetResponseStream())             xtr.ReadString()             Dim dscte As New DataSet()             dscte.ReadXml(xtr) ', XmlReadMode.IgnoreSchema                 Dim dataView As DataView = dscte.Tables("Campaign").DefaultView                 'dataView.RowFilter = ''             'Create the xml file to check what we are receiving.             dscte.WriteXml("C:\Data.xml")         End Using ... View more

It looks like it was simply needing us to change the HTTP to HTTPS.   ... View more

Dave, The response xml file we get does not include the list the contact belongs to. Can you offer any suggestions on where to look for a cause? Here is the code I'm using so you can see for yourself what I'm attempting to do. Try Dim ctu As String = Constant_Contact.GetCTU() Dim ctp As String = Constant_Contact.GetCTP() 'check if user has ct's If String.IsNullOrEmpty(ctu) Then Exit Sub End If If String.IsNullOrEmpty(ctp) Then Exit Sub End If 'looking to get a list of lists for this email. Dim sUri As String = "http://api.constantcontact.com/ws/customers/" & ctu & "/contacts?email=" & HttpUtility.UrlEncode((sEmail), Encoding.UTF8) Dim sAPIKey As String = "?????" 'setup httpWebReqeust to send the request Dim address As New Uri(sUri) Dim theRequest As HttpWebRequest = TryCast(WebRequest.Create(address), HttpWebRequest) theRequest.Credentials = New NetworkCredential((sAPIKey & "%" & ctu), ctp) theRequest.Method = "GET" theRequest.ContentType = "application/vnd.ctct+xml" Using theResponse As HttpWebResponse = TryCast(theRequest.GetResponse(), HttpWebResponse) 'load dataset with xml response Dim xtr As New XmlTextReader(theResponse.GetResponseStream()) xtr.ReadString() Dim dsctC As New DataSet() dsctC.ReadXml(xtr) 'Create the xml file to check what we are receiving. dsctC.WriteXml("C:\DataContactLists.xml") End Using Catch ex As Exception HttpContext.Current.Response.Write(ex.Message) End Try ... View more