Mariia Zaharova
posted this
06 April 2018
edited 06 April 2018
posted
06 April 2018
Admin
Please try performing these steps (sample for MailChimp API Ver3):
1) Create new Import package with the CSV file as a source and MailChimp connection as a target.
2) Add new task, select your CSV file
3) Select InterestGroups

4) Set mapping for required columns:
a) To get ListId you can use:
- http://kb.mailchimp.com/lists/managing-subscribers/find-your-list-id
- Skyvia Query Tool (SELECT "Id", "Name" FROM "Lists")
b) The values for the InterestGroupCategoryID field can be found in the InterestGroupCategories table. You can either set the necessary value for this field via the Constant mapping or use the Target Lookup mapping.
JIC: Open Query Tool and execute this query on your MailChimp connection to see all available data in the InterestGroupCategories table:
SELECT t.* FROM InterestGroupCategories AS t
c) Specify Name (for example, via Column mapping or Constant mapping).

5) Save the package.
If this doesn't help, please specify the MailChimp API version you are using, send us sample of your CSV file (so that we are able to see its structure) and we will provide you with all possible solutions.