Software tips, techniques, and news.

By Kiyan Allaei  Posted on  December 21st, 2021  in  Free Downloads, Claris FileMaker

FileMaker Mailchimp Integration

Intuit's Mailchimp is a powerful tool that allows you to engage with your customers to boost your business with an advanced, yet easy-to-use marketing platform. With over 12 million active customers and a total audience of over 4 billion, Mailchimp has become a leading marketing platform for all types of businesses. Companies that use both FileMaker and Mailchimp often find themselves doing double data entry from one system to the next. In this article, we will demonstrate how you can eliminate the hassle of manually updating your email lists by integrating your FileMaker solution with Mailchimp.

Setting Up a Free Mailchimp Account

First, you will need to set up a Mailchimp account. Once you have your account, you will need to generate your API key. This key will be used to authenticate with the API so Mailchimp knows who you are. Make sure to generate an API key, not a client key for mobile apps.

Now that you have your API keys, we will need to grab the Audience ID of your default audience. This ID will be used to tell the API where to push your contacts. Free accounts are only allowed one audience (list), Essentials allows up to 3, Standard up to 5, and Premium allows unlimited. Navigate to all contacts, click on the Settings dropdown, and select "Audience name and defaults." From here, you can copy the Audience ID to the right.

Integrating With the Mailchimp Marketing API

The Mailchimp "add members to list" API call requires parameters outside of the URL encoded parameters shown below. This API call requires an email and status to be passed in the request body. The two required and any additional parameters will need to be JSON-encoded text, passed as a parameter using the cURL variable.

Insert from URL [ Select ; With Dialog: Off ; $result ; "https://us20.api.mailchimp.com/3.0/lists/" & $audienceID & "/members" ; $cURL ; Do not automatically encode URL ]

It's important to note that with a successful API request, Mailchimp will NOT return a response to FileMaker. This means it's important to consider this in your error trapping, as FileMaker will generate a false error code 10 as there is no response returned.

The API will return a response if an incorrect request was made. For example, if a contact unsubscribes to the list, the API is not allowed to resubscribe them. If this happens, Mailchimp will return an error along with the contact's subscription status, which you can parse out using the native JSONGetElement () function.

Conclusion

Double data entry can be a thing of the past by integrating Intuit's Mailchimp with your FileMaker solution. You can manage lists, activities, events, and much more through the Mailchimp API. Automate your surveys, email campaigns, and marketing processes while eliminating double data entry to avoid human blunders. Please contact us if you need further assistance or would like to discuss getting your FileMaker Solution integrated with Mailchimp.

Did you know we are an authorized reseller for Claris FileMaker Licensing?
Contact us to discuss upgrading your Claris FileMaker software.

Download
Download the FileMaker Mailchimp Integration File
Please complete the form below to download your FREE FileMaker file.
FileMaker Experience *
Terms of Use *
OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This file is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free file, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime.
Kiyan Allaei thumbnail
Kiyan Allaei

Kiyan is an outgoing and energetic certified FileMaker developer whose technical passion is the world of databases. His collaborative and positive attitude creates a natural draw for clients seeking solutions to meet their database needs.

FileMaker 18 Certified Developer
FileMaker 17 Certified Developer
FileMaker 16 Certified Developer
FileMaker 15 Certified Developer
FileMaker 14 Certified Developer
FileMaker 13 Certified Developer
FileMaker 12 Certified Developer
FileMaker 11 Certified Developer
"We were actually able to add more features than we thought would be possible within our budget. We always experienced a ‘can do’ attitude and DB Services was incredibly patient and easy to work with."
Courtney Hartman
Art Director
"The new FileMaker custom website interface is very user-friendly and easy to follow for our clients. In addition, it is much faster than the old Instant Web Publishing (IWP) interface. Thank you and all the others who have helped us out at DB Services. I am very grateful for the excellent service you provide us. Its nice to know we can call you for help if we have an issue."
Wayne Capek
President
"We needed a solution that would simplify the administration of our responsibilities under our contract with the State of Indiana. We have seen a dramatic increase across the state in the number of potential foster and adoptive parents that have begun the preparation and training process. This increase has resulted in a significant opportunity for children available for adoption. That’s a big win for everyone! And it’s all because we can refer potential parents to the proper state contacts efficiently and quickly."
Chris Morrison
Executive Director
"Thank you for all of your expertise and valuable help. I am so grateful to have found DB Services."
Linda Findlay
Owner
"Thank you for our new database system. We transitioned from a carbon copy paper based system to a digital database. The software has saved us time and money. We used to archive all our jobs in cabinets, now we can look up a job in seconds from anywhere. The software allows us to easily email estimates to our customers in pdf format. In a year there was a return on investment just from eliminating the purchasing of our carbon forms."
Todd Cartmel
Owner
"The new system allows us to create and track jobs for customers along with inventory, something we had been doing with separate word and spreadsheet files. Because it’s now so intuitive, new staff members are able to begin using the database immediately without our usual training session and ‘cheat sheets’ for getting around within the file."
Tom Andrews
President