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