Integration Specifications
This article will help you learn about how Daasity replicates data from Sailthru, limitations to the data we can extract and where the data is stored in the Sailthru schema
Integration Overview
Sailthru is an email marketing platform that allows businesses to send outbound emails, build and personalize email campaigns and manage email lists to acquire, grow and retain customers.
Integration Availability
This integration is available for:
Enterprise
API Endpoints
The Daasity Sailthru extractor is built based on this Sailthru API documentation. The following endpoints are used by Daasity to replicate data from Sailthru:
S3 Feed
The Daasity Sailthru extractor is built based on this Sailthru Connect documentation. The following is used by Daasity to replicate data from Sailthru:
Daasity provides the option to export Mobile Events via the Mobile Event Stream in this integration
Read more about the Sailthru Mobile Integration to learn how Daasity extracts Mobile Event Stream data
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Sailthru integration illustrating the different tables and keys to join across tables.
Sailthru Schema
The Daasity Sailthru extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint or S3 feed to the table based on the mapping logic outlined in each table.
Daasity Sailthru V1 Integration:
Settings
Endpoint: Settings
Update Method: UPSERT
Table Name: [
sailthru.settings]
Clients
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.clients]
Lists
Endpoint: List
Update Method: UPSERT
Table Name: [
sailthru.lists]
Profiles
Endpoint: Data Exporter
Update Method: UPSERT
Table Name: [
sailthru.profiles]
Profile Lists
Endpoint: Data Exporter
Update Method: UPSERT
Table Name: [
sailthru.profile_lists]
Profile List Removals
Endpoint: Data Exporter
Update Method: UPSERT
Table Name: [
sailthru.profile_list_removals]
Profile Vars
Endpoint: Data Exporter
Update Method: UPSERT
Table Name: [
sailthru.profile_vars]
Templates
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.templates]
Campaigns
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.campaigns]
Campaign Sends
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.campaign_sends]
Campaign Bounces
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.campaign_bounces]
Campaign Opens
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.campaign_opens]
Campaign Clicks
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.campaign_clicks]
Campaign Unsubscribes
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.campaign_unsubscribes]
Flows
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.flows]
Triggered Sends
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.triggered_sends]
Triggered Bounces
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.triggered_bounces]
Triggered Opens
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.triggered_opens]
Triggered Clicks
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.triggered_clicks]
Triggered Unsubscribes
Endpoint: Event Stream
Update Method: UPSERT
Table Name: [
sailthru.triggered_unsubscribes]
Last updated