The Community is hosting an End of Summer sweepstakes! Participants must complete tasks to earn tickets that will enter them with a chance to win a free year of Constant Contact and other great prizes!*
*No Purchase Necessary. For Official Rules, visit here. Constant Contact’s End of Summer 2020 Sweepstakes ends on October, 20, 2020 at 11:50 PM EST.

Help with integration between Constant Contact & MYSQL database

Highlighted
New Member

Help with integration between Constant Contact & MYSQL database

Looking for a solution to eliminate need to update member contact info in both CC and our MYSQL database.  Is there an API or way to make 1 change and update both databases? I'm not techie so simple language is appreciated.  Thanks!

1 REPLY 1
Highlighted
Employee

mySQL & CTCT integration

While there is not a mechanism in place that would automatically update both your database and Constant Contact, however there are some methods that you could use to keep them in sync.


 


1. You could make your sign up form perform both operations, that way whenever a user signs up they are automatically placed into your database as well as your Constant Contact account. For more information on how to add a single contact using our API, please take a look at Creating a Contact.


 


2. Your other option would be to leverage our Searching for Contacts by Last Updated Date (Synchronizing Contacts). This will allow you to query only the updated contacts since a specified date. You can query by either a particular list type (active, do-not-mail, removed) or a particular list in your account. If you plan to keep your database in sync with our database, we recommend running this API periodically to ensure that your database is up-to-date and the number of contacts you need to deal with is not very large.

David J

Developer Portal

View API documentation, code samples, get your API key.

Visit Page

Constant Contact 2020 End of Summer Community Sweepstakes!

The Constant Contact User Community is hosting a sweepstakes. The more you participate, the more chances you have to win! Read on to learn more...

Read More
Featured