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. 使用できる値は次のとおりです。closed, suspended, active デフォルト値はactiveです。 | |
Type | String | True |
The type of the account. Either Trial or Full. |