AvailableNumbers
Represents a phone number currently available for purchase via the Twilio Global Catalog API.
View-Specific Information
Represents a phone number currently available for purchase via the Twilio Global Catalog API. Includes pricing, lifecycle status, regulatory requirements, geographic metadata, and detailed Voice, SMS, and MMS capability information.
Select
Twilio allows only a small subset of columns to be used in the WHERE clause of a SELECT query. The provider uses the Twilio api to process WHERE clause conditions built with the following columns and operator:
- Type supports = operator.
SELECT * FROM AvailableNumbers;
SELECT * FROM AvailableNumbers where Type = 'tollfree';
Columns
| Name | Type | References | Description |
| PhoneNumber [KEY] | String | The available phone number in E.164 format. | |
| BaseSetupPrice | Decimal | The one-time setup fee required to purchase this phone number. | |
| BaseRecurringPrice | Decimal | The recurring monthly fee for maintaining this phone number. | |
| Type | String | The classification of the phone number (e.g., local, mobile, toll-free, national). | |
| Lifecycle | String | Indicates the availability status of the number (for example: generally_available, beta, restricted). | |
| CapabilitiesVoiceInboundConnectivity | Boolean | Indicates whether inbound voice calls can be received. | |
| CapabilitiesVoiceOutboundConnectivity | Boolean | Indicates whether outbound voice calls can be initiated. | |
| CapabilitiesVoiceE911 | Boolean | Indicates whether emergency calling (E911) is supported. | |
| CapabilitiesVoiceFax | Boolean | Indicates whether fax transmission is supported. | |
| CapabilitiesVoiceSipTrunking | Boolean | Indicates whether the number supports SIP trunking integration. | |
| CapabilitiesVoiceCallsPerSecond | Integer | Maximum number of voice calls allowed per second. | |
| CapabilitiesVoiceConcurrentCallsLimit | Integer | Maximum number of concurrent active voice calls supported. | |
| CapabilitiesVoiceLongRecordLength | Integer | Maximum supported voice recording duration in seconds. | |
| CapabilitiesVoiceInboundCalledDtmf | Boolean | Indicates whether DTMF tones from the called party are supported. | |
| CapabilitiesVoiceInboundCallerDtmf | Boolean | Indicates whether DTMF tones from the calling party are supported. | |
| CapabilitiesVoiceInboundCallerIdPreservation | String | Describes how caller ID is preserved for inbound calls. | |
| CapabilitiesVoiceInboundReachability | String | Defines the geographic or network scope for inbound voice calls. | |
| CapabilitiesSmsInboundConnectivity | Boolean | Indicates whether inbound SMS messages can be received. | |
| CapabilitiesSmsOutboundConnectivity | Boolean | Indicates whether outbound SMS messages can be sent. | |
| CapabilitiesSmsGsm7 | Boolean | Indicates support for GSM-7 character encoding for SMS. | |
| CapabilitiesSmsUcs2 | Boolean | Indicates support for UCS-2 character encoding for SMS. | |
| CapabilitiesSmsGsm7Concatenation | Boolean | Indicates whether concatenated GSM-7 SMS messages are supported. | |
| CapabilitiesSmsUcs2Concatenation | Boolean | Indicates whether concatenated UCS-2 SMS messages are supported. | |
| CapabilitiesSmsInboundSenderIdPreservation | String | Describes how sender ID is preserved for inbound SMS messages. | |
| CapabilitiesSmsInboundReachability | String | Defines the geographic or network scope for inbound SMS delivery. | |
| CapabilitiesSmsInboundMps | Integer | Maximum inbound SMS messages per second supported. | |
| CapabilitiesMmsInboundConnectivity | Boolean | Indicates whether inbound MMS messages can be received. | |
| CapabilitiesMmsOutboundConnectivity | Boolean | Indicates whether outbound MMS messages can be sent. | |
| CapabilitiesMmsInboundReachability | String | Defines the geographic or network scope for inbound MMS delivery. | |
| CapabilitiesMmsInboundMps | Integer | Maximum inbound MMS messages per second supported. | |
| RegulatoryAddressRequirements | String | Indicates whether regulatory address documentation is required before purchasing this number. | |
| GeographyIsoCountry | String | The ISO 3166-1 alpha-2 country code associated with the number. | |
| GeographyLata | String | The Local Access and Transport Area (LATA) for the number, if applicable. | |
| GeographyRateCenter | String | The rate center associated with the phone number. | |
| GeographyLatitude | Double | Latitude coordinate of the phone number's geographic location. | |
| GeographyLongitude | Double | Longitude coordinate of the phone number's geographic location. | |
| GeographyRegion | String | The state or province abbreviation associated with the number. | |
| GeographyLocality | String | The city or locality associated with the number. | |
| GeographyPostalCode | String | The postal or ZIP code associated with the number. |