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