I have an SSIS Data Flow Task designed to read the MailChimp ListMemberTags table and write to a local SQL Server table. My Data Flow tasks doing the same with ListMembers and ListMergeFields run with no issue but this task stays with the wheel spinning (when I execute via Visual Studio) on the Source component and takes an hour or so and returns no records.
We have multiple Email Lists and each has Merge Fields defined which is where I am assuming the Members' Merge field data would be held.
What am I missing?
Extracting MailChimp ListMemberTags takes a long time with no results
-
- Posts: 9
- Joined: Thu 27 Feb 2020 00:17
Re: Extracting MailChimp ListMemberTags takes a long time with no results
1. Did you manually stop the task execution? Or was it finished by Visual Studio?KevinSeerup wrote: ↑Thu 27 Feb 2020 02:48this task stays with the wheel spinning (when I execute via Visual Studio) on the Source component and takes an hour or so and returns no records
2. Please open the Progress tab in the package designer after the task execution. Are there any errors or warnings? Specify them if any.
Re: Extracting MailChimp ListMemberTags takes a long time with no results
https://mailchimp.com/developer/referen ... mber-tags/
Lists -> ListMembers -> ListMemberTags
Tags are read with a triple level of nesting, i.e. to read tags we read all Lists, then for each of them, we read its ListMembers and then for each ListMember we read its ListMemberTags. Therefore, a big number of Lists and ListMembers results in many API calls.
You can increase performance by specifying ListId and EmailHash (or only ListId) in the WHERE clause.
Lists -> ListMembers -> ListMemberTags
Tags are read with a triple level of nesting, i.e. to read tags we read all Lists, then for each of them, we read its ListMembers and then for each ListMember we read its ListMemberTags. Therefore, a big number of Lists and ListMembers results in many API calls.
You can increase performance by specifying ListId and EmailHash (or only ListId) in the WHERE clause.
-
- Posts: 9
- Joined: Thu 27 Feb 2020 00:17
Re: Extracting MailChimp ListMemberTags takes a long time with no results
Thanks - unfortunately my trial has now expired so I can't test this.
Is there any way of extending the trial?
Is there any way of extending the trial?
-
- Posts: 9
- Joined: Thu 27 Feb 2020 00:17
Re: Extracting MailChimp ListMemberTags takes a long time with no results
Can anyone explain why I am NOT getting any data from ListMemberTags? I presumed that would be where the additional Merge fields would be held. If not in that table where are the Merge fields held?
Re: Extracting MailChimp ListMemberTags takes a long time with no results
Please contact us via https://www.devart.com/company/contactform.html.Is there any way of extending the trial?
1. Is your query "SELECT * FROM ListMemberTags" or "SELECT * FROM ListMembers"? If you select data from ListMembers, add "MergeFieldsDetectionBehavior=JoinAll;" to your connection string.Can anyone explain why I am NOT getting any data from ListMemberTags?
2. How do you check retrieved data? Try a simple data flow:
Devart MailChimp Source ("SELECT * FROM ...") -> Flat File Destination
-
- Posts: 9
- Joined: Thu 27 Feb 2020 00:17
Re: Extracting MailChimp ListMemberTags takes a long time with no results
Thank you - changing the MergeFieldsDetectionBehaviour setting made a big difference. It took me a while to get all of the Merge field names to be consistent across my Lists but I am now extracting the data I was looking for.