Applications
Create, update, delete, and query the available Applications 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 be used with only the equals or = comparison. The available columns for Applications are Name and Sid.
SELECT * FROM Applications WHERE Sid = 'X123456789'
Insert
To add an Application, specify at least the Name.
INSERT INTO Applications (Name, VoiceUrl, VoiceFallbackUrl, VoiceFallbackMethod, StatusCallback, StatusCallbackMethod, VoiceCallerIdLookup, SmsUrl, SmsMethod, SmsFallbackUrl, SmsStatusCallback, MessageStatusCallback) VALUES ('app7', 'http://demo.twilio.com/docs/voiceUrl.xml', 'http://demo.twilio.com/docs/voiceFallback.xml', 'POST', 'http://demo.twilio.com/docs/statusCallback.xml', 'POST', true, 'http://demo.twilio.com/docs/smsFallback.xml', 'POST', 'http://demo.twilio.com/docs/smsFallback.xml', 'http://demo.twilio.com/docs/smsStatusCallback.xml', 'http://demo.twilio.com/docs/voiceUrl.xml')
Update
UPDATE Applications SET Name='appp8' WHERE Sid= 'ACab6788889df1432ae'
Delete
DELETE FROM Applications WHERE Sid = 'ACab6788889df1432ae'
Columns
Name | Type | ReadOnly | References | Description |
Sid [KEY] | String | True |
The Id of the application. | |
DateCreated | Datetime | True |
The creation date of the application. | |
DateUpdated | Datetime | True |
The modification date of the application. | |
AccountSid | String | True |
The account Id of the application. | |
Name | String | False |
The friendly name of the application. | |
ApiVersion | String | True |
The API version of the application. | |
VoiceUrl | String | False |
The URL Twilio will request when a phone number assigned to the application receives a call. | |
VoiceFallbackUrl | String | False |
The URL Twilio will request when an error occurs requesting the voice URL of the application. | |
VoiceFallbackMethod | String | False |
The HTTP method to use to request the fallback voice URL of the application. | |
StatusCallback | String | False |
The URL where Twilio will pass status parameters about calls received by phone numbers assigned to the application. | |
StatusCallbackMethod | String | False |
The HTTP method that Twilio will use to make requests to the status callback URL of the application. | |
VoiceCallerIdLookup | String | False |
Whether to look up the voice caller Id from the CNAM database for phone numbers assigned to this application. | |
VoiceMethod | String | False |
The HTTP method Twilio will use to request the voice URL. | |
SmsUrl | String | False |
The URL Twilio will request when a phone number assigned to the application receives an SMS message. | |
SmsMethod | String | False |
The HTTP method Twilio will use to request the SMS URL of the application. | |
SmsFallbackUrl | String | False |
The URL Twilio will request if an error occurs requesting the SMS URL. | |
SmsFallbackMethod | String | False |
The HTTP method Twilio will use to request the fallback SMS URL of the application. | |
SmsStatusCallback | String | False |
The URL where Twilio will POST to when an outgoing SMS request uses the Sid of the application. | |
MessageStatusCallback | String | False |
The URL where status parameters are sent when you insert to the Messages table and specify the Sid of the application. | |
Uri | String | True |
The URI of the application. |