Affinity Lite
Affinity is a CRM platform.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | FIELD, FILE, GLOBAL_ORGANIZATION_FIELD, LIST, LIST_ENTRY, NOTE, OPPORTUNITY, OPPORTUNITY_FIELD_VALUE, ORGANIZATION_FIELD_VALUE, ORGANIZATION_WITHOUT_INTERACTION, PERSON_FIELD_VALUE, and PERSON_WITHOUT_INTERACTION tables. | |
| History mode | ||
| Custom data | ||
| Data blocking | ||
| Column hashing | ||
| Re-sync | ||
| Row filtering | ||
| API configurable | API configuration | |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step Affinity setup guide to connect Affinity with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
INTERACTION_CHATINTERACTION_EMAILINTERACTION_MEETINGINTERACTION_CALLORGANIZATION_WITH_INTERACTIONPERSON_WITH_INTERACTIONRELATIONSHIP_STRENGTHREMINDER
We sync ORGANIZATION_WITHOUT_INTERACTION and PERSON_WITHOUT_INTERACTION tables only once a week to avoid long sync durations.
Schema information
This schema applies to all Affinity connections.
Limitations
Affinity's Professional plan has an API rate limit of 900 requests per minute for each user. To make sure we sync all your data into your destination, we recommend that you upgrade to the Enterprise plan.
Affinity instances allow a maximum of three webhook subscriptions. If all three slots are in use, Fivetran cannot register its webhook. To resolve this, you must free up a webhook slot. You may have the following issues during data syncs if the webhook is not registered:
We cannot capture deletes for the
ORGANIZATION_WITH_INTERACTIONandPERSON_WITH_INTERACTIONtables and their child tables.We cannot capture new records, updates, and deletes for the
LIST_ENTRY,OPPORTUNITY_FIELD_VALUE,ORGANIZATION_FIELD_VALUE, andPERSON_FIELD_VALUEtables.