JDBC Driver for HubSpot

Build 22.0.8462

ThreadMessages

Retrieve the entire message history in a Thread

Columns

Name Type References Filterable Description
Id [KEY] String True The unique Id of the message.
Type String The type of the message.
CreatedAt Datetime Time the message was created.
UpdatedAt Datetime Time the message was updated.
CreatedBy String The Id of an actor/participant which created the message.
ClientType String The type of the client.
IntegrationAppId Integer The Id of the client if the client is an integration.
SendersId String The Id of an actor/participant which sent the message.
SendersName String The Name of an actor/participant which sent the message.
SendersField String The sender's field.
SendersDeliveryIdentifierType String The delivery identifier type for sender.
SendersDeliveryIdentifierValue String The delivery identifier value for sender.
RecipientsId String The Id of an actor/participant which received the message.
RecipientsName String The Name of an actor/participant which received the message.
RecipientsField String The recipient's field.
RecipientsDeliveryIdentifierType String The delivery identifier type for recipient.
RecipientsDeliveryIdentifierValue String The delivery identifier value for recipient.
ChannelId String The Id of the channel.
ChannelAccountId String The Account Id of the channel.
Archived Bool The status of archived.
AssignedTo String To which it is assigned.
AssignedFrom String From whom it is assigned.
Text String The content of the message.
RichText String The content of the message in HTML format.
AttachmentsFileId String The Id of the attachment to the comment.
AttachmentsUrl String The URL of the attachment to the comment.
Subject String The subject of the message.
TruncationStatus String The truncation status of the message.
InReplyToId String The Id value being replied to.
StatusType String The status type.
Direction String The direction of the message.
NewStatus String The value of the new status.

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 Id of the thread that contains the messages.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462