Mailshake ON THIS PAGE
Mailshake is a sales engagement platform designed to streamline and automate cold outreach efforts.
See the
Schema section for a list of objects available for replication.
Feature snapshot
A high-level look at this connector, including useful links, and supported features.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Information note Make sure that the account you use has read access to the tables you want to fetch.
To generate the API key:
Log into your Mailshake account. Go to Extensions > API . Click Create API Key to create an API key. Your API key is displayed on the page.
If your account already has an API key, it is displayed in the Your Access section of the page.
Fill in your API key in the Connection settings page. Creating the connection For more information, see Connecting to SaaS applications
Fill in the required connection properties. Provide a name for the connection in Connection name .
Select Open connection metadata to define metadata for the connection when it has been created.
Click Create .
Connection settings Setting Description Data gateway
Select a Data Movement gateway if required by your use case.
Information note This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway . If you have another subscription tier and do not want to use Data Movement gateway , select None .
For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement
Start Date Enter the date, in the format MM/DD/YYYY, from which the data must be replicated from your source to your target.
API Key API key.
Information note Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 1.
Depending on your destination, table and column names may not appear as they are outlined below.
campaigns
The campaigns table contains info about your team’s campaigns.
campaigns table foreign keys Join campaigns with on clicks campaigns.id = clicks.campaign.id campaigns.messages.id = clicks.campaign.id campaigns.messages.id = clicks.parent.message.id leads campaigns.id = leads.campaign.id campaigns.messages.id = leads.campaign.id opens campaigns.id = opens.campaign.id campaigns.messages.id = opens.campaign.id campaigns.messages.id = opens.parent.message.id recipients campaigns.id = recipients.campaignId campaigns.messages.id = recipients.campaignId replies campaigns.id = replies.campaign.id campaigns.messages.id = replies.campaign.id campaigns.messages.id = replies.parent.message.id sent_messages campaigns.id = sent_messages.campaign.id campaigns.messages.id = sent_messages.campaign.id campaigns.messages.id = sent_messages.message.id senders campaigns.sender.id = senders.id
campaigns table schema
actionDate
DATE-TIME
archived
BOOLEAN
created
DATE-TIME
endedAt
DATE-TIME
id
INTEGER
isPaused
BOOLEAN
messages
ARRAY
This is a nested data structure:
campaignId: INTEGER id: INTEGER isPaused: BOOLEAN object: STRING replyToID: INTEGER subject: STRING type: STRING
object
STRING
sender
OBJECT
This is a nested data structure:
created: DATE-TIME emailAddress: STRING fromName: STRING id: STRING object: STRING
title
STRING
url
STRING
clicks
The clicks table contains info about recent click activity.
clicks table foreign keys Join clicks with on campaigns clicks.campaign.id = campaigns.id clicks.campaign.id = campaigns.messages.id clicks.parent.message.id = campaigns.messages.id leads clicks.campaign.id = leads.campaign.id clicks.recipient.id = leads.recipient.id opens clicks.campaign.id = opens.campaign.id clicks.parent.message.id = opens.parent.message.id clicks.recipient.id = opens.recipient.id recipients clicks.campaign.id = recipients.campaignId clicks.recipient.id = recipients.id replies clicks.campaign.id = replies.campaign.id clicks.parent.message.id = replies.parent.message.id clicks.recipient.id = replies.parent.message.id sent_messages clicks.campaign.id = sent_messages.campaign.id clicks.parent.message.id = sent_messages.message.id clicks.recipient.id = sent_messages.recipient.id
clicks table schema
actionDate
DATE-TIME
campaign
OBJECT
This is a nested data structure:
created: DATE-TIME id: INTEGER object: STRING title: STRING
id
INTEGER
isDuplicate
BOOLEAN
link
STRING
object
STRING
parent
OBJECT
This is a nested data structure:
id: INTEGER message: OBJECT, which is also a nested data structure.
id: INTEGER object: STRING subject: STRING type: STRING object: STRING type: STRING
recipient
OBJECT
This is a nested data structure:
action: STRING created: DATE-TIME emailAddress: STRING fields: OBJECT, which is also a nested data structure. first: STRING fullName: STRING id: INTEGER isPaused: BOOLEAN last: STRING object: STRING
leads
The leads table contains info about the leads in your Mailshake account.
leads table foreign keys Join leads with on campaigns leads.campaign.id = campaigns.id leads.campaign.id = campaigns.messages.id clicks leads.campaign.id = clicks.campaign.id leads.recipient.id = clicks.recipient.id opens leads.campaign.id = opens.campaign.id leads.recipient.id = opens.recipient.id recipients leads.campaign.id = recipients.campaignId leads.recipient.id = recipients.id replies leads.campaign.id = replies.campaign.id leads.recipient.id = replies.parent.message.id sent_messages leads.campaign.id = sent_messages.campaign.id leads.recipient.id = sent_messages.recipient.id team_members leads.assignedTo.id = team_members.id
leads table schema
assignedTo
OBJECT
This is a nested data structure:
emailAddress: STRING first: STRING fullName: STRING id: INTEGER last: STRING object: STRING
campaign
OBJECT
This is a nested data structure:
created: DATE-TIME id: INTEGER object: STRING title: STRING
created
DATE-TIME
id
INTEGER
lastStatusChangeDate
DATE-TIME
object
STRING
openedDate
DATE-TIME
recipient
OBJECT
This is a nested data structure:
created: DATE-TIME emailAddress: STRING fields: OBJECT, which is also a nested data structure. first: STRING fullName: STRING id: INTEGER last: STRING object: STRING
status
STRING
opens
The opens table contains info about recently opened emails.
opens table foreign keys Join opens with on campaigns opens.campaign.id = campaigns.id opens.campaign.id = campaigns.messages.id opens.parent.message.id = campaigns.messages.id clicks opens.campaign.id = clicks.campaign.id opens.parent.message.id = clicks.parent.message.id opens.recipient.id = clicks.recipient.id leads opens.campaign.id = leads.campaign.id opens.recipient.id = leads.recipient.id recipients opens.campaign.id = recipients.campaignId opens.recipient.id = recipients.id replies opens.campaign.id = replies.campaign.id opens.parent.message.id = replies.parent.message.id opens.recipient.id = replies.parent.message.id sent_messages opens.campaign.id = sent_messages.campaign.id opens.parent.message.id = sent_messages.message.id opens.recipient.id = sent_messages.recipient.id
opens table schema
actionDate
DATE-TIME
campaign
OBJECT
This is a nested data structure:
created: DATE-TIME id: INTEGER object: STRING title: STRING
id
INTEGER
isDuplicate
BOOLEAN
object
STRING
parent
OBJECT
This is a nested data structure:
id: INTEGER message: OBJECT, which is also a nested data structure.
id: INTEGER object: STRING subject: STRING type: STRING object: STRING type: STRING
recipient
OBJECT
This is a nested data structure:
action: STRING created: DATE-TIME emailAddress: STRING fields: OBJECT, which is also a nested data structure. first: STRING fullName: STRING id: INTEGER isPaused: BOOLEAN last: STRING object: STRING
recipients
The recipients table contains info about the recipients in a campaign.
recipients table foreign keys Join recipients with on campaigns recipients.campaignId = campaigns.id recipients.campaignId = campaigns.messages.id clicks recipients.campaignId = clicks.campaign.id recipients.id = clicks.recipient.id leads recipients.campaignId = leads.campaign.id recipients.id = leads.recipient.id opens recipients.campaignId = opens.campaign.id recipients.id = opens.recipient.id replies recipients.campaignId = replies.campaign.id recipients.id = replies.parent.message.id sent_messages recipients.campaignId = sent_messages.campaign.id recipients.id = sent_messages.recipient.id
recipients table schema
action
STRING
campaignId
INTEGER
created
DATE-TIME
emailAddress
STRING
fields
OBJECT
This is a nested data structure.
first
STRING
fullName
STRING
id
INTEGER
last
STRING
object
STRING
replies
The replies table contains info about recent replies to your emails.
replies table foreign keys Join replies with on campaigns replies.campaign.id = campaigns.id replies.campaign.id = campaigns.messages.id replies.parent.message.id = campaigns.messages.id clicks replies.campaign.id = clicks.campaign.id replies.parent.message.id = clicks.parent.message.id replies.parent.message.id = clicks.recipient.id leads replies.campaign.id = leads.campaign.id replies.parent.message.id = leads.recipient.id opens replies.campaign.id = opens.campaign.id replies.parent.message.id = opens.parent.message.id replies.parent.message.id = opens.recipient.id recipients replies.campaign.id = recipients.campaignId replies.parent.message.id = recipients.id sent_messages replies.campaign.id = sent_messages.campaign.id replies.parent.message.id = sent_messages.message.id replies.parent.message.id = sent_messages.recipient.id
replies table schema
actionDate
DATE-TIME
body
STRING
campaign
OBJECT
This is a nested data structure:
created: DATE-TIME id: INTEGER object: STRING title: STRING
externalConversationID
STRING
externalID
STRING
externalRawMessageID
STRING
id
INTEGER
object
STRING
parent
OBJECT
This is a nested data structure:
id: INTEGER message: OBJECT, which is also a nested data structure.
id: INTEGER object: STRING subject: STRING type: STRING object: STRING type: STRING
plainTextBody
STRING
rawBody
STRING
recipient
OBJECT
This is a nested data structure:
action: STRING created: DATE-TIME emailAddress: STRING fields: OBJECT, which is also a nested data structure. first: STRING fullName: STRING id: INTEGER isPaused: BOOLEAN last: STRING object: STRING
subject
STRING
type
STRING
senders
The senders table contains info about your team’s senders.
senders table foreign keys Join senders with on campaigns senders.id = campaigns.sender.id
senders table schema
created
DATE-TIME
emailAddress
STRING
fromName
STRING
id
STRING
object
STRING
offerType
STRING
sent_messages
The sent_messages table contains info about recently sent emails.
sent_messages table foreign keys Join sent_messages with on campaigns sent_messages.campaign.id = campaigns.id sent_messages.campaign.id = campaigns.messages.id sent_messages.message.id = campaigns.messages.id clicks sent_messages.campaign.id = clicks.campaign.id sent_messages.message.id = clicks.parent.message.id sent_messages.recipient.id = clicks.recipient.id leads sent_messages.campaign.id = leads.campaign.id sent_messages.recipient.id = leads.recipient.id opens sent_messages.campaign.id = opens.campaign.id sent_messages.message.id = opens.parent.message.id sent_messages.recipient.id = opens.recipient.id recipients sent_messages.campaign.id = recipients.campaignId sent_messages.recipient.id = recipients.id replies sent_messages.campaign.id = replies.campaign.id sent_messages.message.id = replies.parent.message.id sent_messages.recipient.id = replies.parent.message.id
sent_messages table schema
actionDate
DATE-TIME
body
STRING
campaign
OBJECT
This is a nested data structure:
created: DATE-TIME id: INTEGER object: STRING title: STRING
externalConversationID
STRING
externalID
STRING
externalRawMessageID
STRING
from
OBJECT
This is a nested data structure:
address: STRING first: STRING fullName: STRING last: STRING object: STRING
id
INTEGER
message
OBJECT
This is a nested data structure:
id: INTEGER object: STRING subject: STRING type: STRING
object
STRING
plainTextBody
STRING
rawBody
STRING
recipient
OBJECT
This is a nested data structure:
action: STRING created: DATE-TIME emailAddress: STRING fields: OBJECT, which is also a nested data structure. first: STRING fullName: STRING id: INTEGER isPaused: BOOLEAN last: STRING object: STRING
subject
STRING
to
ARRAY
This is a nested data structure:
address: STRING first: STRING fullName: STRING last: STRING object: STRING
type
STRING
team_members
The team_members table contains info about the individual members of your team.
team_members table foreign keys Join team_members with on leads team_members.id = leads.assignedTo.id
team_members table schema
emailAddress
STRING
first
STRING
fullName
STRING
id
INTEGER
isDisabled
BOOLEAN
isTeamAdmin
BOOLEAN
last
STRING
object
STRING
teamBlockedDate
DATE-TIME
teamID
INTEGER
teamName
BOOLEAN
