SSIS Components for Twilio

Build 24.0.9062

ConversationParticipants

Each participant in a Conversation represents one real (probably human) participant in a Conversation. it joins Participants with the conversation, and the connected person will receive all subsequent messages.

Table Specific Information

Each participant in a Conversation represents one real (probably human) participant in a Conversation. Participant joins with the conversation, and the connected person will receive all subsequent messages.

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 ConversationPartiticipants.

SELECT * FROM ConversationParticipants WHERE conversationsid = 'CH7040b87e3664410aa4c241a3d6c85f0b'

SELECT * FROM ConversationParticipants WHERE conversationsid = 'CH7040b87e3664410aa4c241a3d6c85f0b' AND Sid = 'IS62451554b2b349d6a0bee0b047ead195'

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 participant.
AttributesRole String An optional string metadata field you can use to store any data
ConversationSid String

Conversations.Sid

The unique ID of the Conversation for this participant.
DateCreated Datetime The date that this resource was created.
DateUpdated Datetime The date that this resource was last updated.
Identity String A unique string identifier for the conversation participant as Conversation User.
MessagingBindingAddress String Information about how this participant exchanges messages with the conversation.
MessagingBindingProxyAddress String Information about how this participant exchanges messages with the conversation.
MessagingBindingType String Information about how this participant exchanges messages with the conversation.
RoleSid String The SID of a conversation-level Role to assign to the participant.
Url String An absolute API resource URL for this participant.

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