I'm trying to find a way to get the excel or report file of all the sent email campaigns using an API call. I do see that, there is reporting as a service which allows us to download the excel or file manually. In order to automate the same it would be helpful if someone could direct me to an API.
Thank you for reaching out to Constant Contact's API Support.
You can find our v2 API documentation here: https://developer.constantcontact.com
You will want to specifically look at the sections of the API docs related to https://developer.constantcontact.com/docs/campaign-tracking/email-campaign-tracking-.html.
Please keep in mind the API does not provide a single Excel file like our website UI does. It will provide the raw data in a JSON format which you can then put in Excel or any other database you wish to use.
Thank you for your reply. I think I didn't justify on the explanation of my question. What I'm looking for is the complete details that we are able to access in case of report download. The information we get on the report comprises of all the demographic information along side other details which I'm unable get it through the email tracking API. Is there any way that I can get the whole information that's appearing in the form excel to be accessed with the help of an API? I have attached the sample data that I'm speaking about.
It would be helpful if you could direct me on this.
The API does not give the data in the same way. Any of the reporting endpoints will provide you with the contactID and not the email address, name, etc. of the contact. You would then use the contactID to retrieve the details of the contact and put that information together in your database.
The API is designed to provide the information so you can populate it on your end and then manipulate it in any manner you need. Here is an example of how I might accomplish what you are looking to do.
I would GET all campaigns that have been sent so you have those campaignIDs.
Then you can use the campaignIDs to GET the sent reports.
The sent report shows you both the contactID and the email address. If you then want all of the information you have for the contact (such as names, physical address, etc.) you can GET the contact information.
You would store all of this data in your own database and put it together in whatever report format that you want.