JSON format for Mailchimp address import (csv file)

  • 17Views
  • Last Post 20 February 2019
0
votes
SAGU Web posted this 18 February 2019

Running into this problem with mailchimp:

CSV file has invalid content or its structure does not correspond to the mapping defined in the package.

What is the correct format for the address field that has address, city,state, and zip in a csv file?

This is what I currently have:

"{"address": {"address1": "675 Ponce De Leon Ave NE","address2": "Suite 5000","city": "Atlanta","state": "GA","zip": "30308","country": "US"}}"

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 19 February 2019

Hi!

Please try storing address values in CSV file in this format:

{"addr1": "675 Ponce De Leon Ave NE","addr2": "Suite 5000","city": "Atlanta","state": "GA","zip": "30308","country": "US"}

 

Please notify me about the results.

 

Best regards,

Mariia

0
votes
SAGU Web posted this 19 February 2019

 

Same error message

CSV file has invalid content or its structure does not correspond to the mapping defined in the package.

0
votes
SAGU Web posted this 19 February 2019

Address is mapped as DT_AUTO

0
votes
SAGU Web posted this 19 February 2019

Also ran it through a CSV checker, and here are the results

0
votes
SAGU Web posted this 19 February 2019

 

However, even with the format change, it still has the same error.

0
votes
SAGU Web posted this 19 February 2019

Also tried this format for the JSON and same error.

0
votes
Mariia Zaharova posted this 20 February 2019

Could you please send us your test CSV file (file with several lines in it, with which the issue could be reproduced) so that we are able to check it. Most likely, the issue is related to the general format of your CSV file.

 

Thanks.

 

Best regards,

Mariia

Close