Conversations
Conversation includes a list of current Participants and the Messages that they have sent amongst each other.
Table Specific Information
A Conversation is a unique thread of a conversation. each Conversation includes a list of current Participants and the Messages that they have sent amongst each other.
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 Conversations.
SELECT * FROM ConversationParticipants WHERE conversationsid = 'CH7040b87e3664410aa4c241a3d6c85f0b' SELECT * FROM ConversationParticipants WHERE conversationsid = 'CH7040b87e3664410aa4c241a3d6c85f0b' AND Sid = 'IS62451554b2b349d6a0bee0b047ead195' SELECT * FROM Conversations where State = 'active' SELECT * FROM Conversations where DateCreated = '2015-12-16T22:18:37' and DateUpdated = '2015-12-16T22:18:38'
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 conversation. | |
| AttributesTopic | String | An optional string metadata field you can use to store any data | |
| ChatServiceSid | String | The unique ID of the Conversation Service this conversation belongs to. | |
| DateCreated | Datetime | The date that this resource was created. | |
| DateUpdated | Datetime | The date that this resource was last updated. | |
| FriendlyName | String | The human-readable name of this conversation, limited to 256 characters. Optional. | |
| LinksMessages | String | Contains absolute URLs to access the participants of this conversation. | |
| LinksParticipants | String | Contains absolute URLs to access the participants of this conversation. | |
| MessagingServiceSid | String | The unique ID of the Messaging Service this conversation belongs to. | |
| State | String | Current state of this conversation.
The allowed values are active, inactive, closed. | |
| TimersDateClosed | Datetime | Timer date values representing state update for this conversation. | |
| TimersDateInactive | Datetime | Timer date values representing state update for this conversation. | |
| UniqueName | String | An application-defined string that uniquely identifies the resource. | |
| Url | String | An absolute API resource URL for this conversation. |