Twilio is currently in beta. The info in this guide is subject to change.
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 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] (https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| Stitch plan |
Standard |
API availability |
Available |
| Singer GitHub repository | |||
| 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_twilioin 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
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:
-
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
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.
- 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.
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.
|
Full Table |
|
|
Primary Key |
account_sid |
| Useful links |
|
account_sid
STRING |
|
balance NUMBER |
|
currency STRING |
accounts
The accounts table returns a list of accounts in your Twilio account.
|
Full Table |
|
|
Primary Key |
sid |
| Useful links |
|
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
OBJECT |
||
|
type STRING |
||
|
uri STRING |
addresses
The addresses table returns a list of address resource representations, each representing an address within your Twilio account.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
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.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
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.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_created |
| Useful links |
|
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.
|
Full Table |
|
|
Primary Key |
country_code |
| Useful links |
|
beta BOOLEAN |
||
|
country STRING |
||
|
country_code
STRING |
||
|
subresource_uris
ARRAY
OBJECT |
||
|
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.
|
Full Table |
|
|
Primary Keys |
iso_country phone_number |
| Useful links |
|
address_requirements STRING |
||||
|
beta BOOLEAN |
||||
|
capabilities OBJECT
|
||||
|
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.
|
Full Table |
|
|
Primary Keys |
iso_country phone_number |
| Useful links |
|
address_requirements STRING |
||||
|
beta BOOLEAN |
||||
|
capabilities OBJECT
|
||||
|
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.
|
Full Table |
|
|
Primary Keys |
iso_country phone_number |
| Useful links |
|
address_requirements STRING |
||||
|
beta BOOLEAN |
||||
|
capabilities OBJECT
|
||||
|
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.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
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
OBJECT |
||
|
to 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.
|
Full Table |
|
|
Primary Key |
uri |
| Useful links |
|
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.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
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
|
||
|
uri STRING |
dependent_phone_numbers
The dependent_phone_numbers table returns a list of IncomingPhoneNumbers in your Twilio account that require the specified address.
|
Full Table |
|
|
Primary Key |
sid |
| Useful links |
|
account_sid STRING |
||||
|
address_requirements STRING |
||||
|
api_version STRING |
||||
|
capabilities OBJECT
|
||||
|
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.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
account_sid STRING |
||||
|
address_requirements STRING |
||||
|
address_sid STRING |
||||
|
api_version STRING |
||||
|
beta BOOLEAN |
||||
|
bundle_sid STRING |
||||
|
capabilities OBJECT
|
||||
|
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.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
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.
|
Full Table |
|
|
Primary Key |
sid |
| Useful links |
|
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.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
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
OBJECT |
||
|
to 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.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
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.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
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
|
||
|
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.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_created |
| Useful links |
|
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
|
||||
|
error_code STRING |
||||
|
price NUMBER |
||||
|
price_unit STRING |
||||
|
sid
STRING |
||||
|
source STRING |
||||
|
start_time DATE-TIME |
||||
|
status STRING |
||||
|
subresource_uris
ARRAY
OBJECT |
||||
|
uri STRING |
transcriptions
The transcriptions table returns the full set of transcriptions generated from all recordings in your Twilio account.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
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.
|
Key-based Incremental |
|
|
Primary Keys |
account_sid category start_date |
|
Replication Key |
start_date |
| Useful links |
|
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
OBJECT |
||
|
uri STRING |
||
|
usage
NUMBER STRING |
||
|
usage_unit STRING |
usage_triggers
The usage_triggers table returns list of usage triggers in your Twilio account.
|
Key-based Incremental |
|
|
Primary Key |
sid |
|
Replication Key |
date_updated |
| Useful links |
|
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 |
| Related | Troubleshooting |
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.