Table: twilio_account_application - Query Twilio Account Applications using SQL

Twilio Account Applications represent the settings and configurations for a specific application in Twilio. It encapsulates the behavior you’d like your call to exhibit once it’s connected. This includes things like the URL of the script you’d like to run, whether to record the calls, and whether to record the calls as mono or dual-channel.

Table Usage Guide

The twilio_account_application table provides insights into application settings within Twilio. As a DevOps engineer, explore application-specific details through this table, including URLs of the scripts to run, recording preferences, and channel settings. Utilize it to uncover information about applications, such as those with specific configurations, the behavior of calls once connected, and the verification of application settings.

Examples

Basic info

Explore which Twilio applications are currently linked to your account, with a focus on understanding how each application is configured for sending SMS and voice messages. This can be useful for auditing communication settings and ensuring the correct methods are in place.

select
  sid,
  friendly_name,
  sms_url,
  sms_method,
  voice_url,
  voice_method,
  account_sid
from
  twilio_account_application;

select
  sid,
  friendly_name,
  sms_url,
  sms_method,
  voice_url,
  voice_method,
  account_sid
from
  twilio_account_application;

List applications with caller ID lookup feature enabled

Gain insights into the applications that have the caller ID lookup feature enabled. This can be useful for auditing purposes, ensuring that the feature is only activated for the intended applications.

select
  sid,
  friendly_name,
  sms_url,
  voice_url,
  voice_caller_id_lookup,
  account_sid
from
  twilio_account_application
where
  voice_caller_id_lookup;

select
  sid,
  friendly_name,
  sms_url,
  voice_url,
  voice_caller_id_lookup,
  account_sid
from
  twilio_account_application
where
  voice_caller_id_lookup = 1;

List applications with no voice fallback URL configured

Discover which applications lack a configured voice fallback URL. This can help in identifying potential communication gaps in your Twilio account, ensuring that all applications have a fallback option for voice services.

select
  sid,
  friendly_name,
  sms_url,
  voice_url,
  voice_fallback_url,
  account_sid
from
  twilio_account_application
where
  voice_fallback_url is null;

select
  sid,
  friendly_name,
  sms_url,
  voice_url,
  voice_fallback_url,
  account_sid
from
  twilio_account_application
where
  voice_fallback_url is null;

Schema for twilio_account_application

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_sid	text	=, !=, ~~, ~~, !~~, !~~	The SID of the Account that created the resource.
api_version	text		The API version used to start a new TwiML session.
date_created	timestamp with time zone		The date and time that the resource was created.
date_updated	timestamp with time zone		The date and time that the resource was last updated.
friendly_name	text	=	The string that you assigned to describe the resource.
message_status_callback	text		The URL to send message status information to your application.
sid	text	=	The unique string that identifies the resource.
sms_fallback_method	text		The HTTP method used with sms_fallback_url.
sms_fallback_url	text		The URL that we call when an error occurs while retrieving or executing the TwiML.
sms_method	text		The HTTP method to use with sms_url.
sms_status_callback	text		The URL to SMS send status information to your application.
sms_url	text		The URL we call when the phone number receives an incoming SMS message.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status_callback	text		The URL to send status information to your application.
status_callback_method	text		The HTTP method we use to call status_callback.
uri	text		The URI of the resource, relative to 'https://api.twilio.com'.
voice_caller_id_lookup	boolean		Indicates whether to lookup the caller's name, or not.
voice_fallback_method	text		The HTTP method used with voice_fallback_url.
voice_fallback_url	text		The URL we call when a TwiML error occurs.
voice_method	text		The HTTP method used with the voice_url.
voice_url	text		The URL we call when the phone number receives a call.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- twilio

You can pass the configuration to the command with the --config argument:

steampipe_export_twilio --config '<your_config>' twilio_account_application