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 specify the ExternalId value.
  • 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.

  • Synchronization is not supported for Affinity.

DML Operations

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.