Mailshake

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.

Общий обзор этого коннектора, включая полезные ссылки и поддерживаемые функции.

Функция/возможность	Сведения о поддержке
Поддерживаемые проекты Qlik Talend Data Integration	Только проекты репликации. Проекты конвейера данных не поддерживаются.
Методы обновления целей	Задачи репликации: Применить изменения Сохранить изменения Промежуточное хранение данных в озере данных: Захват изменений данных (CDC)
Управление метаданными	Создание метаданных вручную не требуется.
Эволюция схемы	Поддерживается только операция Изменить тип данных столбца.
Репликация столбцов LOB (NCLOB, CLOB и BLOB)	Не поддерживается.
Запланированный CDC	Требуется. Так целевой объект обновляется в соответствии с изменениями в источнике. Для получения информации о задачах репликации см. раздел Планирование задач Для получения информации о задачах промежуточного хранения в озере см. раздел Планирование CDC для задач промежуточного хранения в озере
Уведомления	Частично поддерживается Настройка уведомлений об изменениях в работе
Мониторинг	Только CDC, так как полная загрузка для этого коннектора не актуальна. Мониторинг индивидуальной задачи данных
Автоматическое извлечение вложенной полезной нагрузки столбцов JSON	Не поддерживается. Вложенная полезная нагрузка столбцов JSON в исходных наборах данных не извлекается автоматически в цели.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Убедитесь, что используемая учетная запись имеет доступ для чтения к таблицам, которые требуется получить.

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

Для получения дополнительной информации см. раздел Подключение к приложениям SaaS.

Заполните необходимые свойства подключения.
Заполните поле Имя подключения.
Установите флажок Открыть метаданные подключения, чтобы определить метаданные для подключения, когда оно будет создано.
Щелкните Создать.

Connection settings
Setting	Description
Data gateway	Выберите шлюз Шлюз движения данных, если этого требует текущий сценарий использования. Примечание к информации Это поле недоступно при использовании подписки Qlik Talend Cloud Starter, так как она не поддерживает Шлюз движения данных. Если используется другой уровень подписки или не требуется использовать Шлюз движения данных, выберите Нет. Для получения информации о преимуществах Шлюз движения данных и о сценариях, требующих его использования, см. раздел Шлюз данных Qlik — движение данных.
Start Date	Введите дату в формате `MM/DD/YYYY`, начиная с которой данные должны реплицироваться из источника в цель.
API Key	API key.

Schema

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.

Replication Method	CDC
Primary Key	id
Replication Key	created
Useful links	Mailshake API method

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

actionDate

DATE-TIME

archived

BOOLEAN

created

DATE-TIME

endedAt

DATE-TIME

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.

Replication Method	CDC
Primary Key	id
Replication Key	actionDate
Useful links	Mailshake API method

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

actionDate

DATE-TIME

campaign

OBJECT

This is a nested data structure:

created: DATE-TIME
id: INTEGER
object: STRING
title: STRING

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.

Replication Method	CDC
Primary Key	id
Replication Key	created
Useful links	Mailshake API method

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

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

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.

Replication Method	CDC
Primary Key	id
Replication Key	actionDate
Useful links	Mailshake API method

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

actionDate

DATE-TIME

campaign

OBJECT

This is a nested data structure:

created: DATE-TIME
id: INTEGER
object: STRING
title: STRING

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.

Replication Method	CDC
Primary Key	id
Replication Key	created
Useful links	Mailshake API method

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

action

STRING

campaignId

INTEGER

created

DATE-TIME

emailAddress

STRING

fields

OBJECT

This is a nested data structure.

first

STRING

fullName

STRING

INTEGER

last

STRING

object

STRING

replies

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

Replication Method	CDC
Primary Key	id
Replication Key	actionDate
Useful links	Mailshake API method

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

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

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.

Replication Method	CDC
Primary Key	id
Replication Key	created
Useful links	Mailshake API method

Join senders with	on
campaigns	senders.id = campaigns.sender.id

created

DATE-TIME

emailAddress

STRING

fromName

STRING

object

STRING

offerType

STRING

sent_messages

The sent_messages table contains info about recently sent emails.

Replication Method	CDC
Primary Key	id
Replication Key	actionDate
Useful links	Mailshake API method

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

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

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

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.

Replication Method	CDC
Primary Key	id
Replication Key	teamID
Useful links	Mailshake API method

Join team_members with	on
leads	team_members.id = leads.assignedTo.id

emailAddress

STRING

first

STRING

fullName

STRING

INTEGER

isDisabled

BOOLEAN

isTeamAdmin

BOOLEAN

last

STRING

object

STRING

teamBlockedDate

DATE-TIME

teamID

INTEGER

teamName

BOOLEAN

Помогла ли вам эта страница?

Если вы обнаружили какую-либо проблему на этой странице или с ее содержанием — будь то опечатка, пропущенный шаг или техническая ошибка, сообщите нам об этом!

Оставьте свой отзыв здесь