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: 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:
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,