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 16th, 2020 at 11:59 PM EST.

Export Contacts CSV is missing a column value that exists (confirmed existence through GUI)

Highlighted
Occasional Participant

Export Contacts CSV is missing a column value that exists (confirmed existence through GUI)

Despite calling the Export Contacts endpoint specifying the following column names,

 

'EMAIL',

'FIRST NAME',

'LAST NAME',

'HOME PHONE'

,'ADDRESS LINE 1',

'ADDRESS LINE 2',

'CITY',

'STATE',

'COUNTRY',

'ZIP/POSTAL CODE'

 

I am not receiving a value for the STATE column. I've confirmed via the GUI that the contact in question does have STATE as "MA", but the csv retrieved at https://api.constantcontact.com/v2/activities/exportfiles/... has an empty column for STATE

5 REPLIES 5
Highlighted
Moderator

Re: Export Contacts CSV is missing a column value that exists (confirmed existence through GUI)

Hi Evan, 

 

Instead of specifying the STATE column, use US State/CA Province instead to retrieve the state/province 2 letter code. I just tested it and got the correct results.

 

Do you know how this contact was added to the account? For instance, was it added using the bulk import process, through the UI, or using the Contacts Collection API endpoint? If you're still not able to see the state value when using US State/CA Province in the Export request, let me know and I think I can explain.

 

Regards,

 

Rich

Rich Marcucella
Sr. Technical Writer, Content Developer
Web Services Team
http://developer.constantcontact.com
Highlighted
Occasional Participant

Re: Export Contacts CSV is missing a column value that exists (confirmed existence through GUI)

Hi,

I've switched the export column name, but as you suspected, I'm unable to see the State code for some contacts. If I add the address through the Constant contact GUI, the state is returned with the export request. however, I canot see the state if I've used the API.

Highlighted
Occasional Participant

Re: Export Contacts CSV is missing a column value that exists (confirmed existence through GUI)

Is this a known API issue?

Highlighted
Moderator

Re: Export Contacts CSV is missing a column value that exists (confirmed existence through GUI)

Hi Evan,

 

Thanks for providing a follow up to our original exchange. We are looking into your specific situation. If possible, can you PM me with the API key, access token, and the contact Id, we can research this. It could be an API issue, and it could be a situation of functionality in the UI that is not currently consistent with the API.

 

Thanks,

Rich

Rich Marcucella
Sr. Technical Writer, Content Developer
Web Services Team
http://developer.constantcontact.com
Highlighted
Occasional Participant

Re: Export Contacts CSV is missing a column value that exists (confirmed existence through GUI)

Okay thanks I messaged you the credentials.

 

Evan

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