MCP Server for HubSpot

Build 24.0.9300

EngagementsEmails

Retrieves all email engagement records in HubSpot for analyzing customer email interactions.

SELECT

When selecting Email Engagements, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operator is =. 

SELECT * FROM EngagementsEmails WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42';
SELECT * FROM EngagementsEmails WHERE Archived = TRUE;

INSERT


INSERT INTO EngagementsEmails ([Activity date], [Email Direction], [Attached Video Opened], [Attached Video Watched], [Email send status], [Email subject], [Email body], [UpdatedAt])
VALUES (CURRENT_TIMESTAMP(), 'EMAIL', TRUE, TRUE, 'BOUNCED', 'subject', 'text', CURRENT_TIMESTAMP() )

UPDATE


UPDATE EngagementsEmails SET [Email body] = 'Updated email body', [Email send status] = 'FAILED' WHERE ID = '11896047040'

DELETE


DELETE FROM EngagementsEmails WHERE ID = '11896047040'

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] Long False True

Unique identifier of the object.

Archived Bool True True

Whether the object is archived or not.

CreatedAt Datetime True False

When the object was created.

UpdatedAt Datetime True False

When the object was last updated.

Business units String False False

The business units this record is assigned to.

AtMentioned Owner Ids String False False

The owners that have been at_mentioned on the engagement.

Attached file IDs String False False

The IDs of the files that are attached to the engagement.

Body preview String True False

A truncated preview of the engagement body.

HTML Body Preview String True False

The HTML representation of the engagement body preview.

Body Preview Truncated Bool True False

Indicates whether the engagement body was truncated for the preview.

Activity created by String True False

The user who created the engagement.

Created by user ID Decimal True False

The user that created this object. This value is automatically set by HubSpot and may not be modified.

Create date Datetime True False

The date that an engagement was created.

Email direction and unique ID String True False

The direction and unique ID of the email.

Attached Video String False False

The ID of a video optionally attached to an email.

Attached Video Name String False False

The name of a video optionally attached to an email.

Attached Video Opened Bool False False

Has the video attachment been opened.

Attached Video Watched Bool False False

Has the video attachement been watched.

Email BCC Address String True False

Email addresses of the email's BCC recipients.

Email BCC First Name String True False

First names of the email's BCC recipients.

Email BCC Last Name String True False

Last names of the email's BCC recipients.

Email BCC String True False

Raw header values of the email's BCC recipients.

Email Bounce Error Detail Message String False False

The message from the bounce error.

Email Bounce Error Detail Status Code Decimal False False

The status code from the bounce error.

Email CC Address String True False

Email addresses of the email's CC recipients.

Email CC First Name String True False

First names of the email's CC recipients.

Email CC Last Name String True False

Last names of the email's CC recipients.

Email CC String True False

Raw header values of the email's CC recipients.

Email Direction String False False

The direction the email was sent in.

Encoded Email Associations Request String True False

Encoded email associations request.

Error Message String False False

The error that occurred while sending the email.

Email Send Id String True False

The ID of the email send event sent through Facsimile.

Email From Address String True False

Email address of the email's sender.

Email From First Name String True False

First name of the email's sender.

Email From Last Name String True False

Last name of the email's sender.

Email From String True False

Raw header value of the email's sender.

Email Headers String False False

The sender and receivers of the email.

Email body String False False

This is the body of any email sent from a record. It doesn't include emails received from contacts.

Logged From String False False

Where the email was logged.

Media Processing Status String False False

Processing status for this email's images and attachments.

Email is member of forwarded subthread Bool False False

Whether this email is a member of a forwarded subthread.

Message ID String False False

The ID of the message.

EmailMigratedViaPortalDataMigration String False False

Indicates that the email was migrated from another portal using DataMigration tool.

Email pending inline image file IDs String False False

File IDs of pending inline images in the email's HTML.

PostSend Status String False False

A description of what happened to the email _successful send_ bounced_ dropped_ and why.

RecipientDrop Reasons String False False

A list of the dropped recipients paired with the reason each was dropped.

Email Send Event Id String False False

The ID of the email send event.

Email Send Event Id Created Datetime False False

The date when the email send event ID was created.

Email Sender Address String True False

Email address of the email's sender.

Email Sender First Name String True False

First name of the email's sender.

Email Sender Last Name String True False

Last name of the email's sender.

Email Sender String True False

Raw header value of the email's sender.

Sent Via String False False

How the email was sent.

Email send status String False False

The send status of the email.

Email subject String False False

The subject of the email.

Text String False False

The plaintext of the email.

Thread ID String False False

The thread that the email belongs to.

Email To Address String True False

Email addresses of the email's recipients.

Email To First Name String True False

First names of the email's recipients.

Email To Last Name String True False

Last names of the email's recipients.

Email To String True False

Raw header values of the email's recipients.

Tracker Key String False False

The tracker key of the email.

Validation Skipped String False False

Validation skipped that would have otherwise rejected logging.

Engagement Source String False False

The source that created this engagement.

Engagement Source ID String False False

The specific ID of the process that created this engagement.

Follow up action String False False

What action should be performed during follow up.

GDPR deleted Bool True False

Indicates the body of this engagement has been cleared because of a GDPR delete request.

Last modified date Datetime True False

The date any property on this engagement was modified.

Merged object IDs String True False

The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

Updated by String True False

The user who last updated the engagement.

Record ID Decimal True False

The unique ID for this record. This value is automatically set by HubSpot and may not be modified.

Product name String False False

The name of the product associated with this engagement.

Queue Memberships String False False

The list of queues that contain this engagement.

Read Only Object Bool True False

Is the object read only.

Activity date Datetime False False

The date that an engagement occurred.

Unique creation key String True False

Unique property used for idempotent creates.

Unique ID String False False

The unique ID of the engagement.

Updated by user ID Decimal True False

The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

User IDs of all notification followers String True False

The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications.

User IDs of all notification unfollowers String True False

The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications.

User IDs of all owners String True False

The user IDs of all owners of this object.

Owner Assigned Date Datetime True False

The timestamp when an owner was assigned to this engagement.

Activity assigned to String False False

The user that the activity is assigned to in HubSpot. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows.

HubSpot Team String True False

The team of the owner of an engagement.

All owner ids String True False

The value of all owner referencing properties for this object_ both default and custom.

All team ids String True False

The team ids corresponding to all owner referencing properties for this object_ both default and custom.

All accessible team ids String True False

The team ids_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9300