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 啟動器 訂閱，因為不支援 資料移動閘道。若您有另一個訂閱層級且不想使用 資料移動閘道，選取無。 如需關於 資料移動閘道 福利的資訊以及需要此項的使用案例，請參閱 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 |