IncomingPhoneNumbers
Create, update, delete, and query phone numbers purchased from Twilio.
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 IncomingPhoneNumbers are PhoneNumber, Name, Beta, and Sid.
SELECT * FROM IncomingPhoneNumbers WHERE Sid = 'X123456789'
Insert
To add an IncomingPhoneNumber, specify exactly one of the following parameters: PhoneNumber or AreaCode. If you include both parameters, Twilio will use the AreaCode parameter and ignore the PhoneNumber provided.
INSERT INTO IncomingPhoneNumbers (PhoneNumber) VALUES ('+15105555555')
Columns
| Name | Type | ReadOnly | References | Description |
| Sid [KEY] | String | True |
The Id of the phone number. | |
| AccountSid | String | False |
The account Id of the phone number. | |
| Name | String | False |
The friendly name of the phone number. By default, this is a formatted phone number. | |
| PhoneNumber | String | False |
The phone number. | |
| VoiceUrl | String | False |
The URL Twilio will request when the phone number receives a call. | |
| VoiceMethod | String | False |
The HTTP method Twilio will use to make the request to the voice URL. | |
| VoiceFallbackUrl | String | False |
The URL Twilio will request when an error occurs requesting the voice URL. | |
| VoiceFallbackMethod | String | False |
The HTTP method to use to request the fallback voice URL. | |
| VoiceCallerIdLookup | Boolean | False |
Whether to look up the caller Id from the CNAM database. | |
| DateCreated | Datetime | True |
The creation date of the phone number. | |
| DateUpdated | Datetime | True |
The modification date of the phone number. | |
| SmsUrl | String | False |
The URL Twilio will request when the phone number receives an SMS message. | |
| SmsMethod | String | False |
The HTTP method Twilio will use to make requests to the SMS URL. | |
| SmsFallbackUrl | String | False |
The URL Twilio will request when an error occurs requesting the SMS URL. | |
| SmsFallbackMethod | String | False |
The HTTP method Twilio will use to request the fallback SMS URL of the phone number. | |
| AddressRequirements | String | True |
The address requirements for the phone number. Eligible values are: none, any, local, or foreign. | |
| Beta | String | True |
Whether the phone number is a beta phone number new to Twilio. | |
| CapabilitiesVoice | Boolean | True |
Whether the phone number supports voice. | |
| CapabilitiesSms | Boolean | True |
Whether the phone number supports SMS. | |
| CapabilitiesMms | Boolean | True |
Whether the phone number supports MMS. | |
| StatusCallback | String | False |
The URL where Twilio will pass status parameters about calls received by the phone number. | |
| StatusCallbackMethod | String | False |
The HTTP method that Twilio will use to make requests to the status callback URL. | |
| ApiVersion | String | False |
The API version of the phone number. | |
| VoiceApplicationSid | String | False |
The voice application Id of the phone number. This can be used in place of the voice URLs. | |
| SmsApplicationSid | String | False |
The SMS application Id of the phone number. This can be used in place of the SMS URLs. | |
| TrunkSid | String | False |
The trunk Id of the phone number. This overrides VoiceApplicationId and the voice URLs. | |
| Uri | String | True |
The URI of the phone number. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AreaCode | String |
The desired area code for your new incoming phone number. Any three digit, US or Canada area code is valid. |