ODBC Driver for Twilio

Build 24.0.9062

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.

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