We all started somewhere! Share your experience on the Get Advice: Let's Get Started Sweepstakes thread and be entered to win a $100 credit on your Constant Contact account.

Sort contact and email reports in v3 API

KristineI56
Participant

Sort contact and email reports in v3 API

How to sort 'contact' and 'email reports' using 'created_at' or 'updated_at' fields in v3 API?

1 REPLY 1
Caleb_A
Moderator

My name is Caleb and I'm a member of Constant Contact’s API Developer Support.

 

The V3 API does not have the ability to sort contacts / campaigns directly, however we are able to create a request which would provide a response that you can then use to parse and sort the data for the 'created_at' and 'updated_at' times you need.

 

To help gather more relevant data we are able to filter both contacts and campaigns based on the 'updated_at' value that the contact / campaigns currently have.

For contacts this can be achieved by setting your parameter as 'updated_after' and setting the value as the appropriate updated_at time (ISO-8601 Format) to get more relevant responses. There are further examples of how to do this as well as other criteria that you can use in the link provided below.

 

Get a Collection of Contacts:
https://developer.constantcontact.com/api_reference/index.html#!/Contacts/getContacts

 

An alternative method to filtering by the updated_at values for contacts would be to make a request to create a .csv file which would contain both values which you can then parse the response for the data.

 

Exporting a CSV File:
https://developer.constantcontact.com/api_reference/index.html#!/Bulk_Activities/postContactsExport

 

For campaigns you will need to set the parameter as either 'before_date' or 'after_date' and set the value to the appropriate updated_at time (ISO-8601 Format) to gather more relevant responses. You may also use these parameters to get a range of campaigns last updated within a specific time-frame. I have provided the link which explains this process in further detail below.

 

Get a Collection of Emails:
https://developer.constantcontact.com/api_reference/index.html#!/Email_Campaigns/retrieveEmailCampai...

 

Please have a look and let us know if you have any other questions!


Regards,

Caleb A.
API Support Specialist

Did I answer your question?
If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.
Developer Portal

View API documentation, code samples, get your API key.

Visit Page