Mailshake OP DEZE PAGINA
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.
Momentopname functie Een beknopt overzicht van deze connector, inclusief nuttige koppelingen en ondersteunde functies.
Functie/mogelijkheden Ondersteuningsdetails Ondersteunde Qlik Talend Data Integration -projecten Alleen replicatieprojecten . Gegevenspijplijnprojecten worden niet ondersteund. Bijwerkmethoden doel
Replicatietaken:
Wijzigingen toepassen
Wijzigingen opslaan
Gegevens tijdelijk opslaan in een datalaketaak:
Metagegevens beheren
Handmatig metagegevens genereren is niet nodig. Schema-evolutie
Alleen de bewerking Type kolomgegevens wijzigen wordt ondersteund. Replicatie van LOB-kolommen (NCLOB, CLOB en BLOB) Niet ondersteund. Gepland CDC Vereist. Zo wordt het doel up-to-date gehouden met wijzigingen in de bron.
Voor replicatietaken raadpleegt u Taken plannen
Voor tussenopslagtaken voor lake, raadpleegt u CDC plannen voor tussenopslagtaken in lake
Meldingen Gedeeltelijk ondersteund
Meldingen instellen voor wijzigingen van de bewerking
Bewaking Alleen CDC, omdat volledige lading niet relevant is voor deze connector.
Een afzonderlijke gegevenstaak bewaken
Automatisch denesten van nettoladingen van JSON-kolommen Niet ondersteund. Nettoladingen van JSON-kolommen in brongegevensverzamelingen worden niet automatisch gedenest op het doel.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Informatie Zorg dat het account dat u gebruikt leestoegang heeft voor de tabellen die u wilt ophalen.
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 Ga voor meer informatie naar Verbinding maken met SaaS-applicaties
Vul de vereiste verbindingseigenschappen in. Geef in Verbindingsnaam een naam voor de verbinding op.
Selecteer Metagegevens verbinding openen om metagegevens te definiëren voor de verbinding nadat deze is gemaakt.
Klik op Maken .
Connection settings Setting Description Data gateway
Selecteer een Data Movement gateway als dit is vereist voor uw usecase.
Informatie Dit veld is niet beschikbaar met het Qlik Talend Cloud Starter -abonnement, omdat het geen ondersteuning biedt voor Data Movement gateway . Als u een ander abonnementsniveau hebt en Data Movement gateway niet wilt gebruiken, selecteer dan Geen .
Raadpleeg Qlik Gegevensgateway - Gegevensverplaatsing Data Movement gateway en usecases waarvoor deze is vereist.
Start Date Voer de datum in, in het formaat MM/DD/YYYY, vanaf wanneer de gegevens van uw gegevensbron naar uw doel moeten worden gerepliceerd.
API Key API key.
Informatie 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
