JDBC Driver for Twilio

Build 23.0.8771

Media

Delete and query Media in Twilio.

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

SELECT * FROM Media WHERE MessageSid = 'SM53a7aeeed5ac474ea' 

SELECT * FROM Media WHERE Sid = 'MS123456789' AND MessageSid = 'SM53a7aeeed5ac474ea' 

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

Insert

Twilio does not allow Media to be added.

Update

Twilio does not allow Media to be updated.

Delete


DELETE FROM Media WHERE MessageSid='MM319a82ae6d7411407ef7dc7d78eb2081' AND Sid='MS123456789'

Columns

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.

Pseudo-Columns

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

Name Type Description
MessageSid String

The message Id of the media.

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