Hi,
I’m trying to figure out how to use AC api to automaticaly create new contact every time when new row is added to external MySQL database.
I found out about Database Sync but if I understand it you have to click manually to import new contacts from database.
I also found contact_sync but I cant figure out how to connect it with MySQL database.
1 Like
Hey @test01938,
That is correct, the mysql sync was designed to import contacts one time at first, not on an ongoing basis or to keep a mysql db and ActiveCampaign synced.
I think you are on the right track with contact_sync API call, but you will need a developer.
What you would want to do is fire a contact_sync call whenever a contact is updated in your application, this would create a 1-way sync with your database.
To create a two-way sync you would then use the ActiveCampaign webhooks to update your own application/mysql database.
If you don’t have access to a developer, you could probably achieve this using a pair of Zapier zaps, using the Zapier mysql integration.
1 Like
I looked into the Zapier option and it seems like the only way to trigger the sync is when a column changes or something of the like. I’m trying to find a solution to auto sync every 24 hours. Can webhooks accomplish that?
Hey @farmergirlmeats300,
You want to two-way sync every 24 hours? Is there a reason why you wouldn’t want to keep them synced in near real time?
Now we’re wandering into new territory for me, but you might be able to create a multiple-step Zap that uses a scheduled trigger?
To integrate Active Campaign with MySQL take a look at Skyvia. It is a no coding web service with flexible scheduling options and powerful integration features. You can find more on AC Marketplace.
2 Likes
Yea I was going to suggest Skyvia as well.
1 Like