SSIS Components for Twilio

Build 21.0.7871


Delete and query Media in Twilio.


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. The Sid column is required in the WHERE clause; DateCreated is optional and can be used with the >, >=, <, <=, or = conditions.

SELECT * FROM Media WHERE Sid = 'MS123456789' AND DateCreated > '2015-10-10' 


Twilio does not allow Media to be added.


Twilio does not allow Media to be updated.


Name Type ReadOnly References Description
Sid [KEY] String False

The Id of the media.

AccountSid String False

The Id of the account associated with the media.

ParentSid String False

The Id of the entity that created the media.

ContentType String False

The MIME type of the media.

DateCreated Datetime False

The creation date of the media.

DateUpdated Datetime False

The modification date of the media.

Uri String False

The URL of the media.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
MessageSid String

The message Id of the media.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7871