ThreadMessages

Retrieves the full message history within a conversation thread, enabling conversation tracking.

View Specific Information

SELECT

When selecting ThreadMessages, they can be filtered by columns marked below as 'Filterable' or by using the pseudo-columns. For those columns, the supported server-side operators is: =.

SELECT * FROM ThreadMessages;
SELECT * FROM ThreadMessages WHERE ThreadId = '8413472578';
SELECT * FROM ThreadMessages WHERE ThreadId = '8413472578' AND Id = '5eb0b534-b4d4-43cd-9137-e3a0f801d9ce' ;

Columns


Name	Type	References	Filterable	Description
Id [KEY]	String		True	Unique identifier of the thread message.
Type	String		False	The category or classification of the message, such as email, chat, or SMS.
CreatedAt	Datetime		False	Timestamp indicating when the message was originally created.
UpdatedAt	Datetime		False	Timestamp indicating the last time the message was updated.
CreatedBy	String		False	ID of the participant or system that created the message.
ClientType	String		False	The type of client application that originated the message.
IntegrationAppId	Integer		False	ID of the integration that sent the message, if applicable.
SendersId	String		False	ID of the sender who transmitted the message.
SendersName	String		False	Name of the sender who transmitted the message.
SendersField	String		False	Custom-defined field representing the sender's role or context.
SendersDeliveryIdentifierType	String		False	Type of identifier used to deliver the message from the sender, such as email or phone number.
SendersDeliveryIdentifierValue	String		False	Value of the sender's delivery identifier, such as the actual email address or phone number.
RecipientsId	String		False	ID of the recipient who received the message.
RecipientsName	String		False	Name of the recipient who received the message.
RecipientsField	String		False	Custom-defined field representing the recipient's role or context.
RecipientsDeliveryIdentifierType	String		False	Type of identifier used to deliver the message to the recipient, such as email or phone number.
RecipientsDeliveryIdentifierValue	String		False	Value of the recipient's delivery identifier, such as the actual email address or phone number.
ChannelId	String		False	ID of the communication channel through which the message was sent.
ChannelAccountId	String		False	Account ID used within the channel for message delivery.
Archived	Bool		False	Indicates whether the message is archived and no longer actively displayed.
AssignedTo	String		False	ID of the user or queue the message is currently assigned to.
AssignedFrom	String		False	ID of the user or queue from which the message was previously assigned.
Text	String		False	Plain text content of the message body.
RichText	String		False	HTML-formatted content of the message body.
AttachmentsFileId	String		False	ID of any file attached to the message.
AttachmentsUrl	String		False	URL pointing to the file attachment associated with the message.
Subject	String		False	Subject line of the message, if applicable.
TruncationStatus	String		False	Indicates whether the message content was truncated.
InReplyToId	String		False	ID of the message this entry is replying to, if part of a conversation thread.
StatusType	String		False	Current status type of the message, such as 'sent', 'delivered', or 'failed'.
Direction	String		False	Direction of the message relative to the user, such as inbound or outbound.
NewStatus	String		False	Most recently updated status value of the message.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.


Name	Type	Description
ThreadId	String		Identifier of the conversation thread this message belongs to.

CData Python Connector for HubSpot

ThreadMessages

View Specific Information

SELECT

Columns

Pseudo-Columns