Represents verified phone numbers that can be used as a caller Id when making outgoing calls.

Table-Specific Information

SELECT

The add-in uses the Twilio API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.

Column	Supported Operators
Sid	=
Name	=
PhoneNumber	=

For example:

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

The following is an example of how to delete from the OutgoingCallerIds table.

DELETE FROM OutgoingCallerIds WHERE Sid = 'PNb4c1e6bd6f0a81c70a0cc4dc8b0c82e6'

Columns

Name	Type	ReadOnly	References	Description
Sid [KEY]	String	True		The unique string that identifies the outgoing caller Id record.
AccountSid	String	True		The unique Id of the account associated with the outgoing caller Id.
DateCreated	Datetime	True		The creation date of the outgoing caller Id.
DateUpdated	Datetime	True		The modification 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.