API - Anniversary Date, export to excel issue

[AnjuD9]

Posting the  data using API like this,

Issue #1

 Not sending custom fields 14 & 15, but when I do export, custom 14 & 15 fields are populated with other custom fields

 Please see the attached file for reference.

Issue #2

When I export the data Custom 4 field has Custom Field 3 data for most of the rows.

Issue #3

In the exported excel, Anniversary date is not getting exported.

When I do export to excel from the constant contact dashboard, custom field 4 is not getting exported properly. 

{
"column_names": ["EMAIL",
"FIRST NAME",
"MIDDLE NAME",
"LAST NAME",
"JOB TITLE",
"COMPANY NAME",
"ADDRESS LINE 1",
"CITY",
"STATE",
"COUNTRY",
"ZIP\/POSTAL CODE",
"CUSTOM FIELD 1",
"CUSTOM FIELD 2",
"CUSTOM FIELD 3",
"CUSTOM FIELD 4",
"CUSTOM FIELD 5",
"CUSTOM FIELD 6",
"CUSTOM FIELD 7",
"CUSTOM FIELD 8",
"CUSTOM FIELD 9",
"CUSTOM FIELD 10",
"CUSTOM FIELD 11",
"CUSTOM FIELD 12",
"CUSTOM FIELD 13"],
"import_data": [{
"addresses": [{
"address_type": "BUSINESS",
"city": "Anchorage",
"country_code": "US",
"line1": "2525 ABCD  200",
"line2": "",
"line3": "",
"postal_code": "99503-2639",
"state_code": "AK"
}],
"anniversary": "10\/3\/2011 12:00:00 AM",
"company_name": "NAD",
"custom_fields": [{
"name": "CUSTOM FIELD 1",
"value": "010"
},
{
"name": "CUSTOM FIELD 2",
"value": "Human Resources"
},
{
"name": "CUSTOM FIELD 3",
"value": "ALASKA "
},
{
"name": "CUSTOM FIELD 4",
"value": "NAX"
},
{
"name": "CUSTOM FIELD 5",
"value": "USA_NSF"
},
{
"name": "CUSTOM FIELD 6",
"value": "Employee"
},
{
"name": "CUSTOM FIELD 7",
"value": "ADMINISTRATOR"
},
{
"name": "CUSTOM FIELD 8",
"value": "N"
},
{
"name": "CUSTOM FIELD 9",
"value": "SUPPORT"
},
{
"name": "CUSTOM FIELD 10",
"value": "ADMINISTRATIVE"
},
{
"name": "CUSTOM FIELD 11",
"value": "2-5 Yrs"
},
{
"name": "CUSTOM FIELD 12",
"value": "F"
},
{
"name": "CUSTOM FIELD 13",
"value": "No"
}],
"email_addresses": ["Karen1.Green1@XXX.com"],
"first_name": "KAREN1",
"job_title": "CLERK1",
"last_name": "GREEN1",
"middle_name": "S"
}],
"lists": ["XXXXXXX"]
}

[Elijah_G]

Hello,

Here's some data about your three issues:

1.  This is because at some point in the past you had imported to Custom Field 14 & 15, and that data is persistent. Those fields will continue to appear in your exports unless you choose to delete them. Please note that deleting custom fields will cause permanent loss of any data stored under those fields for ALL contacts. You can read about managing custom fields here: https://knowledgebase.constantcontact.com/articles/KnowledgeBase/5328-add-and-manage-custom-fields
2. This initially sounds like it has something to do with a change in how the data was being imported for some contacts. It would help a great deal to have some specific contacts to investigate where this is an issue.
3. This is because Anniversary is not part of your columns list. You can find the documentation for column names here: http://developer.constantcontact.com/docs/bulk_activities_api/bulk-activities-import-contacts.html

Sincerely,