Question 1

How does Affinity's free text land in MySQL?

Accepted Answer

Strings map to LONGTEXT regardless of their declared length, so a long note is neither truncated nor pushing the row toward MySQL's roughly 65KB inline limit. Created tables use utf8mb4, which matters more here than on most sources, because notes and person names in a relationship CRM routinely contain accented characters and emoji.

Question 2

Which Affinity objects become MySQL tables?

Accepted Answer

People and organizations, every person, organization and opportunity list as its own table, notes, and then calls, emails and meetings. There is deliberately no standalone opportunity source, so opportunities arrive through their lists rather than on their own.

Question 3

Which schemas are full pulls?

Accepted Answer

By default yes for people, organizations and list projections, which are full pulls. Enabling Affinity webhook updates switches the supported schemas to event driven incremental ingestion instead. Calls, emails, meetings and notes also have timestamp based incremental readers, so what you get depends on what you selected.

Question 4

Will a deleted Affinity record disappear?

Accepted Answer

Only with webhooks enabled. With them on, deletes for people, organizations, opportunities, list memberships and notes are all processed, and an organization merge deletes the record that was merged away. With them off, nothing signals a deletion at all, so a periodic full ETL run remains the safety net.

Question 5

Why did my sync suddenly take twice as long?

Accepted Answer

Almost always because interaction date fields were selected. Those roughly double both the API calls and the runtime, since Affinity has to be queried about interactions separately from the records themselves. Leaving off last email and last meeting dates is the cheapest performance win available on this pairing.

Sync Affinity CRM to MySQL

Sync Affinity CRM to MySQL with Polytomic

Every list a table

Notes survive intact

Webhooks carry deletes

Or sync MySQL to Affinity CRM

Trusted by businesses worldwide

Step-by-step integration guide

Connect Affinity CRM in Polytomic

Connect MySQL in Polytomic

Create a sync between Affinity CRM and MySQL

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect Affinity CRM with MySQL?