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