Customer.io
Customer.io ETL connector for data replication
Customer.io
Customer.io ETL connector for data replication
Snapshot
Features |
Details |
Release Status |
Released |
Source API Version |
v2 |
Table Selection |
Yes |
Column Selection |
Yes |
Edit Integration |
Yes |
Replication Type Selection |
No |
Authentication Parameters |
customerio site id customerio secret apikey |
Replication Type |
Key Based Incremental |
Replication Key |
Date |
Suggested Replication Frequency |
24 hrs |
| ##Tables/Apis supported | |
Customers |
Segements |
Newsletters |
Campaigns |
Integrate Customerio with Daton
- Signin to Daton
- Select Customerio from Integrations page
- Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- Provide your site id and secret apikey from your customerio account to authorize Daton to periodically extract data from customerio.
- Post successful authentication you will be prompted to choose from the list of available tables
- Then select all required fields for each table
- Submit the integration
Workflow:
- Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- Users would be able to edit/pause/re-activate/delete integration anytime
- Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Tables
Customers
Purpose: Returns all the customers associated with the account.
Source-Api documentation https://customer.io/docs/api/
Fields
Name |
Target Datatype |
email |
String |
id |
String |
Segments
Purpose: Retrieving segments via the API returns information regarding your Customer.io segments. Source-Api documentation https://customer.io/docs/api/
Fields
Name |
Target Datatype |
id |
Numeric |
deduplicate_id |
String |
name |
String |
description |
String |
state |
String |
progress |
String |
type |
String |
Newsletters
Purpose:Retrieving newsletters via the API returns information regarding your Customer.io newsletters. Source-Api documentation https://customer.io/docs/api/
Fields
Name |
Target Datatype |
id |
Numeric |
deduplicate_id |
String |
msg_template_ids |
String |
content_ids |
String |
name |
String |
sent_at |
String |
created |
Numeric |
updated |
Numeric |
Campaigns
purpose:Retrieving campaigns via the API returns information regarding your Customer.io campaigns. Source_Api documentation https://customer.io/docs/api/
Fields
Name |
Target Datatype |
id |
Numeric |
deduplicate_id |
String |
name |
String |
type |
String |
created |
Numeric |
updated |
Numeric |
active |
Boolean |
actions |
Record |
msg_templates |
Record |
first_started |
Numeric |
created_by |
String |
tags |
String |
