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에만 해당되며, 이 커넥터의 경우 전체 로드가 적용되지 않습니다. 개별 데이터 작업 모니터링
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	사용 사례에 필요한 경우 데이터 이동 게이트웨이를 선택합니다. 정보 메모 이 필드는 데이터 이동 게이트웨이를 지원하지 않으므로 Qlik Talend Cloud 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이를 사용하지 않으려면 없음을 선택합니다. 데이터 이동 게이트웨이의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 Qlik 데이터 게이트웨이 - 데이터 이동를 참조하십시오.
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

이 페이지가 도움이 되었습니까?

이 페이지 또는 해당 콘텐츠에서 오타, 누락된 단계 또는 기술적 오류와 같은 문제를 발견하면 알려 주십시오!

여기에 피드백을 남겨주십시오.