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 项目	仅 Replication 项目。不支持数据管道项目。
目标更新方法	复制任务：应用更改存储更改在数据湖任务中登陆数据：更改数据捕获 (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

本页面有帮助吗？

如果您发现此页面或其内容有任何问题 – 打字错误、遗漏步骤或技术错误 – 请告诉我们！

在此处留下您的反馈