ODBC Driver for Twilio

Build 23.0.8839


Create, update, and query Twilio Accounts belonging to the authenticated Account.


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 Accounts are Name, Status, and Sid.

SELECT * FROM Accounts WHERE Name = 'test' AND Status = 'suspended'


To add an Account, specify the Name field.

INSERT INTO Accounts (Name) VALUES ('test1')


Twilio allows updates for the Name and Status columns.

UPDATE Accounts SET Status = 'closed' WHERE Sid = 'X123456789'


Twilio does not allow Accounts to be deleted.


Name Type ReadOnly References Description
Sid [KEY] String True

The Id of the account.

DateCreated Datetime True

The creation date of the account.

DateUpdated Datetime True

The modification date of the account.

Name String False

The friendly name of the account.

OwnerAccountSid String True

The master account of the account.

AuthToken String True

The authentication token of the account.

Status String False

The status of the account. Allowed values are closed, suspended, and active.

使用できる値は次のとおりです。closed, suspended, active


Type String True

The type of the account. Either Trial or Full.

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