Tableau Connector for Twilio

Build 24.0.8963

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963