ODBC Driver for Twilio

Build 23.0.8839


Insert, update, and query the verified numbers that may be used as a caller Id when making outgoing calls in Twilio.


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 available columns for OutgoingCallerIds are PhoneNumber, Name, and Sid.

SELECT * FROM OutgoingCallerIds WHERE Sid = 'X123456789'


To add an OutgoingCallerId use the AddOutgoingCallerIds stored procedure.

EXEC AddOutgoingCallerIds PhoneNumber = '+15105555555'


Twilio allows the Name column to be updated.

UPDATE OutgoingCallerIds SET Name = 'test' WHERE Sid = 'O123456789'


Twilio does not allow OutgoingCallerIds to be deleted.


Name Type ReadOnly References Description
Sid [KEY] String True

The Id of the outgoing caller Id.

AccountSid String True

The account Id of the outgoing caller Id.

DateCreated Datetime True

The creation date of the outgoing caller Id.

DateUpdated Datetime True

The modfication date of the outgoing caller Id.

Name String False

The friendly name of the outgoing caller Id. By default, this is a formatted phone number.

PhoneNumber String False

The phone number of the outgoing caller Id.

Uri String True

The URI of the outgoing caller Id.

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