Kustomer
Kustomer is a cloud-based solution, which helps small to large businesses streamline communication and provide client support via multiple channels.
Kustomer integration replicates data using the Kustomer REST API v1.
See the
Schema section for a list of objects available for replication.
유용한 링크와 지원되는 기능을 포함하여 이 커넥터에 대한 전반적인 내용을 살펴보겠습니다.
| 특징/기능 | 지원 세부 정보 |
|---|
| 지원되는 Qlik Talend Data Integration 프로젝트 | 복제 프로젝트에만 해당됩니다. 데이터 파이프라인 프로젝트는 지원되지 않습니다. |
대상 업데이트 방법 | 복제 작업: 데이터 레이크 작업에 데이터 랜딩: |
메타데이터 관리 | 수동 메타데이터 생성이 필요하지 않습니다. |
스키마 진화 | 열 데이터 유형 변경 작업만 지원됩니다. |
| 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.
정보 메모사용하는 계정에 가져오려는 테이블에 대한 읽기 액세스 권한이 있는지 확인합니다.
Creating the connection
자세한 내용은 SaaS 응용 프로그램에 연결을 참조하십시오.
- 필요한 연결 속성을 입력합니다.
연결 이름에 연결 이름을 입력합니다.
연결이 만들어질 때 연결에 대한 메타데이터를 정의하려면 연결 메타데이터 열기를 선택합니다.
만들기를 클릭합니다.
Connection settings| Setting | Description |
|---|
| Data gateway | 사용 사례에 필요한 경우 데이터 이동 게이트웨이를 선택합니다. 정보 메모이 필드는 데이터 이동 게이트웨이를 지원하지 않으므로 Qlik Talend Cloud 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이를 사용하지 않으려면 없음을 선택합니다. 데이터 이동 게이트웨이의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 Qlik 데이터 게이트웨이 - 데이터 이동를 참조하십시오. |
| Start Date | 데이터를 소스에서 대상으로 복제해야 하는 날짜를 MM/DD/YYYY 형식으로 입력합니다. |
| API Token | API token. |
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.
conversations
The conversations table contains information about conversations in the Kustomer app.
assigned_teams
ARRAY
This is a nested data structure. |
assigned_users
ARRAY
This is a nested data structure. |
channels
ARRAY
This is a nested data structure. |
created_at
STRING
|
created_by
OBJECT
This is a nested data structure: |
custom
OBJECT
This is a nested data structure: - auto_response_at: STRING
- brand_str: STRING
- business_area_str: STRING
- case_id_str: STRING
- close_out_tree: STRING
- contact_reason_tree: STRING
- desk_ticket_url: STRING
- issue_report_tree: STRING
- new_primary_menu_str: STRING
- order_number_id: STRING
- refund_status_str: STRING
- return_requested_str: STRING
- return_str: STRING
- rma_id_str: STRING
- serial_number_str: STRING
- shopify_order_str: STRING
- yale_call_reason_tree: STRING
- yale_connectivity_str: STRING
- yale_finish_str: STRING
- yale_model_str: STRING
- yale_notes_txt: STRING
- yale_resolution_str: STRING
- yale_serial_number_str: STRING
|
customer
OBJECT
This is a nested data structure: |
direction
STRING
|
done_count
INTEGER
|
ended
BOOLEAN
|
ended_at
STRING
|
ended_by
OBJECT
This is a nested data structure: |
ended_by_type
STRING
|
ended_reason
STRING
|
external_id
STRING
|
first_done
OBJECT
This is a nested data structure: - assigned_teams: ARRAY, which is also a nested data structure.
- assigned_users: ARRAY, which is also a nested data structure.
- business_time: INTEGER
- created_at: STRING
- created_by: STRING
- created_by_teams: ARRAY, which is also a nested data structure.
- last_message_direction: STRING
- last_message_direction_type: STRING
- message_count: INTEGER
- message_count_by_channel: OBJECT, which is also a nested data structure.
- email: INTEGER
- sms: INTEGER
- voice: INTEGER
- note_count: INTEGER
- outbound_message_count: INTEGER
- outbound_message_count_by_channel: OBJECT, which is is also a nested data structure.
- email: INTEGER
- sms: INTEGER
- voice: INTEGER
- time: INTEGER
|
first_message_in
OBJECT
This is a nested data structure: - channel: STRING
- created_at: STRING
- direction_type: STRING
- id: STRING
- sent_at: STRING
|
first_message_out
OBJECT
This is a nested data structure: - channel: STRING
- created_at: STRING
- created_by: STRING
- created_by_teams: ARRAY, which is also a nested data structure.
- direction_type: STRING
- id: STRING
- sent_at: STRING
|
first_response
OBJECT
This is a nested data structure: - assigned_teams: ARRAY, which is also a nested data structure.
- assigned_users: ARRAY, which is also a nested data structure.
- business_time: INTEGER
- created_at: STRING
- created_by: STRING
- created_by_teams: ARRAY, which is also a nested data structure.
- id: STRING
- response_time: INTEGER
- sent_at: STRING
- time: INTEGER
|
first_response_since_last_done
OBJECT
This is a nested data structure: - assigned_teams: ARRAY, which is also a nested data structure.
- assigned_users: ARRAY, which is also a nested data structure.
- business_time: INTEGER
- created_at: STRING
- created_by: STRING
- created_by_teams: ARRAY, which is also a nested data structure.
- id: STRING
- response_time: INTEGER
- sent_at: STRING
- time: INTEGER
|
id
STRING
|
imported_at
STRING
|
last_activity_at
STRING
|
last_done
OBJECT
This is a nested data structure: - assigned_teams: ARRAY, which is also a nested data structure.
- assigned_users: ARRAY, which is also a nested data structure.
- business_time: INTEGER
- created_at: STRING
- created_by: STRING
- created_by_teams: ARRAY, which is also a nested data structure.
- last_message_direction: STRING
- last_message_direction_type: INTEGER
- message_count: STRING
- message_count_by_channel: OBJECT, which is also a nested data structure.
- email: INTEGER
- sms: INTEGER
- voice: INTEGER
- note_count: INTEGER
- outbound_message_count: INTEGER
- outbound_message_count_by_channel: OBJECT, which is also a nested data structure.
- email: INTEGER
- sms: INTEGER
- voice: INTEGER
- time: INTEGER
|
last_message_at
STRING
|
last_message_direction
STRING
|
last_message_in
OBJECT
This is a nested data structure: - created_at: STRING
- id: STRING
- sent_at: STRING
|
last_message_out
OBJECT
This is a nested data structure: - created_at: STRING
- id: STRING
- sent_at: STRING
|
last_message_unresponded_to
OBJECT
This is a nested data structure: - created_at: STRING
- id: STRING
- sent_at: STRING
|
last_message_unresponded_to_since_last_done
OBJECT
This is a nested data structure: - created_at: STRING
- id: STRING
- sent_at: STRING
|
last_received_at
STRING
|
last_response
OBJECT
This is a nested data structure: - assigned_teams: ARRAY, which is also a nested data structure.
- assigned_users: ARRAY, which is also a nested data structure.
- business_time: INTEGER
- created_at: STRING
- created_by: STRING
- created_by_teams: ARRAY, which is also a nested data structure.
- id: STRING
- time: INTEGER
|
links
OBJECT
This is a nested data structure: |
merged_target
BOOLEAN
|
message_count
INTEGER
|
modified_at
STRING
|
modified_by
OBJECT
This is a nested data structure: |
name
STRING
|
note_count
INTEGER
|
org
OBJECT
This is a nested data structure: |
outbound_message_count
INTEGER
|
preview
STRING
|
priority
INTEGER
|
queue
OBJECT
This is a nested data structure: |
reopen_count
INTEGER
|
rev
INTEGER
|
role_group_versions
STRING
|
satisfaction
STRING
|
satisfaction_level
OBJECT
This is a nested data structure: - sent_by_teams: ARRAY, which is also a nested data structure.
|
sla
OBJECT
This is a nested data structure: - breach: OBJECT, which is also a nested data structure.
- breached: BOOLEAN
- matched_at: STRING
- metrics: OBJECT, which is also a nested data structure.
- first_response: OBJECT, which is also a nested data structure.
- breach_at: STRING
- satisfied_at: STRING
- longest_unresponded_message: OBJECT, which is also a nested data structure.
- breach_at: STRING
- satisfied_at: STRING
- status: STRING
- summary: OBJECT, which is also a nested data structure.
- first_breach_at: STRING
- satisfied_at: STRING
- version: INTEGER
|
sla_data
OBJECT
This is a nested data structure: |
sla_version
OBJECT
This is a nested data structure: |
snooze
OBJECT
This is a nested data structure: - status: STRING
- status_at: STRING
- time: STRING
|
snooze_count
INTEGER
|
status
STRING
|
suggested_shortcuts
STRING
|
suggested_tags
STRING
|
tags
ARRAY
This is a nested data structure. |
total_done
OBJECT
This is a nested data structure: - business_time: INTEGER
- time: INTEGER
|
total_open
OBJECT
This is a nested data structure: - business_time: INTEGER
- business_time_since_last_done: INTEGER
- time: INTEGER
- time_since_last_done: INTEGER
|
total_snooze
OBJECT
This is a nested data structure: - business_time: INTEGER
- time: INTEGER
|
type
STRING
|
updated_at
STRING
|
customers
The customers table contains information about customers in the Kustomer app.
active_users
STRING
|
avatar_url
STRING
|
birthday_at
STRING
|
conversation_counts
OBJECT
This is a nested data structure: - all: INTEGER
- done: INTEGER
- open: INTEGER
- snoozed: INTEGER
|
created_at
STRING
|
created_by
OBJECT
This is a nested data structure: |
custom
OBJECT
This is a nested data structure: - accepts_marketing_bool: BOOLEAN
- activation_date_str: STRING
- app_version_str: STRING
- august_id_str: STRING
- august_serial_number_str: STRING
- bridge_date_installed_at: STRING
- bridge_serial_number_str: STRING
- connect_firmware_version_str: STRING
- connect_serial_number_str: STRING
- doorbell_date_installed_at: STRING
- doorbell_firmware_version_str: STRING
- doorbell_serial_str: STRING
- firmware_version_str: STRING
- keypad_firmware_version_str: STRING
- keypad_installed_at: STRING
- keypad_serial_str: STRING
- last_autoresponse_at: STRING
- last_order_id_num: INTEGER
- last_order_name_str: STRING
- latest_csat_num: INTEGER
- latest_nps_num: INTEGER
- lock_date_installed_at: STRING
- lock_firmware_version_str: STRING
- lock_serial_number_str: STRING
- orders_count_num: INTEGER
- os00_str: STRING
- owner_guest_str: STRING
- products_owned_str: STRING
- proof_of_purchase_str: STRING
- purchase_date_str: STRING
- sales_force_id_str: STRING
- total_spent_num: INTEGER
|
deleted
STRING
|
display_color
STRING
|
display_icon
STRING
|
display_name
STRING
|
emails
ARRAY
This is a nested data structure: - email: STRING
- type: STRING
- verified: BOOLEAN
|
external_id
STRING
|
external_ids
ARRAY
This is a nested data structure: - external_id: STRING
- verified: BOOLEAN
|
facebook_ids
STRING
|
first_name
STRING
|
gender
STRING
|
id
STRING
|
imported_at
DATE-TIME
|
instagram_ids
STRING
|
last_activity_at
DATE-TIME
|
last_conversation
OBJECT
This is a nested data structure: - channels: ARRAY, which is also a nested data structure.
- id: STRING
- sentiment: OBJECT, which is also a nested data structure.
- confidence: NUMBER
- polarity: INTEGER
- tags: ARRAY, which is also a nested data structure.
|
last_customer_activity_at
STRING
|
last_message_at
STRING
|
last_message_in
OBJECT
This is a nested data structure: - channel: STRING
- sent_at: STRING
- sentiment: STRING
|
last_message_out
OBJECT
This is a nested data structure: |
last_message_unresponded_to
OBJECT
This is a nested data structure: - channel: STRING
- sent_at: STRING
|
last_name
STRING
|
last_seen_at
STRING
|
links
OBJECT
This is a nested data structure: |
locale
STRING
|
locations
STRING
|
modified_at
STRING
|
modified_by
OBJECT
This is a nested data structure: |
name
STRING
|
org
OBJECT
This is a nested data structure: |
phones
ARRAY
This is a nested data structure: - phone: STRING
- type: STRING
- verified: BOOLEAN
|
preview
OBJECT
This is a nested data structure: - channel: STRING
- preview_at: STRING
- subject: STRING
- text: STRING
- type: STRING
|
progressive_status
STRING
|
recent_items
ARRAY
This is a nested data structure: - id: STRING
- meta: OBJECT, which is also a nested data structure.
- type: STRING
- updated_at: STRING
|
recent_location
OBJECT
This is a nested data structure: |
rev
INTEGER
|
role_group_versions
STRING
|
satisfaction_level
OBJECT
This is a nested data structure: - first_satisfaction: OBJECT, which is also a nested data structure.
- sent_by_teams: ARRAY, which is also a nested data structure.
- last_satisfaction: OBJECT, which is also a nested data structure.
- sent_by_teams: ARRAY, which is also a nested data structure.
|
sentiment
OBJECT
This is a nested data structure: - confidence: NUMBER
- polarity: INTEGER
|
shared_emails
STRING
|
shared_external_ids
STRING
|
shared_phones
STRING
|
shared_socials
STRING
|
signed_up_at
STRING
|
smooch_ids
STRING
|
socials
STRING
|
tags
STRING
|
time_zone
STRING
|
updated_at
STRING
|
urls
STRING
|
username
STRING
|
verified
BOOLEAN
|
watchers
STRING
|
whatsapps
STRING
|
kobjects
The kobjects table contains information about Kustomer objects in the Kustomer app.
created_at
STRING
|
custom
OBJECT
This is a nested data structure: - billing_status_str: STRING
- comment_txt: STRING
- delighted_link_str: STRING
- order_created_at: STRING
- order_number_str: STRING
- order_updated_at: STRING
- purchase_amount_num: INTEGER
- score_num: INTEGER
- shipping_address_str: STRING
- shipping_country_str: STRING
- shipping_state_str: STRING
- shipping_zip_str: STRING
- skus_txt: STRING
- special_instructions_str: STRING
- tags_str: STRING
- total_price_num: NUMBER
- total_price_str: STRING
- updated_at: STRING
|
customer
OBJECT
This is a nested data structure: |
description
STRING
|
external_id
STRING
|
icon
STRING
|
id
STRING
|
klass
OBJECT
This is a nested data structure: |
links
OBJECT
This is a nested data structure: |
org
OBJECT
This is a nested data structure: |
title
STRING
|
type
STRING
|
updated_at
STRING
|
messages
The messages table contains information about messages in the Kustomer app.
created_at
STRING
|
custom
OBJECT
This is a nested data structure: - billing_status_str: STRING
- comment_txt: STRING
- delighted_link_str: STRING
- order_created_at: STRING
- order_number_str: STRING
- order_updated_at: STRING
- purchase_amount_num: INTEGER
- score_num: INTEGER
- shipping_address_str: STRING
- shipping_country_str: STRING
- shipping_state_str: STRING
- shipping_zip_str: STRING
- skus_txt: STRING
- special_instructions_str: STRING
- tags_str: STRING
- total_price_num: NUMBER
- total_price_str: STRING
- updated_at: STRING
|
customer
OBJECT
This is a nested data structure: |
description
STRING
|
external_id
STRING
|
icon
STRING
|
id
STRING
|
images
ARRAY
This is a nested data structure. |
klass
OBJECT
This is a nested data structure: |
links
OBJECT
This is a nested data structure: |
org
OBJECT
This is a nested data structure: |
tags
ARRAY
This is a nested data structure. |
title
STRING
|
type
STRING
|
updated_at
STRING
|
notes
The notes table contains information about notes in the Kustomer app.
body
STRING
|
conversation
OBJECT
This is a nested data structure: |
created_at
DATE-TIME
|
created_by
OBJECT
This is a nested data structure: |
customer
OBJECT
This is a nested data structure: |
deleted
BOOLEAN
|
deleted_at
DATE-TIME
|
deleted_by
OBJECT
This is a nested data structure: |
external_id
STRING
|
id
STRING
|
imported_at
DATE-TIME
|
links
OBJECT
This is a nested data structure: |
modified_at
DATE-TIME
|
modified_by
OBJECT
This is a nested data structure: |
org
OBJECT
This is a nested data structure: |
type
STRING
|
updated_at
DATE-TIME
|
user_mentions
ARRAY
This is a nested data structure: |
shortcuts
The shortcuts table contains information about shortcuts in the Kustomer app.
conversation
OBJECT
This is a nested data structure: - name: OBJECT, which is also a nested data structure.
- operator: STRING
- value: STRING
- tags: OBJECT, which is also a nested data structure.
- operator: STRING
- value: STRING, which is also a nested data structure.
|
created_at
DATE-TIME
|
created_by
OBJECT
This is a nested data structure: |
deleted
BOOLEAN
|
draft
OBJECT
This is a nested data structure: |
id
STRING
|
is_private
BOOLEAN
|
links
OBJECT
This is a nested data structure: |
modified_at
STRING
|
modified_by
OBJECT
This is a nested data structure: |
name
STRING
|
org
OBJECT
This is a nested data structure: |
payload
OBJECT
This is a nested data structure: - text: STRING, which is also a nested data structure.
- blocks: ARRAY, which is also a nested data structure.
- data: OBJECT, which is also a nested data structure.
- depth: INTEGER
- entity_ranges: ARRAY, which is also a nested data structure.
- key: INTEGER
- length: INTEGER
- offset: INTEGER
- inline_style_ranges: ARRAY, which is also a nested data structure.
- key: INTEGER
- length: INTEGER
- style: STRING
- key: STRING
- text: STRING
- type: STRING
>
- entity_map: OBJECT, which is also a nested data structure.
- 0: OBJECT, which is also a nested data structure.
- data: OBJECT, which is also a nested data structure.
- fallback_text: STRING
- key: STRING
- url: STRING
- mutability: STRING
- type: STRING
- 1: OBJECT, which is also a nested data structure.
- data: OBJECT, which is also a nested data structure.
- fallback_text: STRING
- key: STRING
- url: STRING
- mutability: STRING
- type: STRING
- 2: OBJECT, which is also a nested data structure.
- data: OBJECT, which is also a nested data structure.
- mutability: STRING
- type: STRING
- 3: OBJECT, which is also a nested data structure.
- data: OBJECT, which is also a nested data structure.
- mutability: STRING
- type: STRING
|
type
STRING
|
updated_at
DATE-TIME
|
The tags table contains information about tags in the Kustomer app.
teams
The teams table contains information about teams in the Kustomer app.
created_at
DATE-TIME
|
created_by
OBJECT
This is a nested data structure: |
deleted
BOOLEAN
|
deleted_at
STRING
|
deleted_by
OBJECT
This is a nested data structure: |
display_name
STRING
|
icon
STRING
|
id
STRING
|
links
OBJECT
This is a nested data structure: |
members
ARRAY
This is a nested data structure. |
modified_at
STRING
|
modified_by
OBJECT
This is a nested data structure: |
name
STRING
|
org
OBJECT
This is a nested data structure: |
role_groups
ARRAY
This is a nested data structure. |
type
STRING
|
updated_at
DATE-TIME
|
users
The users table contains information about users in the Kustomer app.
avatar_url
STRING
|
created_at
DATE-TIME
|
created_by
OBJECT
This is a nested data structure: |
deleted_at
STRING
|
display_name
STRING
|
email
STRING
|
email_signature
STRING
|
email_verified_at
STRING
|
first_email_verified_at
STRING
|
id
STRING
|
links
OBJECT
This is a nested data structure: |
mobile
STRING
|
modified_at
STRING
|
modified_by
OBJECT
This is a nested data structure: |
name
STRING
|
org
OBJECT
This is a nested data structure: |
password
OBJECT
This is a nested data structure: - allow_new: BOOLEAN
- force_new: BOOLEAN
- updated_at: DATE-TIME
|
role_groups
ARRAY
This is a nested data structure. |
roles
ARRAY
This is a nested data structure. |
type
STRING
|
updated_at
DATE-TIME
|
user_type
STRING
|
