Zendesk Chat

Zendesk Chat is a live chat software platform that allows businesses to provide real-time customer support directly on their website or app.

Zendesk Support integration replicates data using the Zendesk Support API.

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 generate your client ID and secret:

Log into your Zendesk chat domain, for example: https://my-sub-domain.zendesk.com/chat.
Expand the Settings menu on the left of the page and click Account.
Select the API and SDKs tab at the top of the page.
Select or add an API Client. Your client ID is displayed on the page.
Copy and save the client secret in a secured file. You will need it to connect to the application.

Creating the connection

如需詳細資訊，請參閱連線到 SaaS 應用程式。

在您填入所需的連線設定時按一下驗證。
可能會要求您登入來源應用程式。
會顯示一個視窗，其中有驗證代碼。
將代碼複製到剪貼簿並返回連線對話方塊。
在使用來源提供的代碼完成驗證中貼上代碼並按一下驗證。
提示備註您可能需要向下捲動以查看此欄位。
若狀態是已驗證，代表已進行了驗證。
在連線名稱中提供連線名稱。
選取開啟連線中繼資料以在建立後定義連線的中繼資料。

Connection settings
Setting	Description
Data gateway	如您的使用情況有需要，選取資料移動閘道。資訊備註此欄位無法用於 Qlik Talend Cloud 啟動器訂閱，因為不支援資料移動閘道。若您有另一個訂閱層級且不想使用資料移動閘道，選取無。如需關於資料移動閘道福利的資訊以及需要此項的使用案例，請參閱 Qlik 資料閘道 - 資料移動。
Start Date	以 `MM/DD/YYYY` 格式輸入資料必須從來源複寫到目標的日期。
Zendesk Subdomain	The subdomain of your Zendesk site. For example, the subdomain of `qlik.zendesk.com` would be `qlik`.
Client ID	Client ID.
Client Secret	Client secret.

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

The account table contains info about accounts within your Zendesk Chat account.

Replication Method

Full Table

Primary Key

account_key

Useful links

Zendesk Chat API method

Join account with	on
goals	account.plan.goals = goals.id
chats	account.plan.goals = chats.conversions.goal_id account.plan.goals = chats.history.conversion.goal_id

Join account with

goals

account.plan.goals = goals.id

chats

account.plan.goals = chats.conversions.goal_id

account.plan.goals = chats.history.conversion.goal_id

account_key

STRING

billing

OBJECT

This is a nested data structure:

additional_info: STRING
address1: STRING
address2: STRING
city: STRING
company: STRING
country_code: STRING
email: STRING
first_name: STRING
last_name: STRING
postal_code: STRING
state: STRING

create_date

DATE-TIME

plan

OBJECT

This is a nested data structure:

agent_leaderboard: BOOLEAN
agent_reports: BOOLEAN
analytics: BOOLEAN
chat_reports: BOOLEAN
daily_reports: BOOLEAN
email_reports: BOOLEAN
file_upload: BOOLEAN
goals: INTEGER
high_load: BOOLEAN
integrations: BOOLEAN
ip_restriction: BOOLEAN
long_desc: STRING
max_advanced_triggers: STRING
max_agents: INTEGER
max_basic_triggers: STRING
max_concurrent_chats: STRING
max_departments: STRING
max_history_search_days: STRING
monitoring: BOOLEAN
name: STRING
operating_hours: BOOLEAN
price: NUMBER
rest_api: BOOLEAN
short_desc: STRING
sla: BOOLEAN
support: BOOLEAN
unbranding: BOOLEAN
widget_customization: STRING

status

STRING

agents

The agents table contains info about agents within your Zendesk Chat account.

Replication Method

Full Table

Primary Key

Useful links

Zendesk Chat API method

Join agents with	on
chats	agents.id = chats.agent_ids agents.departments = chats.department_id agents.departments = chats.history.prev_department_id
departments	agents.departments = departments.id
shortcuts	agents.departments = shortcuts.departments

Join agents with

chats

agents.id = chats.agent_ids

agents.departments = chats.department_id

agents.departments = chats.history.prev_department_id

departments

agents.departments = departments.id

shortcuts

agents.departments = shortcuts.departments

create_date

DATE-TIME

departments

ARRAY

display_name

STRING

email

STRING

enabled

BOOLEAN

enabled_departments

ARRAY

first_name

STRING

INTEGER

last_login

DATE-TIME

last_name

STRING

login_count

INTEGER

role_id

INTEGER

roles

OBJECT

This is a nested data structure:

administrator: BOOLEAN
owner: BOOLEAN

scope

STRING

skills

ARRAY

bans

The bans table contains info about bans created in your Zendesk Chat account.

Replication Method

Full Table

Primary Key

Useful links

Zendesk Chat API method

created_at

DATE-TIME

INTEGER

ip_address

STRING

reason

STRING

type

STRING

visitor_id

STRING

visitor_name

STRING

chats

The chats table contains info about the chats within your Zendesk Chat account.

Replication Method	CDC
Primary Key	id
Replication Key	timestamp
Useful links	Zendesk Chat API method

Join chats with	on
agents	chats.agent_ids = agents.id chats.department_id = agents.departments chats.history.prev_department_id = agents.departments
departments	chats.department_id = departments.id chats.history.prev_department_id = departments.id
shortcuts	chats.department_id = shortcuts.departments chats.history.prev_department_id = shortcuts.departments
goals	chats.conversions.goal_id = goals.id chats.history.conversion.goal_id = goals.id
account	chats.conversions.goal_id = account.plan.goals chats.history.conversion.goal_id = account.plan.goals

agent_ids

ARRAY

agent_names

ARRAY

comment

STRING

conversions

ARRAY

This is a nested data structure:

attribution: OBJECT, which is also a nested data structure.
- agent_id: INTEGER
- agent_name: STRING
- chat_timestamp: DATE-TIME
- department_id: INTEGER
- department_name: STRING
goal_id: INTEGER
goal_name: STRING
id: STRING
timestamp: DATE-TIME

count

OBJECT

This is a nested data structure:

agent: INTEGER
total: INTEGER
visitor: INTEGER

department_id

INTEGER

department_name

STRING

duration

INTEGER

end_timestamp

DATE-TIME

history

ARRAY

This is a nested data structure:

channel: STRING
conversion: OBJECT, which is also a nested data structure.
- attribution: OBJECT, which is also a nested data structure.
  - agent_id: INTEGER
  - agent_name: STRING
  - chat_timestamp: DATE-TIME
  - department_id: INTEGER
  - department_name: STRING
- goal_id: INTEGER
- goal_name: STRING
- id: STRING
- timestamp: DATE-TIME
department_id: INTEGER, STRING
department_name: STRING
msg: STRING
msg_id: STRING, INTEGER
name: STRING
new_rating: STRING
new_tags: ARRAY
nick: STRING
options: STRING
prev_department_id: INTEGER, STRING
rating: STRING
skills_name: ARRAY
tags: ARRAY
timestamp: DATE-TIME
type: STRING

STRING

message

STRING

missed

BOOLEAN

rating

STRING

referrer_search_engine

STRING

referrer_search_terms

STRING

response_time

OBJECT

This is a nested data structure:

avg: NUMBER, INTEGER
first: INTEGER
max: INTEGER

session

OBJECT

started_by

STRING

tags

ARRAY

timestamp

DATE-TIME

triggered

BOOLEAN

triggered_response

BOOLEAN

type

STRING

unread

BOOLEAN, INTEGER

visitor

OBJECT

This is a nested data structure:

email: STRING
id: STRING
name: STRING
notes: STRING
phone: STRING

webpath

ARRAY

zendesk_ticket_id

INTEGER

departments

The departments table contains info about departments within your Zendesk Chat account.

Replication Method

Full Table

Primary Key

Useful links

Zendesk Chat API method

Join departments with	on
shortcuts	departments.id = shortcuts.departments
chats	departments.id = chats.department_id departments.id = chats.history.prev_department_id
agents	departments.id = agents.departments

Join departments with

shortcuts

departments.id = shortcuts.departments

chats

departments.id = chats.department_id

departments.id = chats.history.prev_department_id

agents

departments.id = agents.departments

description

STRING

enabled

BOOLEAN

INTEGER

members

ARRAY

name

STRING

settings

OBJECT

goals

The goals table contains info about URL-based goals set within your Zendesk Chat account.

Replication Method

Full Table

Useful links

Zendesk Chat API method

Join goals with	on
chats	goals.id = chats.conversions.goal_id goals.id = chats.history.conversion.goal_id
account	goals.id = account.plan.goals

Join goals with

chats

goals.id = chats.conversions.goal_id

goals.id = chats.history.conversion.goal_id

account

goals.id = account.plan.goals

attribution_model

STRING

attribution_period

INTEGER

description

STRING

enabled

BOOLEAN

INTEGER

name

STRING

settings

OBJECT

This is a nested data structure:

conditions: ARRAY, which is also a nested data structure.
- operator: STRING
- type: STRING
- value: STRING

shortcuts

The shortcuts table contains info about shortcuts within your Zendesk Chat account.

Replication Method

Full Table

Primary Key

name

Useful links

Zendesk Chat API method

Join shortcuts with	on
departments	shortcuts.departments = departments.id
chats	shortcuts.departments = chats.department_id shortcuts.departments = chats.history.prev_department_id
agents	shortcuts.departments = agents.departments

Join shortcuts with

departments

shortcuts.departments = departments.id

chats

shortcuts.departments = chats.department_id

shortcuts.departments = chats.history.prev_department_id

agents

shortcuts.departments = agents.departments

agents

ARRAY

departments

ARRAY

STRING

message

STRING

name

STRING

options

STRING

scope

STRING

tags

ARRAY

triggers

The triggers table contains info about triggers within your Zendesk Chat account.

Replication Method

Full Table

Primary Key

Useful links

Zendesk Chat API method

definition

OBJECT

This is a nested data structure:

actions: STRING
condition: STRING
event: STRING
version: INTEGER

description

STRING

enabled

BOOLEAN

INTEGER

name

STRING

此頁面是否對您有幫助？

若您發現此頁面或其內容有任何問題——錯字、遺漏步驟或技術錯誤——請告知我們！

在此留下意見回饋