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.

便利なリンクやサポートされている機能など、このコネクタの概要について説明します。

機能/性能	サポートの詳細
サポートされている Qlik Talend Data Integration プロジェクト	レプリケーションプロジェクトのみ。データパイプラインプロジェクトはサポートされていません。
ターゲットの更新方法	レプリケーションタスク: 変更を適用変更の保存データレイクタスクにデータをランディング: 変更データキャプチャ (CDC)
メタデータの管理	手動でのメタデータ生成は必要ありません。
スキーマの進化	[列のデータ型を変更] 操作のみサポートされています。
LOB 列 (NCLOB、CLOB、BLOB) のレプリケーション	サポートされていません。
スケジュールされた CDC	必須。これにより、ソースの変更に応じてターゲットが最新の状態に保たれます。レプリケーションタスクについては、「レプリケーションタスクの CDC のスケジュール設定」を参照してください。レイクランディングタスクについては、「レイクランディングタスクの CDC のスケジュール設定」を参照してください。
通知	部分的にサポート動作変更時の通知の設定
監視	このコネクタではフルロードは関係ないため、CDC のみ。個々のデータタスクの監視
JSON 列ペイロードの自動ネスト解除	サポートされていません。ソースデータセット内の JSON 列ペイロードは、ターゲット上で自動的にネスト解除されません。

Preparing for authentication

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

使用するアカウントに、フェッチするテーブルへのアクセス権があることを確認してください。

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

詳細については、「SaaSアプリケーションへの接続」を参照してください。

必要な接続プロパティを入力します。
接続名に接続の名前を入力します。
接続メタデータを開くを選択して、作成時の接続のメタデータを定義します。
[作成] をクリックします。

Connection settings
Setting	Description
Data gateway	ユースケースに応じて Data Movement gateway を選択します。情報メモ Qlik Talend Cloud スターターサブスクリプションでは Data Movement gateway をサポートしていないため、この項目は使用できません。別のサブスクリプションティアを利用しており、Data Movement gateway を使用しない場合は、 [None] (なし) を選択します。 Data Movement gateway の利点とそれを必要とするユースケースの詳細については、「Qlik Data Gateway - Data Movement」を参照してください。
Start Date	ソースからターゲットにデータをレプリケートする必要がある日付を `MM/DD/YYYY` 形式で入力します。
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

このページは役に立ちましたか?

このページまたはコンテンツにタイポ、ステップの省略、技術的エラーなどの問題が見つかった場合はお知らせください。

こちらにフィードバックをお寄せください