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.

Ogólne informacje o tym łączniku, w tym przydatne linki i obsługiwane cechy.

Cecha/możliwość	Szczegóły obsługi
Wspierane projekty Qlik Talend Data Integration	Tylko projekty replikacji. Projekty potoków danych nie są obsługiwane.
Metody aktualizacji celu	Zadania replikacji: Zastosuj zmiany Zapisz zmiany Umieszczanie danych w zadaniach jeziora danych: Przechwytywanie zmian danych (CDC)
Zarządzanie metadanymi	Ręczne tworzenie metadanych nie jest wymagane.
Ewolucja schematu	Obsługiwana jest tylko operacja Zmień typ danych kolumny.
Replikacja kolumn LOB (NCLOB, CLOB i BLOB)	Brak obsługi.
Zaplanowane CDC	Wymagane. W ten sposób cel jest na bieżąco informowany o zmianach w źródle. W kwestii zadań replikacji zobacz Planowanie CDC dla zadań replikacji W sprawie zadań umieszczania w jeziorze zobacz Harmonogram CDC dla zadań umieszczania w jeziorze
Powiadomienia	Częściowa obsługa Ustawianie powiadomień o zmianach w działaniu
Monitorowanie	Tylko CDC, ponieważ pełne ładowanie jest nieodpowiednie dla tego łącznika. Monitorowanie indywidualnego zadania danych
Automatyczne eliminowanie zagnieżdżeń zawartości kolumn JSON	Brak obsługi. Ładunki kolumn JSON w źródłowych zestawach danych nie są automatycznie rozwijane w docelowych.

Preparing for authentication

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

Upewnij się, że używane konto ma uprawnienia do odczytu interesujących Cię tabel.

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

Więcej informacji zawiera temat Łączenie się z aplikacjami SaaS.

Wprowadź wymagane właściwości połączenia.
Podaj nazwę połączenia w polu Nazwa połączenia.
Wybierz opcję Otwórz metadane połączenia, aby zdefiniować metadane połączenia po jegu utworzeniu.
Kliknij polecenie Utwórz.

Connection settings
Setting	Description
Data gateway	Wybierz bramę Data Movement gateway, jeżeli jest wymagana do danego zastosowania. Informacja To pole jest niedostępne w subskrypcji Qlik Talend Cloud Starter, ponieważ brama Data Movement gateway jest w niej nieobsługiwana. Jeśli masz inny poziom subskrypcji i nie chcesz korzystać z bramy Data Movement gateway, wybierz opcję Brak. Informacje o zaletach bramy Data Movement gateway i o okolicznościach, w których jest wymagana, zawiera temat Qlik Data Gateway - Data Movement.
Start Date	Wprowadź datę, w formacie `MM/DD/YYYY`, od której dane muszą być replikowane ze źródła do celu.
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

Czy ta strona była pomocna?

Jeżeli natkniesz się na problemy z tą stroną lub jej zawartością — literówkę, brakujący krok lub błąd techniczny — daj nam znać, co możemy poprawić!

Przekaż tu opinię