Despite calling the Export Contacts endpoint specifying the following column names,
,'ADDRESS LINE 1',
'ADDRESS LINE 2',
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
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.
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.
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.