Mailshake PÅ DEN HÄR SIDAN
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.
Ögonblicksbild av funktion En översiktlig beskrivning av denna koppling, inklusive användbara länkar och funktioner som stöds.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Anteckning om information Kontrollera att kontot du använder har läsåtkomst till de tabeller som du vill hämta.
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 Mer information finns i Koppla till SaaS-program
Ange de kopplingsegenskaper som krävs. Ange ett namn på kopplingen i Kopplingsnamn .
Välj Öppna kopplingsmetadata för att definiera metadata för kopplingen när den har skapats.
Klicka på Skapa .
Connection settings Setting Description Data gateway
Välj en Gateway för dataflytt om det krävs för ditt användningsfall.
Anteckning om information Detta fält är inte tillgängligt med Qlik Talend Cloud Starter -prenumerationen eftersom den inte stöder Gateway för dataflytt . Om du har en annan prenumerationsnivå och inte vill använda Gateway för dataflytt väljer du Inget .
Information om fördelarna med Gateway för dataflytt och användningsfall som kräver det finns i Qlik Data Gateway – dataflytt
Start Date Ange det datum, i formatet MM/DD/YYYY, från vilket data måste replikeras från din källa till ditt mål.
API Key API key.
Anteckning om information 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
