OutgoingCallerIds
Insert, update, and query the verified numbers that may be used as a caller Id when making outgoing calls in Twilio.
Select
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'
Insert
To add an OutgoingCallerId use the AddOutgoingCallerIds stored procedure.
EXEC AddOutgoingCallerIds PhoneNumber = '+15105555555'
Update
Twilio allows the Name column to be updated.
UPDATE OutgoingCallerIds SET Name = 'test' WHERE Sid = 'O123456789'
Delete
Twilio does not allow OutgoingCallerIds to be deleted.
Columns
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. |