Mailshake integration summary

Stitch’s Mailshake integration replicates data using the . Refer to the Schema section for a list of objects available for replication.

Mailshake feature snapshot

A high-level look at Stitch's Mailshake (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Beta

 Supported by

Singer Community
Stitch plan

Standard

 API availability

Available
Singer GitHub repository

singer-io/tap-mailshake
REPLICATION SETTINGS
Anchor Scheduling

Supported

 Advanced Scheduling

Supported
Table-level reset

Unsupported

 Configurable Replication Methods

Unsupported
DATA SELECTION
Table selection

Supported

 Column selection

Supported
Select all

Supported
TRANSPARENCY
Extraction Logs

Supported

 Loading Reports

Supported

Connecting Mailshake

Step 1: Retrieve your Mailshake API key

  1. Sign into your Mailshake account.
  2. Click Extensions > API.

  3. If your account already has an API key, it will display in the Your Access section of the page.

    Otherwise, click the Create API Key button. Your API key will display on the page.

Keep this page open - you’ll need it to complete the next step.

Step 2: Add Mailshake as a Stitch data source

  1. Sign into your Stitch account.

  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Mailshake icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Mailshake” would create a schema called stitch_mailshake in the destination. Note: Schema names cannot be changed after you save the integration.

  5. In the API Key field, paste the Mailshake API key you retrieved in Step 1.

Step 3: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Mailshake integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Mailshake’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 4: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Mailshake integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 5: Set objects to replicate

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Mailshake integrations, you can select:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.

  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.

  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.

  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Mailshake, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Mailshake table reference

campaigns

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

created
Primary Key :

id

 API endpoint :

List a team’s campaigns

The campaigns table contains info about your team’s campaigns.

campaigns table schema

id
INTEGER

Reference:

created
DATE-TIME

actionDate
DATE-TIME

archived
BOOLEAN

endedAt
DATE-TIME

isPaused
BOOLEAN

messages
ARRAY

Click to expand messages

campaignId
INTEGER

Reference:

id
INTEGER

Reference:

isPaused
BOOLEAN

object
STRING

replyToID
INTEGER

subject
STRING

type
STRING

campaigns (table), messages (attribute)

object
STRING

sender
OBJECT

Click to expand sender

created
DATE-TIME

emailAddress
STRING

fromName
STRING

id
STRING

Reference:

object
STRING

campaigns (table), sender (attribute)

title
STRING

url
URI

clicks

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

actionDate
Primary Key :

id

 API endpoint :

Get click activity

The clicks table contains info about recent click activity.

clicks table schema

id
INTEGER

actionDate
DATE-TIME

campaign
OBJECT

Click to expand campaign

created
DATE-TIME

id
INTEGER

Reference:

object
STRING

title
STRING

clicks (table), campaign (attribute)

isDuplicate
BOOLEAN

link
URI

object
STRING

parent
OBJECT

Click to expand parent

id
INTEGER

message
OBJECT

Click to expand message

id
INTEGER

Reference:

object
STRING

subject
STRING

type
STRING

clicks (table), message (attribute)

object
STRING

type
STRING

clicks (table), parent (attribute)

recipient
OBJECT

Click to expand recipient

action
STRING

created
DATE-TIME

emailAddress
STRING

fields
OBJECT

Click to expand fields
clicks (table), fields (attribute)

first
STRING

fullName
STRING

id
INTEGER

Reference:

isPaused
BOOLEAN

last
STRING

object
STRING

clicks (table), recipient (attribute)

leads

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

created
Primary Key :

id

 API endpoint :

List leads

The leads table contains info about the leads in your Mailshake account.

leads table schema

id
INTEGER

created
DATE-TIME

assignedTo
OBJECT

Click to expand assignedTo

emailAddress
STRING

first
STRING

fullName
STRING

id
INTEGER

Reference:

last
STRING

object
STRING

leads (table), assignedTo (attribute)

campaign
OBJECT

Click to expand campaign

created
DATE-TIME

id
INTEGER

Reference:

object
STRING

title
STRING

leads (table), campaign (attribute)

lastStatusChangeDate
DATE-TIME

object
STRING

openedDate
DATE-TIME

recipient
OBJECT

Click to expand recipient

created
DATE-TIME

emailAddress
STRING

fields
OBJECT

first
STRING

fullName
STRING

id
INTEGER

Reference:

last
STRING

object
STRING

leads (table), recipient (attribute)

status
STRING

opens

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

actionDate
Primary Key :

id

 API endpoint :

Get opened activity

The opens table contains info about recently opened emails.

opens table schema

id
INTEGER

actionDate
DATE-TIME

campaign
OBJECT

Click to expand campaign

created
DATE-TIME

id
INTEGER

Reference:

object
STRING

title
STRING

opens (table), campaign (attribute)

isDuplicate
BOOLEAN

object
STRING

parent
OBJECT

Click to expand parent

id
INTEGER

message
OBJECT

Click to expand message

id
INTEGER

Reference:

object
STRING

subject
STRING

type
STRING

opens (table), message (attribute)

object
STRING

type
STRING

opens (table), parent (attribute)

recipient
OBJECT

Click to expand recipient

action
STRING

created
DATE-TIME

emailAddress
STRING

fields
OBJECT

first
STRING

fullName
STRING

id
INTEGER

Reference:

isPaused
BOOLEAN

last
STRING

object
STRING

opens (table), recipient (attribute)

recipients

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

created
Primary Key :

id

 API endpoint :

List recipients

The recipients table contains info about the recipients in a campaign.

recipients table schema

id
INTEGER

Reference:

created
DATE-TIME

action
STRING

campaignId
INTEGER

Reference:

emailAddress
STRING

fields
OBJECT

Click to expand fields

VARIES
ANY

recipients (table), fields (attribute)

first
STRING

fullName
STRING

last
STRING

object
STRING

replies

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

actionDate
Primary Key :

id

 API endpoint :

Get reply activity

The replies table contains info about recent replies to your emails.

replies table schema

id
INTEGER

actionDate
DATE-TIME

body
STRING

campaign
OBJECT

Click to expand campaign

created
DATE-TIME

id
INTEGER

Reference:

object
STRING

title
STRING

replies (table), campaign (attribute)

externalConversationID
STRING

externalID
STRING

externalRawMessageID
STRING

object
STRING

parent
OBJECT

Click to expand parent

id
INTEGER

message
OBJECT

Click to expand message

id
INTEGER

Reference:

object
STRING

subject
STRING

type
STRING

replies (table), message (attribute)

object
STRING

type
STRING

replies (table), parent (attribute)

plainTextBody
STRING

rawBody
STRING

recipient
OBJECT

Click to expand recipient

action
STRING

created
DATE-TIME

emailAddress
STRING

fields
OBJECT

Click to expand fields
replies (table), fields (attribute)

first
STRING

fullName
STRING

id
INTEGER

Reference:

isPaused
BOOLEAN

last
STRING

object
STRING

replies (table), recipient (attribute)

subject
STRING

type
STRING

senders

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

created
Primary Key :

id

 API endpoint :

List all senders

The senders table contains info about your team’s senders.

senders table schema

id
STRING

Reference:

created
DATE-TIME

emailAddress
STRING

fromName
STRING

object
STRING

offerType
STRING

sent_messages

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

actionDate
Primary Key :

id

 API endpoint :

Get sent activity

The sent_messages table contains info about recently sent emails.

sent_messages table schema

id
INTEGER

actionDate
DATE-TIME

body
STRING

campaign
OBJECT

Click to expand campaign

created
DATE-TIME

id
INTEGER

Reference:

object
STRING

title
STRING

sent_messages (table), campaign (attribute)

externalConversationID
STRING

externalID
STRING

externalRawMessageID
STRING

from
OBJECT

Click to expand from

address
STRING

first
STRING

fullName
STRING

last
STRING

object
STRING

sent_messages (table), from (attribute)

message
OBJECT

Click to expand message

id
INTEGER

Reference:

object
STRING

subject
STRING

type
STRING

sent_messages (table), message (attribute)

object
STRING

plainTextBody
STRING

rawBody
STRING

recipient
OBJECT

Click to expand recipient

action
STRING

created
DATE-TIME

emailAddress
STRING

fields
OBJECT

first
STRING

fullName
STRING

id
INTEGER

Reference:

isPaused
BOOLEAN

last
STRING

object
STRING

sent_messages (table), recipient (attribute)

subject
STRING

to
ARRAY

Click to expand to

address
STRING

first
STRING

fullName
STRING

last
STRING

object
STRING

sent_messages (table), to (attribute)

type
STRING

team_members

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

teamID
Primary Key :

id

 API endpoint :

List team members

The team_members table contains info about the individual members of your team.

team_members table schema

id
INTEGER

Reference:

teamID
INTEGER

emailAddress
STRING

first
STRING

fullName
STRING

isDisabled
BOOLEAN

isTeamAdmin
BOOLEAN

last
STRING

object
STRING

teamBlockedDate
DATE-TIME

teamName
BOOLEAN

Related Troubleshooting
Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.