Mailshake EN ESTA PÁGINA
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.
Captura de funciones Una visión detallada de este conector, incluye enlaces útiles y funcionalidad compatible.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Nota informativa Asegúrese de que la cuenta que utiliza tenga acceso de lectura a las tablas que desea recuperar.
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 Para más información, vea Conexión a aplicaciones SaaS
Rellene las propiedades de conexión necesarias. Proporcione un nombre para la conexión en Nombre de la conexión .
Seleccione Abrir metadatos de conexión para definir metadatos para la conexión cuando se haya creado.
Haga clic en Crear .
Connection settings Setting Description Data gateway
Seleccione una Data Movement gateway si su caso de uso así lo requiere.
Nota informativa Este campo no está disponible con la suscripción Qlik Talend Cloud Starter porque Data Movement gateway no se admite. Si tiene otro nivel de suscripción y no desea utilizar Data Movement gateway , seleccione Ninguna .
Para obtener información sobre las ventajas de Data Movement gateway y los casos de uso que lo requieren, consulte Pasarela de movimiento de datos de Qlik
Start Date Indique la fecha, en el formato MM/DD/YYYY, a partir de la cual deben replicarse los datos de su fuente a su destino.
API Key API key.
Nota informativa 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
