How do I specify the exact list ID for my sync with mysql
Specify mailchimp list ID/Name for mysql sync
- Last Post 26 May 2017
Common recommendations for synchronization tasks with the ListMembers object (MailChimp):
- the task can be set for a specific ListId only; you should know the ListId and set it as Constant in the Task editor when specifying the mapping;
- you should select the "Use this value as filter of target objects" check box in the mapping for ListId column.
To get ListId you can use:
- Skyvia Query Tool , select New SQL and then select your MailChimp connection:
SELECT "Id", "Name" FROM "Lists"
You are working with the Synchronization package with the MailChimp connection as Source and MySQL connection as Target, aren't you?
In this case, you should specify the mapping in the following way:
1) From Source to Target:
2) From Target to Source:
In this case, the data will be filtered by specific ListId value while synchronization from MailChimp to MySQL and this constant value will be used in the opposite direction.
For more information, please refer to: https://skyvia.com/resources/docs/index.html?constant_mapping.htm
Please tell us if this information helps.
That was just a test I did. It is not exactly what I wanted to achieve. What I want is to replicate the entire list 2017 OLX SoMA Votes to the table votes_2017. I can't seem to find how to export the fields in that particular list to the specified mysql table
Thank you for the reply. You can specify the filter conditions to filter data to replicate. For this, click the edit link for the corresponding replicated object in the replication package editor:
In the opened Task Editor window specify the necessary filter conditions:
Please note, at the moment, it is impossible to specify custom table for data replication. We will consider the possibility to implement options for table creation in the replication tasks in the future.
For more information about replication, please refer to: https://skyvia.com/resources/docs/index.html?replication.htm