Question 1

What can I write to?

Accepted Answer

People, organizations, notes, and person, organization and opportunity lists. Opportunities are written through an opportunity list rather than directly. People, organizations and opportunities all support create, update and upsert. Notes are create only, so they append and never update.

Question 2

What can I match on?

Accepted Answer

People match on Affinity person ID or email address. Organizations on organization ID, exact name, or domain, and where your source holds an array of domains you can match all of them or only the first. Opportunities on opportunity ID or exact name. Notes have no identity at all, because they only ever append.

Question 3

Why is this sync slower than my others?

Accepted Answer

Because Affinity's API is expensive in a particular way: custom and list values are often written as individual field value requests rather than one call per record. Polytomic compensates with twenty five record jobs, at most ten running concurrently, throttled to seven hundred and fifty requests a minute. That pacing is deliberate rather than a stall.

Question 4

Can a sync exhaust our Affinity quota?

Accepted Answer

Yes, and it is worth planning for. Affinity enforces user level and organization level monthly quotas, and an exhausted monthly quota stops the reverse ETL sync rather than merely slowing it down. If you are writing many custom fields, check the quota before scheduling frequent runs.

Question 5

Why can I not write a particular field?

Accepted Answer

Most likely because it is enriched. Affinity's enrichment provider fields and interaction date fields are read only, so they never appear as write targets. Separately, some fields such as LinkedIn Profile are only writable in one field mode, which you can set with a per field write mode override on the mapping.

Sync PostgreSQL to Affinity CRM

Sync PostgreSQL to Affinity CRM with Polytomic

People, orgs and lists

Custom and list fields

Throttled by design

Or sync Affinity CRM to PostgreSQL

Trusted by businesses worldwide

Step-by-step integration guide

Connect PostgreSQL in Polytomic

Connect Affinity CRM in Polytomic

Create a sync between PostgreSQL and Affinity CRM

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 PostgreSQL with Affinity CRM?