I'm looking to set up a connection between a CSV file and MailChimp and I've been able to do a simple insert but the CSV file contains records to be added and updated. However, when I try to set up the Update or Upsert connection, I'm required to specify the ID field, which I do not have in our CSV data.
Normally, I would upload the file manually and check off the option to auto-update the list in the MailChimp import process. We're needing to automate this process, which is why I'm working through your connector.
Let me know if there's any way to collect the ID number from MailChimp and insert it into the connector dynamically or any other options.