Drip
Drip is an email marketing automation platform designed for e-commerce businesses.
Drip integration replicates data using the Drip REST API.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
To retrieve your API token:
- Log into your Drip account.
- Navigate to Settings > User Settings > User Info.
- Copy and paste your API token into a secured file.
Creating the connection
有关更多信息，请参阅连接到 SaaS 应用程序。
- 填写所需的连接属性。
在连接名称中提供连接的名称。
选择打开连接元数据以定义创建连接时的元数据。
单击创建。
| Setting | Description |
|---|---|
| Data gateway | 如果您的用例需要，请选择一个 数据移动网关。 信息注释 此字段不适用于 Qlik Talend Cloud Starter 订阅，因为它不支持 数据移动网关。如果您有另一个订阅层并且不想使用 数据移动网关，请选择无。 有关 数据移动网关 的优势和需要它的用例的信息，请参阅Qlik 数据网关 - 数据移动。 |
| Start Date | 按格式 |
| API Token | API token. |
Schema
Depending on your destination, table and column names may not appear as they are outlined below.
accounts
Replication Method | Full Table |
Primary Key | id |
| Useful links |
conversions
Replication Method | Full Table |
Primary Key | id account_id |
| Useful links |
custom_field_identifiers
Replication Method | Full Table |
Primary Key | custom_field_id account_id |
| Useful links |
email_series_campaigns
Replication Method | Full Table |
Primary Key | id account_id |
| Useful links |
email_series_subscriber_active
Replication Method | Full Table |
Primary Key | id account_id campaign_id |
| Useful links |
email_series_subscriber_removed
Replication Method | Full Table |
Primary Key | id account_id campaign_id |
| Useful links |
email_series_subscriber_unsubscribed
Replication Method | Full Table |
Primary Key | id account_id campaign_id |
| Useful links |
event_actions
Replication Method | Full Table |
Primary Key | event_action account_id |
| Useful links |
forms
Replication Method | Full Table |
Primary Key | id account_id |
| Useful links |
people
Replication Method | Full Table |
Primary Key | id account_id |
| Useful links |
single_email_campaigns
Replication Method | Full Table |
Primary Key | id account_id |
| Useful links |
tags
Replication Method | Full Table |
Primary Key | tag_id account_id |
| Useful links |
users
Replication Method | Full Table |
Primary Key | |
| Useful links |
workflows
Replication Method | Full Table |
Primary Key | id account_id |
| Useful links |
workflow_triggers
Replication Method | Full Table |
Primary Key | id account_id workflow_id |
| Useful links |