Table: twilio_messaging_service - Query Twilio Messaging Services using SQL

Twilio Messaging Service is a feature within Twilio that allows developers to send SMS, MMS, and WhatsApp messages. It provides a unified API to send messages and manage message delivery across multiple channels. This service also offers features such as message scheduling, content redaction, and delivery intelligence.

Table Usage Guide

The twilio_messaging_service table provides insights into the Messaging Services within Twilio. As a developer or system administrator, explore specific details through this table, including the service's SID, friendly name, status, and type. Utilize it to manage and monitor your messaging services, ensuring efficient and secure communication.

Examples

Basic info

Explore which messaging services have been created on your Twilio account, along with their creation dates and validity periods. This is useful to keep track of your services and their active durations.

select
  sid,
  friendly_name,
  date_created,
  validity_period,
  account_sid
from
  twilio_messaging_service;

select
  sid,
  friendly_name,
  date_created,
  validity_period,
  account_sid
from
  twilio_messaging_service;

List services with smart encoding enabled

Uncover the details of messaging services that have smart encoding enabled, allowing you to assess whether your communication platform is optimized for efficient data usage. This is particularly useful for managing and optimizing costs associated with data transmission in your messaging services.

select
  sid,
  friendly_name,
  date_created,
  smart_encoding,
  account_sid
from
  twilio_messaging_service
where
  smart_encoding;

select
  sid,
  friendly_name,
  date_created,
  smart_encoding,
  account_sid
from
  twilio_messaging_service
where
  smart_encoding = 1;

Schema for twilio_messaging_service

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_sid	text		The SID of the Account that created the resource.
area_code_geo_match	boolean		Indicates whether to enable Area Code Geomatch on the Service Instance, or not.
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.
fallback_method	text		The HTTP method we use to call fallback_url.
fallback_to_long_code	boolean		Indicates whether to enable Fallback to Long Code for messages sent through the Service instance, or not.
fallback_url	text		The URL that we call using fallback_method if an error occurs while retrieving or executing the TwiML from the Inbound Request URL.
friendly_name	text		The string that you assigned to describe the resource.
inbound_method	text		The HTTP method we use to call inbound_request_url.
inbound_request_url	text		The URL we call using inbound_method when a message is received by any phone number or short code in the Service.
links	jsonb		A list of absolute URLs of related resources.
mms_converter	boolean		Indicates whether to enable the MMS Converter for messages sent through the Service instance, or not.
scan_message_content	text		The type of the scan message content.
sid	text	=	The unique string that identifies the resource.
smart_encoding	boolean		Indicates whether to enable Encoding for messages sent through the Service instance, or not.
status_callback	text		The URL we call to pass status updates about message delivery.
sticky_sender	boolean		Indicates whether to enable Sticky Sender on the Service instance, or not.
synchronous_validation	boolean		Indicates whether to enable Synchronous Validation on the Service instance, or not.
title	text		Title of the resource.
url	text		The absolute URL of the Service resource.
use_inbound_webhook_on_number	boolean		If enabled, the webhook url configured on the phone number will be used and will override the `inbound_request_url`/`fallback_url` url called when an inbound message is received.
validity_period	bigint		How long, in seconds, messages sent from the Service are valid.

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_messaging_service