Kit

Kit (formerly ConvertKit) is the hub for audience growth, marketing automation, and digital products selling.

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

Backup: Skyvia Backup does not support Kit backup.

Query: Skyvia Query supports Kit.

Establishing Connection

Skyvia supports OAuth and API Key connections to Kit. To establish a connection to Kit in Skyvia, specify the Authentication Type and then either provide the API Key or sign in to Kit accordingly. Note that free Kit accounts don’t support OAuth authentication.

Getting Credentials

To obtain the API Key, you have to log in to Kit and perform the following actions:

  1. Click the username in the top right corner of the page and select Settings.
  2. In the left menu, select Developer.
  3. Under API v4, click Add a new key
  4. Specify the API key name, for example, Skyvia, and click Create API Key.
  5. Copy the API key and store it somewhere securely. Note that you won’t be able to see this key again.

API Key

Creating OAuth Connection

  1. Click Sign In with Kit.

    Kit OAuth connection

  2. Sign in to Kit.

    Sign in to Kit

  3. Select the business you want to connect to and grant access to Skyvia.

Creating API Key Connection

  1. In the Authentication Type list, select API Key.

    Kit API Key connection

  2. Paste the obtained value into the API Key box in Skyvia.

Additional Connection Parameters

Use Custom Fields

Select this checkbox to make Kit custom fields available in Skyvia.

Connector Specifics

Filtering Specifics

Kit API supports the following native filters:

Object Operator Field
Subscribers = EmailAddress

Use these filters to improve performance and save API calls. You can use filters with other fields or operators, but it may increase API call usage.

Object Peculiarities

Purchases

The Purchases object is available only for OAuth connections. The TranzactionId field is required for INSERT operation. Skyvia updates the record if the mapped TranzactionId value already exists in the object. If the TranzactionId value is absent in the object, Skyvia inserts the record.

Broadcasts

To import into the Broadcasts object, at least one of the fields Subject, Description or Content must be mapped.

TagSubscriptions, FormSubscriptions, and SequenceSubscriptions

Due to Kit API specifics, the Insert operation for the TagSubscriptions, FormSubscriptions, and SequenceSubscriptions objects works the following way. If a subscriber already exists for a particular tag, form or sequence, the Insert operation will update the existing record in the TagSubscriptions, FormSubscriptions, or SequenceSubscriptions.

Nested Objects

The following fields store complex structured data in JSON format.

Object Field
Purchases Products

Custom Fields

The following Kit objects support custom fields: Subscribers, CancelledSubscribers, TagSubscriptions, FormSubscriptions, SequenceSubscriptions. All custom fields are strings. The Subscribers and CancelledSubscribers custom fields support the UPDATE operation. The TagSubscriptions, FormSubscriptions, and SequenceSubscriptions object support the INSERT operation.

Custom fields in the TagSubscriptions, FormSubscriptions and SequenceSubscriptions objects have a Subscriber_* prefix in their names.

Incremental Replication and Synchronization support

Replication with Incremental Updates is supported for the following objects: Broadcasts, Forms, FormSubscriptions, Sequences, SequenceSubscriptions, Subscribers, SubscriberTags, Tags, TagSubscriptions.

Incremental Replication detects only the new records because all the objects contain only the CreatedDate field, and there is no UpdatedDate field, which is required for replicating the updated records.

Skyvia does not support Synchronization for Kit.

DML Operations Supports

Operation Object
INSERT, UPDATE, DELETE Broadcasts, CustomFields
INSERT, DELETE TagSubscriptions
INSERT, UPDATE Subscribers, Tags
INSERT FormSubscriptions, Purchases, SequenceSubscriptions

Stored Procedures

Skyvia represents part of the supported Kit features as stored procedures. You can call a 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.

UnsubscribeSubscriber

The following command unsubscribes an email address from all forms and sequences.

call UnsubscribeSubscriber(:Email)

DestroyWebhook

To delete webhook, use the command

call DestroyWebhook(:id)

CreateWebhook

The following command creates a webhook that will be called when a subscriber event occurs.

call CreateWebhook(:TargetUrl,:EventName,:EventFormId.:EventTagId,:EventSequenceId,:EventProductId,:EventInitiatorValue)

PARAMETER NAME DESCRIPTION
TargetUrl The URL that will receive subscriber data when the event is triggered. Required.
EventName Name of the event, for example subscriber.subscriber_activate. Required.
EventFormId Id of the corresponding form.
EventTagId Id of the corresponding tag.
EventSequenceId Id of the corresponding sequence.
EventProductId Id of the corresponding product.
EventInitiatorValue The corresponding link URL.

These are the available event types:

  • “subscriber.subscriber_activate”
  • “subscriber.subscriber_unsubscribe”
  • “subscriber.subscriber_bounce”
  • “subscriber.subscriber_complain”
  • “subscriber.form_subscribe”, required parameter :form_id [Integer]
  • “subscriber.course_subscribe”, required parameter :course_id [Integer]
  • “subscriber.course_complete”, required parameter :course_id [Integer]
  • “subscriber.link_click”, required parameter :initiator_value [String] as a link URL
  • “subscriber.product_purchase”, required parameter :product_id [Integer]
  • “subscriber.tag_add”, required parameter :tag_id [Integer]
  • “subscriber.tag_remove”, required parameter :tag_id [Integer]
  • “purchase.purchase_create”

Supported Actions

Skyvia supports all the common actions for Kit.