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