I am attempting to synchronise data from a customers CRM to MailChimp, so they can send automated emails to customers and prospects. The CRM isn’t easy to hook into - so the customer is making the data available as a CSV file on an FTP server. I managed to configure Skyvia to read the CSV and push it to the customers MailChimp list. What I cannot do is:
- Update the data on Mailchimp. I can only push New data. Skyvia fails when I try to Update the records, because it needs a JSON formatted ID to be mapped.
- There are two fields that I cannot seem to Map (Tags and Status). Again, it looks like Mailchimp needs these in a JSON format.
Please could someone point me to a solution for both of these issues?