Twilio

Twilio is a customer engagement platform.

For more information about the API, see Twilio REST API .

See the Schema section for a list of objects available for replication.See the Schema section for a list of objects available for replication.

A high-level look at this connector, including useful links, and supported features.

Feature/Capability	Support details
Supported Qlik Talend Data Integration projects	Replication projects only. Data pipeline projects are not supported.
Target update methods	Replication tasks: Apply changes Store changes Landing data in a data lake tasks: Change data capture (CDC)
Managing metadata	Manual metadata generation is not required.
Schema evolution	Only the Change column data type operation is supported.
Replication of LOB columns (NCLOB, CLOB, and BLOB)	Not supported.
Scheduled CDC	Required. This is how the target is kept up-to-date with changes to the source. For replication tasks, see Scheduling CDC for replication tasks For lake landing tasks, see Scheduling CDC for lake landing tasks
Notifications	Partially supported Setting notifications for changes in operation
Monitoring	CDC-only, as full load is not relevant for this connector. Monitoring an individual data task
Automatic denesting of JSON column payloads	Not supported. JSON column payloads in source datasets are not denested automatically on the target.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Make sure that the account you use has read access to the tables you want to fetch.

To obtain the Account SID and Auth token:

Log into your Twilio account.
Click Console.
Copy your Account SID and Auth Token.

Creating the connection

For more information, see Connecting to SaaS applications.

Fill in the required connection properties.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.
Click Create.

Connection settings
Setting	Description
Data gateway	Select a Data Movement gateway if required by your use case. Information note This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None. For information on the benefits of Data Movement gateway and use cases that require it, see Qlik Data Gateway - Data Movement.
Start Date	Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target.
Account SID	Account SID.
Auth Token	Authentication token.
Date Window Days	Enter a value. Example: 30. 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.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

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

account_balance

The account_balance returns your Twilio account balance.

Replication Method

Full Table

Primary Key

account_sid

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

Twilio API method

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

This is a nested data structure:

subresource: STRING
uri: STRING

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	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation Twilio API method

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	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation Twilio API method

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	CDC
Primary Key	sid
Replication Key	date_created
Useful links	Twilio documentation Twilio API method

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

Twilio API method

beta

BOOLEAN

country

STRING

country_code

STRING

subresource_uris

ARRAY

This is a nested data structure:

subresource: STRING
uri: STRING

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

Twilio API method

address_requirements

STRING

beta

BOOLEAN

capabilities

OBJECT

This is a nested data structure:

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

Twilio API method

address_requirements

STRING

beta

BOOLEAN

capabilities

OBJECT

This is a nested data structure:

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

Twilio API method

address_requirements

STRING

beta

BOOLEAN

capabilities

OBJECT

This is a nested data structure:

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	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation Twilio API method

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

This is a nested data structure:

subresource: STRING
uri: STRING

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

Twilio API method

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	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation Twilio API method

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

This is a nested data structure:

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

Twilio API method

account_sid

STRING

address_requirements

STRING

api_version

STRING

capabilities

OBJECT

This is a nested data structure:

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	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation Twilio API method

account_sid

STRING

address_requirements

STRING

address_sid

STRING

api_version

STRING

beta

BOOLEAN

bundle_sid

STRING

capabilities

OBJECT

This is a nested data structure:

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	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio API method

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

Twilio API method

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	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation Twilio API method

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

This is a nested data structure:

subresource: STRING
uri: STRING

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	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio API method

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	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation Twilio API method

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

This is a nested data structure:

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	CDC
Primary Key	sid
Replication Key	date_created
Useful links	Twilio documentation Twilio API method

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

This is a nested data structure:

encryption_cek: STRING
encryption_public_key_sid: STRING
iv: STRING
type: STRING

error_code

STRING

price

NUMBER

price_unit

STRING

sid

STRING

source

STRING

start_time

DATE-TIME

status

STRING

subresource_uris

ARRAY

This is a nested data structure:

subresource: STRING
uri: STRING

uri

STRING

transcriptions

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

Replication Method	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation Twilio API method

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	CDC
Primary Keys	account_sid category start_date
Replication Key	start_date
Useful links	Twilio documentation Twilio API method

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

This is a nested data structure:

subresource: STRING
uri: STRING

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	CDC
Primary Key	sid
Replication Key	date_updated
Useful links	Twilio documentation Twilio API method

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here