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.
使用できる値は次のとおりです。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. |