Close is an all-in-one high-performance CRM for growing sales teams and turning more leads into revenue.
Data integration: Skyvia supports importing data to and from Close, exporting Close data to CSV files, replicating Close data to relational databases, and synchronizing Close data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Close backup.
Query: Skyvia Query supports Close.
To create a connection to Close, you need to specify your API Key.
- Log in to Close and click Settings on the left.
Select API Keys.
- Click + New API Key.
- Enter the API Key name and click Create API Key.
- Copy the newly created API Key into the clipboard and click OK.
The API Key is available only once when you create it. Copy the displayed API Key and store it somewhere safe.
- Enter the obtained API Key.
Use the Test Connection button to make sure that the connection is successful, and then click Create Connection.
Incremental Replication and Synchronization
Skyvia supports Replication with Incremental Updates for all Close objects except: ConnectedAccounts, Groups, LeadStatuses, OpportunityAggregateValues, OpportunityStatuses, Pipelines, ReportActivityMetrics, SendAs, SequenceSchedules.
Skyvia supports Synchronization for such Close objects as ActivityCustomFields, ActivityEmails, ActivityNotes, ActivitySMS, ContactCustomFields, Contacts,CustomActivityInstances, CustomActivityTypes, EmailSequences, EmailTemplates, IntegrationLinks, LeadCustomFields, Leads, Opportunities, OpportunityCustomFields, Pipelines, Roles, SequenceSubscriptions, SharedCustomFields, SmartViews, Tasks.
DML Operations Support
Skyvia supports the following DML operations for Close objects:
|INSERT, UPDATE, DELETE||ActivityCustomFields, ActivityEmails, ActivityNotes, ActivitySMS, Contacts, ContactCustomFields, CustomActivityInstances, CustomActivityTypes, EmailSequences, EmailTemplates,Groups, IntegrationLinks, LeadCustomFields, Leads, LeadStatuses, Opportunities, OpportunityCustomFields, OpportunityStatuses, Pipelines, Roles, SharedCustomFields, SmartViews, Tasks|
|INSERT||BulkDelete, BulkEdit, BulkEmails, BulkSequenceSubscriptions, Export, SendAs|
|DELETE||ActivityEmailThreads, ActivityMeetings, ActivityTaskCompleted|
Part of the Close functionality is supported in Skyvia as stored procedures.
call AddUserToGroup (:group_id, :user_id) — adds user to a group.
call DeleteUserFromGroup (:group_id, :user_id)— removes user from a group.
You can use a call to the stored procedure, for example, as a text of the command in the ExecuteCommand action in a Target component of a Data Flow or in Query.
You can add Custom fields to Close objects. Information on custom fields added to a particular object (their Ids, names, types) is stored in the CustomFields object. The custom columns themselves and their values are stored in the objects with the corresponding object name and the -CustomFields suffix. For example, Such objects as LeadCustomFields, ContactCustomFields, OpportunityCustomFields, etc., store information about custom fields. Information about custom fields and their values are stored as JSON arrays.
Skyvia supports all the common actions for Close.