TDV Adapter for Twilio

Build 22.0.8462

Accounts

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

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

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

Insert

To add an Account, specify the Name field. 

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

Update

Twilio allows updates for the Name and Status columns. 

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

Delete

Twilio does not allow Accounts to be deleted.

Columns

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.

The allowed values are closed, suspended, active.

The default value is active.

Type String True

The type of the account. Either Trial or Full.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462