Hi there, I have a workflow to update subscribers in MailChimp and wish to delete existing values on my custom fields as part of the update. How can I do that? I have tried using .clear as instructed in this article (https://support.workato.com/support/discussions/topics/1000084762) but it did not work. The input did pass a null value, however the output showed that the old values were retained.
Please let me know how I can clear out existing values, thank you!
Best Answer
A
Amanda Wong
said
over 5 years ago
Hi Saul, clear passes in null values into the apps to delete existing values. However, not all apps would accept null values as replacement for existing data values. MailChimp is one example. To clear existing data values in MailChimp, you would need to pass an empty string instead of null. You can do so by using "" in formula mode:
Answer
Amanda Wong
said
over 5 years ago
Hi Saul, clear passes in null values into the apps to delete existing values. However, not all apps would accept null values as replacement for existing data values. MailChimp is one example. To clear existing data values in MailChimp, you would need to pass an empty string instead of null. You can do so by using "" in formula mode:
Saul Macht
MailChimp: How to clear existing values?
Hi there, I have a workflow to update subscribers in MailChimp and wish to delete existing values on my custom fields as part of the update. How can I do that? I have tried using .clear as instructed in this article (https://support.workato.com/support/discussions/topics/1000084762) but it did not work. The input did pass a null value, however the output showed that the old values were retained.
Please let me know how I can clear out existing values, thank you!
Hi Saul, clear passes in null values into the apps to delete existing values. However, not all apps would accept null values as replacement for existing data values. MailChimp is one example. To clear existing data values in MailChimp, you would need to pass an empty string instead of null. You can do so by using "" in formula mode:
Amanda Wong
Hi Saul, clear passes in null values into the apps to delete existing values. However, not all apps would accept null values as replacement for existing data values. MailChimp is one example. To clear existing data values in MailChimp, you would need to pass an empty string instead of null. You can do so by using "" in formula mode: