Tableau Connector for Twilio

Build 24.0.8963

IncomingPhoneNumbersCategory

Query Twilio Incoming Phone Numbers and filter by Category.

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 IncomingPhoneNumbersCategory are Category, PhoneNumber, Name, Beta, and Sid. The Category column must be specified in the WHERE clause.

SELECT * FROM IncomingPhoneNumbersCategory WHERE Category = 'Local'

Columns

Name Type References Description
Sid [KEY] String The Id of the phone number.
AccountSid String The account Id of the phone number.
Name String The friendly name of the phone number. By default, this is a formatted phone number.
PhoneNumber String The phone number in E.164 format.
VoiceUrl String The URL Twilio will request when the phone number receives a call.
VoiceMethod String The HTTP method Twilio will use to request the voice URL.
VoiceFallbackUrl String The URL Twilio will request when an error occurs requesting the voice URL.
VoiceFallbackMethod String The HTTP method Twilio will use to request the fallback voice URL.
VoiceCallerIdLookup Boolean Whether to look up the caller Id of the caller in the CNAM database.
DateCreated Datetime The creation date of the phone number.
DateUpdated Datetime The modification date of the phone number.
SmsUrl String The URL Twilio will request when someone sends an SMS message to the phone number.
SmsMethod String The HTTP method Twilio will use to request the SMS URL of the phone number.
SmsFallbackUrl String The URL Twilio will request when an error occurs requesting the SMS URL.
SmsFallbackMethod String The HTTP method Twilio will use to request the fallback SMS URL.
AddressRequirements String The address requirements of the phone number.
Beta Boolean Whether the phone number is a beta phone number new to Twilio.
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.
StatusCallback String The URL that Twilio pass status parameters to.
StatusCallbackMethod String The HTTP method Twilio will use to make requests to the status callback URL.
ApiVersion String The API version of the phone number.
VoiceApplicationSid String The voice application Id of the phone number. This can be used in place of the voice URLs.
SmsApplicationSid String The SMS application Id of the phone number. This can be used in place of the SMS URLs.
TrunkSid String The trunk Id of the phone number. This overrides the Voice_Application_Sid.
Uri String 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
Category String The category of the phone number. Possible values are local,mobile and tollfree.

The allowed values are Local, Mobile, TollFree.

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