Affinity is an online customer relationship management tool focused on contacts and profile creation automation, easy dealing, and pipeline management.

Data integration: Skyvia supports importing data to and from Affinity, exporting Affinity data to CSV files, and replicating Affinity data to relational databases.

Backup: Skyvia Backup does not support Affinity.

Query: Skyvia Query supports Affinity.

Establishing Connection

To establish a connection to Affinity in Skyvia you have to enter the API key. Follow the instructions to obtain the API Key.

affinity connection

Connector Specifics

Skyvia has the following limitations for Affinity:

Object Peculiarities

  • The RelationshipStrengths table is read-only. To retrieve data from this table, you must use filter by the ExternalId.
  • When importing to the Reminders table, you have to map one of the following fields in addition to the required fields: Person_Id, Organization_Id or Opportunity_Id.

Incremental Replication and Synchronization

Replication with Incremental Updates is supported for the following objects: EntityFiles, ListEntries, Notes, Reminders. These tables have only the CreatedDate field and do not have the UpdatedDate. It means that the Incremental Replication will consider only the new records.

Skyvia does not support Synchronization for Affinity.

DML Operations Support

Skyvia supports DML operations for such Affinity objects:

Operation Object
INSERT, UPDATE, DELETE ListEntryFieldValues, Notes, Opportunities, OpportunityFieldValues, OrganizationFieldValues, Organizations, PersonFieldValues, Persons, Reminders, WebhookSubscriptions
INSERT, DELETE Fields, ListEntries

Supported Actions

Skyvia supports all the common actions for Affinity.