The Community is hosting an End of Summer sweepstakes! Participants must complete tasks to earn tickets that will enter them with a chance to win a free year of Constant Contact and other great prizes!*
*No Purchase Necessary. For Official Rules, visit here. Constant Contact’s End of Summer 2020 Sweepstakes ends on October, 20, 2020 at 11:50 PM EST.

Bugs: Bulk Activities - Export Contacts Endpoint via v2 API

Highlighted
Participating Solution Provider

Bugs: Bulk Activities - Export Contacts Endpoint via v2 API

PROBLEM 1.  When I make a query to get a bulk CSV download of contacts using the endpoint:

https://api.constantcontact.com/v2/activities/exportcontacts?api_key=<my_api_key>

 

with parameters (sorted by date descending):

"file_type":"CSV","sort_by":"DATE_DESC","export_date_added":true,"lists":["<my_list_id>"],"column_names":["Email"]

 

I get the response:

<...>"errors":[{"message":"com.roving.RovingServerException: Unexpected IllegalArgumentException in Timestamp.valueOf. User Data&colon; findSubscriberDetailByList","line_number":0,"email_address":""}]<...>

 

----

PROBLEM 2.  When I make a query to get a bulk CSV download of contacts using the SAME endpoint:

https://api.constantcontact.com/v2/activities/exportcontacts?api_key=<my_api_key>

 

with parameters (sorted by email address):

"file_type":"CSV","sort_by":"EMAIL_ADDRESS","export_date_added":true,"lists":["<my_list_id>"],"column_names":["Email"]

 

I get the list of contacts, but it is SORTED DESCENDING by email address instead of ascending  as per the documentation here:

http://developer.constantcontact.com/docs/bulk_activities_api/bulk-activities-export-contacts.html#s...

 

 

 

Mike Sullivan is the founder of Analytics Edge, providing simple Excel-based report automation products for individuals and small businesses.
1 REPLY 1
Highlighted
Honored Contributor

Re: Bugs: Bulk Activities - Export Contacts Endpoint via v2 API

Hi Mike,

 

Here's some info for the two problems you've found:

 

1. This is a known issue that we're actively working on. If things continue according to plan, we should be able to have a fix for this released within the next week.

 

2. After some testing I was able to confirm the same thing that you were seeing. At present we are looking into this to determine what the best course of action is and I should have an update for you by the end of the week.

 

If you have any questions, please let me know!

 

Sincerely,

Elijah G.
API Support Engineer
Developer Portal

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

Visit Page

Constant Contact 2020 End of Summer Community Sweepstakes!

The Constant Contact User Community is hosting a sweepstakes. The more you participate, the more chances you have to win! Read on to learn more...

Read More
Featured