ADO.NET Provider for Twilio

Build 24.0.9062

AvailablePhoneNumbers

Query the local, mobile, and toll-free phone numbers available in Twilio.

Table Specific Information

You can use this table to search for local, toll-free, and mobile phone numbers that are available for you to purchase. You can search for phone numbers by specifying a pattern, country, area code (NPA) or exchange (NXX), or geography.

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. IsoCountry and Category are required columns in the WHERE clause. Optional columns are AreaCode, CapabilitiesSms, CapabilitiesVoice, Beta, RateCenter, Lata, PostalCode, Distance, and PhoneNumber. PhoneNumber can be used with the LIKE condition.

SELECT * FROM AvailablePhoneNumbers WHERE IsoCountry = 'US' AND Category = 'Local'

Columns

Name Type References Description
PhoneNumber [KEY] String The phone number available to purchase. It may be used as a pattern to match phone numbers on. Valid characters are '*' and [0-9a-zA-Z]. The '*' character will match any single digit.
Name String The friendly name of the available phone number.
Lata String The LATA of the available phone number.
RateCenter String The rate center of the available phone number.
Latitude Double The latitude of the available phone number.
Longitude Double The longitude of the available phone number.
Region String The region of the available phone number.
PostalCode String The postal code of the available phone number.
IsoCountry String The ISO country code in ISO 3166-1 alpha-2 format ('US' for United States, 'CA' for Canada, 'GB' for United Kingdom).
AddressRequirements String The address requirements of the available phone number. Eligible values are: none, any, local, or foreign.

使用できる値は次のとおりです。none, any, local, foreign

Beta Boolean Whether the phone number is a beta number new to the Twilio platform.
CapabilitiesVoice Boolean Whether the phone number has voice capabilities.
CapabilitiesSms Boolean Whether the phone number has SMS capabilities.
CapabilitiesMms Boolean Whether the phone number has MMS capabilities.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ExcludeAllAddressRequired Boolean Indicates whether the response includes phone numbers which require any Address. Possible values are true or false. If not specified, the default is false, and results could include phone numbers with an Address required.
ExcludeLocalAddressRequired Boolean Indicates whether the response includes phone numbers which require a local Address. Possible values are true or false. If not specified, the default is false, and results could include phone numbers with a local Address required.
ExcludeForeignAddressRequired Boolean Indicates whether the response includes phone numbers which require a foreign Address. Possible values are true or false. If not specified, the default is false, and results could include phone numbers with a foreign Address required.
AreaCode String The area code of the available phone number.
Category String The category of the available phone number. Possible values are: Local,Mobile,Tollfree.

使用できる値は次のとおりです。Local, Mobile, Tollfree

NearNumber String Given a phone number, find a geographically close number within Distance miles. Distance defaults to 25 miles.
NearLatLong String Given a latitude/longitude pair lat,long find geographically close numbers within Distance miles.
Distance String The search radius for available phone numbers. Default is 25 miles. Max is 500 miles.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062