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 level
Column hashing
Re-sync		Connection level and table level. A parent table re-sync includes all associated child tables.
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_CHAT
INTERACTION_EMAIL
INTERACTION_MEETING
INTERACTION_CALL
ORGANIZATION_WITH_INTERACTION
PERSON_WITH_INTERACTION
RELATIONSHIP_STRENGTH
REMINDER

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.

Explore Affinity schema ERD

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.