ConversationMessages
ConversationMessage includes metadata of the Messages sent over a conversation.
Table 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
Twilio allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison.
NOTE: ConversationSid is required in order to query ConversationMessages.
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. |