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 项目	仅 Replication 项目。不支持数据管道项目。
目标更新方法	复制任务：应用更改存储更改在数据湖任务中登陆数据：更改数据捕获 (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.

请确保您使用的帐户对要获取的表具有读取权限。

Creating the connection

有关更多信息，请参阅连接到 SaaS 应用程序。

填写所需的连接属性。
在连接名称中提供连接的名称。
选择打开连接元数据以定义创建连接时的元数据。
单击创建。

Connection settings
Setting	Description
Data gateway	如果您的用例需要，请选择一个数据移动网关。信息注释此字段不适用于 Qlik Talend Cloud Starter 订阅，因为它不支持数据移动网关。如果您有另一个订阅层并且不想使用数据移动网关，请选择无。有关数据移动网关的优势和需要它的用例的信息，请参阅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.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Kustomer documentation Kustomer API method

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:

id: STRING
type: STRING

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:

id: STRING
type: STRING

direction

STRING

done_count

INTEGER

ended

BOOLEAN

ended_at

STRING

ended_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

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

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:

self: STRING

merged_target

BOOLEAN

message_count

INTEGER

modified_at

STRING

modified_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

name

STRING

note_count

INTEGER

org

OBJECT

This is a nested data structure:

id: STRING
type: STRING

outbound_message_count

INTEGER

preview

STRING

priority

INTEGER

queue

OBJECT

This is a nested data structure:

id: STRING
type: STRING

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.
- at: STRING
- metric: STRING
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:

id: STRING
type: STRING

sla_version

OBJECT

This is a nested data structure:

id: STRING
type: STRING

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.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Kustomer documentation Kustomer API method

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:

id: STRING
type: STRING

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

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:

sent_at: STRING

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:

self: STRING

locale

STRING

locations

STRING

modified_at

STRING

modified_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

name

STRING

org

OBJECT

This is a nested data structure:

id: STRING
type: STRING

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.
- klass_name: STRING
type: STRING
updated_at: STRING

recent_location

OBJECT

This is a nested data structure:

updated_at: STRING

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.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Kustomer documentation Kustomer API method

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:

id: STRING
type: STRING

description

STRING

external_id

STRING

icon

STRING

klass

OBJECT

This is a nested data structure:

id: STRING
type: STRING

links

OBJECT

This is a nested data structure:

self: STRING

org

OBJECT

This is a nested data structure:

type: STRING

title

STRING

type

STRING

updated_at

STRING

messages

The messages table contains information about messages in the Kustomer app.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Kustomer documentation Kustomer API method

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:

id: STRING
type: STRING

description

STRING

external_id

STRING

icon

STRING

images

ARRAY

This is a nested data structure.

klass

OBJECT

This is a nested data structure:

id: STRING
type: STRING

links

OBJECT

This is a nested data structure:

self: STRING

org

OBJECT

This is a nested data structure:

id: STRING
type: STRING

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.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Kustomer documentation Kustomer API method

body

STRING

conversation

OBJECT

This is a nested data structure:

id: STRING
type: STRING

created_at

DATE-TIME

created_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

customer

OBJECT

This is a nested data structure:

id: STRING
type: STRING

deleted

BOOLEAN

deleted_at

DATE-TIME

deleted_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

external_id

STRING

imported_at

DATE-TIME

links

OBJECT

This is a nested data structure:

self: STRING

modified_at

DATE-TIME

modified_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

org

OBJECT

This is a nested data structure:

id: STRING
type: STRING

type

STRING

updated_at

DATE-TIME

user_mentions

ARRAY

This is a nested data structure:

id: STRING
type: STRING

shortcuts

The shortcuts table contains information about shortcuts in the Kustomer app.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Kustomer documentation Kustomer API method

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:

id: STRING
type: STRING

deleted

BOOLEAN

draft

OBJECT

This is a nested data structure:

text: STRING

STRING

is_private

BOOLEAN

links

OBJECT

This is a nested data structure:

self: STRING

modified_at

STRING

modified_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

name

STRING

org

OBJECT

This is a nested data structure:

id: STRING
type: STRING

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.
      - url: STRING
    - mutability: STRING
    - type: STRING
  - 3: OBJECT, which is also a nested data structure.
    - data: OBJECT, which is also a nested data structure.
      - url: STRING
    - mutability: STRING
    - type: STRING

type

STRING

updated_at

DATE-TIME

teams

The teams table contains information about teams in the Kustomer app.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Kustomer documentation Kustomer API method

created_at

DATE-TIME

created_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

deleted

BOOLEAN

deleted_at

STRING

deleted_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

display_name

STRING

icon

STRING

links

OBJECT

This is a nested data structure:

self: STRING

members

ARRAY

This is a nested data structure.

modified_at

STRING

modified_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

name

STRING

org

OBJECT

This is a nested data structure:

id: STRING
type: STRING

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.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Kustomer documentation Kustomer API method

avatar_url

STRING

created_at

DATE-TIME

created_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

deleted_at

STRING

display_name

STRING

email

STRING

email_signature

STRING

email_verified_at

STRING

first_email_verified_at

STRING

links

OBJECT

This is a nested data structure:

self: STRING

mobile

STRING

modified_at

STRING

modified_by

OBJECT

This is a nested data structure:

id: STRING
type: STRING

name

STRING

org

OBJECT

This is a nested data structure:

id: STRING
type: STRING

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

本页面有帮助吗？

如果您发现此页面或其内容有任何问题 – 打字错误、遗漏步骤或技术错误 – 请告诉我们！

在此处留下您的反馈