Zendesk Chat IN QUESTA PAGINA
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.
Snapshot funzionalità Immagine di alto livello di questo connettore, inclusi collegamenti utili e funzionalità supportate.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Nota informatica Assicurarsi che l'account utilizzata disponga di accesso di lettura per le tabelle che si desidera recuperare.
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 Per ulteriori informazioni, vedere Connessione alle applicazioni SaaS
Una volta completate le impostazioni di connessione richieste, fare clic su Autenticazione .
Potrebbe essere visualizzato un messaggio che richiede di accedere all'applicazione di origine.
Viene visualizzata una finestra con un codice di autenticazione.
Copiare il codice negli appunti e tornare alla finestra di dialogo della connessione.
Incollare il codice in Completare l'autenticazione con il codice fornito dalla sorgente e fare clic su Verifica .
Nota di suggerimento Per visualizzare questo campo, potrebbe essere necessario scorrere in basso.
Quando lo stato è Verificato , l'autenticazione viene verificata.
Fornire un nome per la connessione in Nome connessione .
Selezionare Apri metadati di connessione per definire i metadati della connessione al momento della creazione.
Connection settings Setting Description Data gateway
Selezionare un Gateway Data Movement se richiesto dal proprio caso di utilizzo.
Nota informatica Questo campo non è disponibile con la sottoscrizione a Avvio Qlik Talend Cloud , poiché non supporta il Gateway Data Movement . Se si dispone di un altro livello di sottoscrizione e non si desidera utilizzare il Gateway Data Movement , selezionare Nessuno .
Per informazioni sui vantaggi del Gateway Data Movement e quando è richiesto, vedere Qlik Data Gateway - Movimento dati
Start Date Inserire la data, nel formato MM/DD/YYYY, a partire dalla quale i dati devono essere replicati dalla sorgente alla destinazione.
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.
Nota informatica 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.
account table foreign keys 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
account table schema
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.
agents table foreign keys 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
agents table schema
create_date
DATE-TIME
departments
ARRAY
display_name
STRING
email
STRING
enabled
BOOLEAN
enabled_departments
ARRAY
first_name
STRING
id
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.
bans table schema
created_at
DATE-TIME
id
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.
chats table foreign keys 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
chats table schema
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
id
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.
departments table foreign keys 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
departments table schema
description
STRING
enabled
BOOLEAN
id
INTEGER
members
ARRAY
name
STRING
settings
OBJECT
goals
The goals table contains info about URL-based goals set within your Zendesk Chat account.
goals table foreign keys Join goals with on chats goals.id = chats.conversions.goal_id goals.id = chats.history.conversion.goal_id account goals.id = account.plan.goals
goals table schema
attribution_model
STRING
attribution_period
INTEGER
description
STRING
enabled
BOOLEAN
id
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.
shortcuts table foreign keys 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
shortcuts table schema
agents
ARRAY
departments
ARRAY
id
STRING
message
STRING
name
STRING
options
STRING
scope
STRING
tags
ARRAY
triggers
The triggers table contains info about triggers within your Zendesk Chat account.
triggers table schema
definition
OBJECT
This is a nested data structure:
actions: STRING condition: STRING event: STRING version: INTEGER
description
STRING
enabled
BOOLEAN
id
INTEGER
name
STRING
