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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 詳細については、WHERE 句のセクションを参照してください。
| Name | Type | Description | |
| ThreadId | String | Id of the thread that contains the messages. |