ODBC Driver for Twilio

Build 24.0.9062

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.

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