Twilio (v1) | Stitch Documentation

Twilio is in beta
Twilio is currently in beta. The info in this guide is subject to change.

Twilio extraction is supported by Stitch
This integration is powered by Singer's Twilio tap and certified by Stitch. Check out and contribute to the repo on GitHub.

For support, contact Stitch support.

Twilio integration summary

Stitch’s Twilio integration replicates data using the Twilio REST API . Refer to the Schema section for a list of objects available for replication.

Twilio feature snapshot

A high-level look at Stitch's Twilio (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Beta	Supported by	Stitch
Stitch plan	Standard	API availability	Available
Singer GitHub repository	singer-io/tap-twilio
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting Twilio

Step 1: Retrieve Auth token and Account SID

Log into your Twilio account.
Click on Console.
Copy your Account SID and Auth Token and have it ready for the next step.

Step 2: Add Twilio as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the Twilio icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch Twilio” would create a schema called stitch_twilio in the destination. Note: Schema names cannot be changed after you save the integration.
In the Account Sid field, paste the Account SID you copied in step 1.
In the Auth Token field, paste the Auth Token you copied in step 1.
In the Date Window Days field, enter a value. This parameter should be set to an optimum value to improve historical sync performance. Setting this value too low will take longer to complete historical sync and setting it larger may result in request timeouts or memory overflow issues. The default value is 30.

Step 3: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Twilio integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Twilio’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 4: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Twilio integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 5: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Twilio integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Twilio, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

Twilio table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 1 of this integration.

This is the latest version of the Twilio integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

account_balance

The account_balance returns your Twilio account balance.

Replication Method

Full Table

Primary Key

account_sid

Useful links

account_balance schema on GitHub

account_balance table schema

account_sid

STRING

balance

NUMBER

currency

STRING

accounts

The accounts table returns a list of accounts in your Twilio account.

Replication Method

Full Table

Primary Key

sid

Useful links

Twilio documentation

accounts schema on GitHub

Twilio API method

accounts table schema

auth_token

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

friendly_name

STRING

owner_account_sid

STRING

sid

STRING

status

STRING

subresource_uris

ARRAY

Click to expand subresource_uris

subresource

STRING

uri

STRING

OBJECT

Click to expand uri

type

STRING

uri

STRING

addresses

The addresses table returns a list of address resource representations, each representing an address within your Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation addresses schema on GitHub Twilio API method

addresses table schema

account_sid

STRING

city

STRING

customer_name

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

emergency_enabled

BOOLEAN

friendly_name

STRING

iso_country

STRING

postal_code

STRING

region

STRING

sid

STRING

street

STRING

uri

STRING

validated

BOOLEAN

verified

BOOLEAN

alerts

The alerts returns a list of alerts generated for an account within your Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation alerts schema on GitHub Twilio API method

alerts table schema

account_sid

STRING

alert_text

STRING

api_version

STRING

date_created

DATE-TIME

date_generated

DATE-TIME

date_updated

DATE-TIME

error_code

STRING

log_level

STRING

more_info

STRING

request_method

STRING

request_url

STRING

resource_sid

STRING

service_sid

STRING

sid

STRING

url

STRING

applications

The applications table returns a list of application resource representations, each representing an application within your Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_created
Useful links	Twilio documentation applications schema on GitHub Twilio API method

applications table schema

account_sid

STRING

api_version

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

friendly_name

STRING

message_status_callback

STRING

sid

STRING

sms_fallback_method

STRING

sms_fallback_url

STRING

sms_method

STRING

sms_status_callback

STRING

sms_url

STRING

status_callback

STRING

status_callback_method

STRING

uri

STRING

voice_callback_id_lookup

BOOLEAN

voice_fallback_method

STRING

voice_fallback_url

STRING

voice_method

STRING

voice_url

STRING

available_phone_number_countries

The available_phone_number_countries table returns a list of countries that have phone numbers to purchase for your Twilio account.

Replication Method

Full Table

Primary Key

country_code

Useful links

Twilio documentation

available_phone_number_countries schema on GitHub

Twilio API method

available_phone_number_countries table schema

beta

BOOLEAN

country

STRING

country_code

STRING

subresource_uris

ARRAY

Click to expand subresource_uris

subresource

STRING

uri

STRING

OBJECT

Click to expand uri

uri

STRING

available_phone_numbers_local

The available_phone_numbers_local table returns a list of available phone numbers for local resources for your Twilio account.

Replication Method

Full Table

Primary Keys

iso_country

phone_number

Useful links

available_phone_numbers_local schema on GitHub

Twilio API method

available_phone_numbers_local table schema

address_requirements

STRING

beta

BOOLEAN

capabilities

OBJECT

Click to expand capabilities

MMS

BOOLEAN

SMS

BOOLEAN

fax

BOOLEAN

voice

BOOLEAN

friendly_name

STRING

iso_country

STRING

lata

STRING

latitude

NUMBER

STRING

locality

STRING

longitude

NUMBER

STRING

phone_number

STRING

postal_code

STRING

rate_center

STRING

region

STRING

available_phone_numbers_mobile

The available_phone_numbers_mobile table returns a list of available phone numbers for mobile resources for your Twilio account.

Replication Method

Full Table

Primary Keys

iso_country

phone_number

Useful links

Twilio documentation

available_phone_numbers_mobile schema on GitHub

Twilio API method

available_phone_numbers_mobile table schema

address_requirements

STRING

beta

BOOLEAN

capabilities

OBJECT

Click to expand capabilities

MMS

BOOLEAN

SMS

BOOLEAN

fax

BOOLEAN

voice

BOOLEAN

friendly_name

STRING

iso_country

STRING

lata

STRING

latitude

NUMBER

STRING

locality

STRING

longitude

NUMBER

STRING

phone_number

STRING

postal_code

STRING

rate_center

STRING

region

STRING

available_phone_numbers_toll_free

The available_phone_numbers_toll_free table returns a list of available toll free phone numbers for your Twilio account.

Replication Method

Full Table

Primary Keys

iso_country

phone_number

Useful links

Twilio documentation

available_phone_numbers_toll_free schema on GitHub

Twilio API method

available_phone_numbers_toll_free table schema

address_requirements

STRING

beta

BOOLEAN

capabilities

OBJECT

Click to expand capabilities

MMS

BOOLEAN

SMS

BOOLEAN

fax

BOOLEAN

voice

BOOLEAN

friendly_name

STRING

iso_country

STRING

lata

STRING

latitude

NUMBER

STRING

locality

STRING

longitude

NUMBER

STRING

phone_number

STRING

postal_code

STRING

rate_center

STRING

region

STRING

calls

The calls table returns a list of phone calls made to and from an account in your Twilio account, identified by its AccountSid.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation calls schema on GitHub Twilio API method

calls table schema

account_sid

STRING

annotation

STRING

answered_by

STRING

api_version

STRING

caller_name

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

direction

STRING

duration

INTEGER

end_time

DATE-TIME

forwarded_from

STRING

from

STRING

from_formatted

STRING

group_sid

STRING

parent_call_sid

STRING

phone_number_sid

STRING

price

NUMBER

price_unit

STRING

queue_time

INTEGER

sid

STRING

start_time

DATE-TIME

status

STRING

subresource_uris

ARRAY

Click to expand subresource_uris

subresource

STRING

uri

STRING

OBJECT

Click to expand uri

STRING

to_formatted

STRING

trunk_sid

STRING

uri

STRING

conference_participants

The conference_participants table returns the list of active participants in the Twilio conference identified by ConferenceSid.

Replication Method

Full Table

Primary Key

uri

Useful links

Twilio documentation

conference_participants schema on GitHub

Twilio API method

conference_participants table schema

account_sid

STRING

call_sid

STRING

call_sid_to_coach

STRING

coaching

BOOLEAN

conference_sid

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

end_conference_on_exit

BOOLEAN

hold

BOOLEAN

label

STRING

muted

BOOLEAN

start_conference_on_enter

BOOLEAN

status

STRING

uri

STRING

conferences

The conferences table returns all the conferences within your Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation conferences schema on GitHub Twilio API method

conferences table schema

account_sid

STRING

api_version

STRING

call_sid_ending_conference

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

friendly_name

STRING

reason_conference_ended

STRING

region

STRING

sid

STRING

status

STRING

subresource_uris

ARRAY

Click to expand subresource_uris

subresource

STRING

uri

STRING

uri

STRING

dependent_phone_numbers

The dependent_phone_numbers table returns a list of IncomingPhoneNumbers in your Twilio account that require the specified address.

Replication Method

Full Table

Primary Key

sid

Useful links

dependent_phone_numbers schema on GitHub

Twilio API method

dependent_phone_numbers table schema

account_sid

STRING

address_requirements

STRING

api_version

STRING

capabilities

OBJECT

Click to expand capabilities

fax

BOOLEAN

mms

BOOLEAN

sms

BOOLEAN

voice

BOOLEAN

date_created

DATE-TIME

date_updated

DATE-TIME

emergency_address_sid

STRING

emergency_status

STRING

friendly_name

STRING

phone_number

STRING

sid

STRING

sms_application_sid

STRING

sms_fallback_method

STRING

sms_fallback_url

STRING

sms_method

STRING

sms_url

STRING

status_callback

STRING

status_callback_method

STRING

trunk_sid

STRING

uri

STRING

voice_application_sid

STRING

voice_caller_id_lookup

BOOLEAN

voice_fallback_method

STRING

voice_fallback_url

STRING

voice_method

STRING

voice_url

STRING

incoming_phone_numbers

The incoming_phone_numbers table returns a list of IncomingPhoneNumbers in your Twilio account that require the specified address.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation incoming_phone_numbers schema on GitHub Twilio API method

incoming_phone_numbers table schema

account_sid

STRING

address_requirements

STRING

address_sid

STRING

api_version

STRING

beta

BOOLEAN

bundle_sid

STRING

capabilities

OBJECT

Click to expand capabilities

fax

BOOLEAN

mms

BOOLEAN

sms

BOOLEAN

voice

BOOLEAN

date_created

DATE-TIME

date_updated

DATE-TIME

emergency_address_sid

STRING

emergency_address_status

STRING

emergency_status

STRING

friendly_name

STRING

identity_sid

STRING

origin

STRING

phone_number

STRING

sid

STRING

sms_application_sid

STRING

sms_fallback_method

STRING

sms_fallback_url

STRING

sms_method

STRING

sms_url

STRING

status

STRING

status_callback

STRING

status_callback_method

STRING

trunk_sid

STRING

uri

STRING

voice_application_sid

STRING

voice_caller_id_lookup

BOOLEAN

voice_fallback_method

STRING

voice_fallback_url

STRING

voice_method

STRING

voice_receive_mode

STRING

voice_url

STRING

keys

The keys table returns a list of API Keys in your Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	keys schema on GitHub Twilio API method

keys table schema

account_sid

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

friendly_name

STRING

sid

STRING

message_media

The message_media table returns the list of media associated with your Twilio message.

Replication Method

Full Table

Primary Key

sid

Useful links

Twilio documentation

message_media schema on GitHub

Twilio API method

message_media table schema

account_sid

STRING

content_type

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

parent_sid

STRING

sid

STRING

uri

STRING

messages

The messages table returns a list of messages associated with your Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation messages schema on GitHub Twilio API method

messages table schema

account_sid

STRING

api_version

STRING

body

STRING

date_created

DATE-TIME

date_sent

DATE-TIME

date_updated

DATE-TIME

direction

STRING

error_code

STRING

error_message

STRING

from

STRING

messaging_service_sid

STRING

num_media

INTEGER

num_segments

INTEGER

price

NUMBER

price_unit

STRING

sid

STRING

status

STRING

subresource_uris

ARRAY

Click to expand subresource_uris

subresource

STRING

uri

STRING

OBJECT

Click to expand uri

STRING

uri

STRING

outgoing_caller_ids

The outgoing_caller_ids table returns a list of OutgoingCallerId resource representations, each representing a Caller ID number valid for a Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	outgoing_caller_ids schema on GitHub Twilio API method

outgoing_caller_ids table schema

account_sid

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

friendly_name

STRING

phone_number

STRING

sid

STRING

uri

STRING

queues

The queues table returns the list of call queues within your Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation queues schema on GitHub Twilio API method

queues table schema

account_sid

STRING

average_wait_time

INTEGER

current_size

INTEGER

date_created

DATE-TIME

date_updated

DATE-TIME

friendly_name

STRING

max_size

INTEGER

sid

STRING

subresource_uris

ARRAY

Click to expand subresource_uris

subresource

STRING

uri

STRING

uri

STRING

recordings

The recordings table returns a list of recordings, each representing a recording generated during a call or conference in your Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_created
Useful links	Twilio documentation recordings schema on GitHub Twilio API method

recordings table schema

account_sid

STRING

api_version

STRING

call_sid

STRING

channels

INTEGER

conference_sid

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

duration

INTEGER

encryption_details

OBJECT

Click to expand encryption_details

encryption_cek

STRING

encryption_public_key_sid

STRING

type

STRING

error_code

STRING

price

NUMBER

price_unit

STRING

sid

STRING

source

STRING

start_time

DATE-TIME

status

STRING

subresource_uris

ARRAY

Click to expand subresource_uris

subresource

STRING

uri

STRING

OBJECT

Click to expand uri

uri

STRING

transcriptions

The transcriptions table returns the full set of transcriptions generated from all recordings in your Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation transcriptions schema on GitHub Twilio API method

transcriptions table schema

account_sid

STRING

api_version

STRING

date_created

DATE-TIME

date_updated

DATE-TIME

duration

INTEGER

price

NUMBER

price_unit

STRING

recording_sid

STRING

sid

STRING

status

STRING

transcription_text

STRING

type

STRING

uri

STRING

usage_records

The usage_records table returns a list of usage records in your Twilio account.

Replication Method	Key-based Incremental
Primary Keys	account_sid category start_date
Replication Key	start_date
Useful links	Twilio documentation usage_records schema on GitHub Twilio API method

usage_records table schema

account_sid

STRING

api_version

STRING

as_of

DATE-TIME

category

STRING

count

INTEGER

STRING

count_unit

STRING

description

STRING

end_date

DATE-TIME

price

NUMBER

price_unit

STRING

start_date

DATE-TIME

subresource_uris

ARRAY

Click to expand subresource_uris

subresource

STRING

uri

STRING

OBJECT

Click to expand uri

uri

STRING

usage

NUMBER

STRING

usage_unit

STRING

usage_triggers

The usage_triggers table returns list of usage triggers in your Twilio account.

Replication Method	Key-based Incremental
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation usage_triggers schema on GitHub Twilio API method

usage_triggers table schema

account_sid

STRING

api_version

STRING

callback_method

STRING

callback_url

STRING

current_value

NUMBER

date_created

DATE-TIME

date_fired

DATE-TIME

date_updated

DATE-TIME

friendly_name

STRING

recurring

STRING

sid

STRING

trigger_by

STRING

trigger_value

NUMBER

uri

STRING

usage_category

STRING

usage_record_uri

STRING

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Syncing Historical SaaS Data Resetting Replication Keys Nested Data Structures & Row Count Impact	Third-Party Downtime Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues