Help with Importing data into Mail Chimp 'Groups'

  • 90Views
  • Last Post 26 July 2017
0
votes
Paul Johnson posted this 25 July 2017

Hi,

We would like to import some information into our Mail Chimps 'Groups' but not sure how we can do this?

When we try to add a task > Target: Interest Groups

We can see the List ID, InterestGroupCategoryID, Name fields...

Where do we find the InterestGroupCategoryID field, if indeed this is the correct way to import data into our Mail Chimp users Groups...?

Hope you can help!

 

Thanks in advance

Order By: Standard | Newest | Votes
-1
votes
Mariia Zaharova posted this 26 July 2017

Please open your MailChimp connection, click Edit and change the API Version from Ver2 to Ver3. Save the changes and try your scenario again.

For some information please refer to: https://skyvia.com/resources/docs/index.html?connecting_to_mailchimp.htm

Please tell us if this helps.

0
votes
Paul Johnson posted this 26 July 2017

Hi,

Already set API to Ver 3 ...

When we try to add a task > Target: Interest Groups

We can see the List ID, InterestGroupCategoryID, Name fields...

Where do we find the InterestGroupCategoryID field, if indeed this is the correct way to import data into our Mail Chimp users Groups...?

0
votes
Mariia Zaharova posted this 26 July 2017

Sorry for misunderstanding the question.

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

Close