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, AreaCode) VALUES ('+15105555555', '123')
Update
UPDATE IncomingPhoneNumbers SET Name='appp8' WHERE Sid= 'X123456789'
Delete
DELETE FROM IncomingPhoneNumbers WHERE Sid = 'X123456789'
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
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. This column will work only with INSERT. |