ConversationMessages
ConversationMessage includes metadata of the Messages sent over a conversation.
View-Specific Information
Each Conversation includes a list of the Messages that they have sent amongst each other and an array of objects that describe the Message's media.
SELECT
The provider uses the Twilio API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
Note: ConversationSid is required in order to query ConversationMessages.
- ConversationSid supports the = operator.
- Sid supports the = operator.
For example, the following queries are processed server-side:
SELECT * FROM ConversationMessages WHERE ConversationSid = 'CH7040b87e3664410aa4c241a3d6c85f0b'
SELECT * FROM ConversationMessages WHERE ConversationSid = 'CH7040b87e3664410aa4c241a3d6c85f0b' AND Sid = 'MGd452e64de7dff2465702495ed6048e84'
Columns
| Name | Type | References | Description |
| Sid [KEY] | String | A 34 character string that uniquely identifies this resource. | |
| AccountSid | String | The unique ID of the Account responsible for this message. | |
| ConversationSid | String |
Conversations.Sid | The unique ID of the Conversation for this message. |
| AttributesImportance | String | A string metadata field you can use to store any data you wish. | |
| Author | String | The channel specific identifier of the message's author. | |
| Body | String | The content of the message, can be up to 1,600 characters long. | |
| DateCreated | Datetime | The date that this resource was created. | |
| DateUpdated | Datetime | The date that this resource was last updated. | |
| DeliveryDelivered | String | An object that contains the summary of delivery statuses for the message to non-chat participants. | |
| DeliveryFailed | String | An object that contains the summary of delivery statuses for the message to non-chat participants. | |
| DeliveryRead | String | An object that contains the summary of delivery statuses for the message to non-chat participants. | |
| DeliverySent | String | An object that contains the summary of delivery statuses for the message to non-chat participants. | |
| DeliveryTotal | Integer | An object that contains the summary of delivery statuses for the message to non-chat participants. | |
| DeliveryUndelivered | String | An object that contains the summary of delivery statuses for the message to non-chat participants. | |
| Index | Integer | The index of the message within the Conversation. | |
| LinksDeliveryReceipts | String | Contains an absolute API resource URL to access the delivery & read receipts of this message. | |
| Media | String | An array of objects that describe the Message's media. | |
| ParticipantSid | String | The unique ID of messages's author participant. | |
| Url | String | An absolute API resource API URL for this message. | |
| ContentSid | String | The unique ID of the multi-channel Rich Content template. | |
| LinksChannelMetadata | String | Contains an absolute API resource URL to access the delivery & read receipts of this message. |