Ujet

Ujet is a cloud-based contact center platform that provides mobile and AI-powered solutions for managing customer service operations.

Ujet integration replicates data using the UJET 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.

確認您使用的帳戶可讀取您要擷取的表格。

Creating the connection

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

填寫所需的連線屬性。
在連線名稱中提供連線名稱。
選取開啟連線中繼資料以在建立後定義連線的中繼資料。
按一下建立。

Connection settings
Setting	Description
Data gateway	如您的使用情況有需要，選取資料移動閘道。資訊備註此欄位無法用於 Qlik Talend Cloud 啟動器訂閱，因為不支援資料移動閘道。若您有另一個訂閱層級且不想使用資料移動閘道，選取無。如需關於資料移動閘道福利的資訊以及需要此項的使用案例，請參閱 Qlik 資料閘道 - 資料移動。
Start Date	以 `MM/DD/YYYY` 格式輸入資料必須從來源複寫到目標的日期。
Company Key	Company key.
Company Secret	Company secret.
Domain	Enter your Ujet domain.
Subdomain	You can find your subdomain in your Ujet URL. If the URL is https://myujet.ujet.com, the subdomain is myujet.

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.

agent_activity_logs

The agent_activity_logs table contains info about agent activity logs.

Replication Method

CDC

Primary Key

Replication Key

started_at

Join agent_activity_logs with	on
agents	agent_activity_logs.agent_id = agents.id
calls	agent_activity_logs.agent_id = calls.agent_info.id agent_activity_logs.agent_id = calls.transfers.from_agent.id agent_activity_logs.agent_id = calls.transfers.to_agent.id agent_activity_logs.call_id = calls.id agent_activity_logs.call_id = calls.participants.call_id
chats	agent_activity_logs.agent_id = chats.transfers.from_agent.id agent_activity_logs.agent_id = chats.transfers.to_agent.id agent_activity_logs.chat_id = chats.id agent_activity_logs.chat_id = chats.participants.chat_id
menus	agent_activity_logs.agent_id = menus.agent_assignments.assignee.id agent_activity_logs.agent_id = menus.team_assignments.team.assignees.id

activity

STRING

agent_id

INTEGER

call_id

INTEGER

chat_id

INTEGER

duration

INTEGER

ended_at

DATE-TIME

INTEGER

started_at

DATE-TIME

status

OBJECT

This is a nested data structure:

color: STRING
id: INTEGER
name: STRING
wfm_id: INTEGER

whodunnit

OBJECT

This is a nested data structure:

agent_number: STRING
avatar_url: STRING
first_name: STRING
id: INTEGER
last_name: STRING
name: STRING

agents

The agents table contains info about agents.

Replication Method

CDC

Primary Key

Replication Key

status_updated_at

Join agents with	on
agent_activity_logs	agents.id = agent_activity_logs.agent_id
calls	agents.id = calls.agent_info.id agents.id = calls.transfers.from_agent.id agents.id = calls.transfers.to_agent.id
chats	agents.id = chats.transfers.from_agent.id agents.id = chats.transfers.to_agent.id
menus	agents.id = menus.agent_assignments.assignee.id agents.id = menus.team_assignments.team.assignees.id agents.teams.id = menus.team_assignments.team.id
teams	agents.teams.id = teams.id

agent_number

STRING

avatar_url

STRING

call_count

INTEGER

channels

ARRAY

This is a nested data structure:

channel_type: STRING
menu: OBJECT, which is also a nested data structure.
- deleted: BOOLEAN
- hidden: BOOLEAN
- id: INTEGER
- menu_type: STRING
- name: STRING
- output_msg: STRING
- parent_id: INTEGER
- position: INTEGER

chat_count

INTEGER

created_at

DATE-TIME

crm_authenticated

BOOLEAN

email

STRING

first_name

STRING

INTEGER

last_login_time

DATE-TIME

last_name

STRING

location

STRING

middle_name

STRING

online

BOOLEAN

roles

ARRAY

This is a nested data structure.

status

OBJECT

This is a nested data structure:

color: STRING
id: INTEGER
name: STRING
wfm_id: INTEGER

status_updated_at

DATE-TIME

teams

ARRAY

This is a nested data structure:

agents_count: INTEGER
deleted: BOOLEAN
id: INTEGER
name: STRING
parent_id: INTEGER
position: INTEGER

wrap_up

BOOLEAN

calls

The calls table contains info about calls.

Replication Method

CDC

Primary Key

Replication Key

updated_at

Join calls with	on
agents	calls.agent_info.id = agents.id calls.transfers.from_agent.id = agents.id calls.transfers.to_agent.id = agents.id
agent_activity_logs	calls.agent_info.id = agent_activity_logs.agent_id calls.transfers.from_agent.id = agent_activity_logs.agent_id calls.transfers.to_agent.id = agent_activity_logs.agent_id calls.id = agent_activity_logs.call_id calls.participants.call_id = agent_activity_logs.call_id
chats	calls.agent_info.id = chats.transfers.from_agent.id calls.transfers.from_agent.id = chats.transfers.from_agent.id calls.transfers.to_agent.id = chats.transfers.from_agent.id calls.agent_info.id = chats.transfers.to_agent.id calls.transfers.from_agent.id = chats.transfers.to_agent.id calls.transfers.to_agent.id = chats.transfers.to_agent.id
menus	calls.agent_info.id = menus.agent_assignments.assignee.id calls.transfers.from_agent.id = menus.agent_assignments.assignee.id calls.transfers.to_agent.id = menus.agent_assignments.assignee.id calls.agent_info.id = menus.team_assignments.team.assignees.id calls.transfers.from_agent.id = menus.team_assignments.team.assignees.id calls.transfers.to_agent.id = menus.team_assignments.team.assignees.id

agent_info

OBJECT

This is a nested data structure:

agent_number: INTEGER
avatar_url: STRING
first_name: STRING
id: INTEGER
last_name: STRING
name: STRING

answer_type

STRING

assigned_at

DATE-TIME

call_duration

INTEGER

call_type

STRING

connected_at

DATE-TIME

created_at

DATE-TIME

deflection

STRING

deflection_details

ARRAY

This is a nested data structure:

call_id: INTEGER
deflection: STRING
from_menu_path: OBJECT, which is also a nested data structure.
- items_count: INTEGER
- materialized_path: STRING
- name: STRING
id: INTEGER
transfer_id: INTEGER

disconnected_by

STRING

end_user

OBJECT

This is a nested data structure:

id: INTEGER
identifier: STRING
out_contact_id: STRING

ends_at

DATE-TIME

fail_details

STRING

fail_reason

STRING

has_feedback

BOOLEAN

hold_duration

INTEGER

lang

STRING

menu_path

OBJECT

This is a nested data structure:

items_count: INTEGER
materialized_path: STRING
name: STRING

offer_events

ARRAY

This is a nested data structure:

casting_time: DATE-TIME
group: STRING

offer_type

STRING

out_ticket_id

STRING

out_ticket_url

STRING

outbound_number

STRING

participants

ARRAY

This is a nested data structure:

call_duration: INTEGER
call_id: INTEGER
connected_at: DATE-TIME
end_user_id: INTEGER
ended_at: DATE-TIME
fail_reason: STRING
hold_duration: INTEGER
id: INTEGER
status: STRING
type: STRING
user_id: INTEGER

photos

ARRAY

This is a nested data structure:

id: INTEGER
photo_type: STRING
url: STRING

queued_at

DATE-TIME

rating

STRING

recording_url

STRING

scheduled_at

DATE-TIME

selected_menu

OBJECT

This is a nested data structure:

deleted: BOOLEAN
hidden: BOOLEAN
id: INTEGER
menu_type: STRING
name: STRING
output_msg: STRING
parent_id: INTEGER
position: INTEGER

status

STRING

support_number

STRING

transfers

ARRAY

This is a nested data structure:

answer_type_path: STRING
assigned_at: DATE-TIME
call_duration: INTEGER
connected_at: DATE-TIME
created_at: DATE-TIME
deflection: STRING
fail_reason: STRING
from_agent: OBJECT, which is also a nested data structure.
- agent_number: INTEGER
- avatar_url: STRING
- first_name: STRING
- id: INTEGER
- last_name: STRING
- name: STRING
from_menu_path: OBJECT, which is also a nested data structure.
- items_count: INTEGER
- materialized_path: STRING
- name: STRING
from_queue_priority_level: INTEGER
id: INTEGER
status: STRING
to_agent: OBJECT, which is also a nested data structure.
- agent_number: INTEGER
- avatar_url: STRING
- first_name: STRING
- id: INTEGER
- last_name: STRING
- name: STRING
to_menu_path: STRING
to_queue_priority_level: STRING
updated_at: DATE-TIME
wait_duration: INTEGER

updated_at

DATE-TIME

verified

BOOLEAN

videos

ARRAY

This is a nested data structure:

id: INTEGER
url: STRING

voicemail_reason

STRING

voip_provider

STRING

wait_duration

INTEGER

chats

The chats table contains info about chats.

Replication Method

CDC

Primary Key

Replication Key

updated_at

Join chats with	on
agents	chats.transfers.from_agent.id = agents.id chats.transfers.to_agent.id = agents.id
agent_activity_logs	chats.transfers.from_agent.id = agent_activity_logs.agent_id chats.transfers.to_agent.id = agent_activity_logs.agent_id chats.id = agent_activity_logs.chat_id chats.participants.chat_id = agent_activity_logs.chat_id
calls	chats.transfers.from_agent.id = calls.agent_info.id chats.transfers.to_agent.id = calls.agent_info.id chats.transfers.from_agent.id = calls.transfers.from_agent.id chats.transfers.to_agent.id = calls.transfers.from_agent.id chats.transfers.from_agent.id = calls.transfers.to_agent.id chats.transfers.to_agent.id = calls.transfers.to_agent.id
menus	chats.transfers.from_agent.id = menus.agent_assignments.assignee.id chats.transfers.to_agent.id = menus.agent_assignments.assignee.id chats.transfers.from_agent.id = menus.team_assignments.team.assignees.id chats.transfers.to_agent.id = menus.team_assignments.team.assignees.id

agent_info

STRING

assigned_at

DATE-TIME

average_response_time

INTEGER

chat_duration

INTEGER

chat_type

STRING

created_at

DATE-TIME

end_user

OBJECT

This is a nested data structure:

id: INTEGER
identifier: STRING
out_contact_id: STRING

ends_at

DATE-TIME

fail_reason

STRING

first_msg_sent_at

DATE-TIME

has_feedback

BOOLEAN

INTEGER

lang

STRING

last_msg_sent_at

DATE-TIME

longest_response_time

INTEGER

menu_path

OBJECT

This is a nested data structure:

items_count: INTEGER
materialized_path: STRING
name: STRING

message_count

INTEGER

offer_events

ARRAY

This is a nested data structure.

offer_type

STRING

out_ticket_id

STRING

out_ticket_url

STRING

participants

ARRAY

This is a nested data structure:

chat_duration: INTEGER
chat_id: INTEGER
connected_at: DATE-TIME
end_user_id: INTEGER
fail_reason: STRING
finished_at: DATE-TIME
id: INTEGER
status: STRING
type: STRING
user_id: STRING

photos

ARRAY

This is a nested data structure:

id: INTEGER
photo_type: STRING
url: STRING

rating

STRING

selected_menu

OBJECT

This is a nested data structure:

deleted: BOOLEAN
hidden: BOOLEAN
id: INTEGER
menu_type: STRING
name: STRING
output_msg: STRING
parent_id: INTEGER
position: INTEGER

status

STRING

transcript

BOOLEAN

transfers

ARRAY

This is a nested data structure:

answer_type_path: STRING
assigned_at: DATE-TIME
call_duration: INTEGER
connected_at: DATE-TIME
created_at: DATE-TIME
deflection: STRING
fail_reason: STRING
from_agent: OBJECT, which is also a nested data structure.
- agent_number: INTEGER
- avatar_url: STRING
- first_name: STRING
- id: INTEGER
- last_name: STRING
- name: STRING
from_menu_path: OBJECT, which is also a nested data structure.
- items_count: INTEGER
- materialized_path: STRING
- name: STRING
from_queue_priority_level: INTEGER
id: INTEGER
status: STRING
to_agent: OBJECT, which is also a nested data structure.
- agent_number: INTEGER
- avatar_url: STRING
- first_name: STRING
- id: INTEGER
- last_name: STRING
- name: STRING
to_menu_path: STRING
to_queue_priority_level: STRING
updated_at: DATE-TIME
wait_duration: INTEGER

updated_at

DATE-TIME

verified

BOOLEAN

videos

ARRAY

This is a nested data structure:

id: INTEGER
url: STRING

wait_duration

INTEGER

The menu_tree table contains info about menu trees.

Replication Method

Full Table

Primary Key

menus

The menus table contains info about menus.

Replication Method

CDC

Primary Key

Join menus with	on
agents	menus.agent_assignments.assignee.id = agents.id menus.team_assignments.team.assignees.id = agents.id menus.team_assignments.team.id = agents.teams.id
agent_activity_logs	menus.agent_assignments.assignee.id = agent_activity_logs.agent_id menus.team_assignments.team.assignees.id = agent_activity_logs.agent_id
calls	menus.agent_assignments.assignee.id = calls.agent_info.id menus.team_assignments.team.assignees.id = calls.agent_info.id menus.agent_assignments.assignee.id = calls.transfers.from_agent.id menus.team_assignments.team.assignees.id = calls.transfers.from_agent.id menus.agent_assignments.assignee.id = calls.transfers.to_agent.id menus.team_assignments.team.assignees.id = calls.transfers.to_agent.id
chats	menus.agent_assignments.assignee.id = chats.transfers.from_agent.id menus.team_assignments.team.assignees.id = chats.transfers.from_agent.id menus.agent_assignments.assignee.id = chats.transfers.to_agent.id menus.team_assignments.team.assignees.id = chats.transfers.to_agent.id
teams	menus.team_assignments.team.id = teams.id

agent_assignments

ARRAY

This is a nested data structure:

assignee: OBJECT, which is also a nested data structure.
- agent_number: STRING
- avatar_url: STRING
- first_name: STRING
- id: INTEGER
- last_name: STRING
- name: STRING
channel_type: STRING
group_type: STRING
lang: STRING
queue_level: STRING

deleted

BOOLEAN

hidden

BOOLEAN

INTEGER

menu_type

STRING

name

STRING

output_msg

STRING

parent_id

INTEGER

position

INTEGER

team_assignments

ARRAY

This is a nested data structure:

channel_type: STRING
group_type: STRING
lang: STRING
queue_level: STRING
team: OBJECT, which is also a nested data structure.
- agents_count: INTEGER
- assignees: ARRAY, which is also a nested data structure.
  - agent_number: STRING
  - avatar_url: STRING
  - first_name: STRING
  - id: INTEGER
  - last_name: STRING
  - name: STRING
- deleted: BOOLEAN
- id: INTEGER
- name: STRING
- parent_id: INTEGER
- position: INTEGER

team_tree

The team_tree table contains info about team trees.

Replication Method

Full Table

Primary Key

agents_count

INTEGER

deleted

BOOLEAN

INTEGER

name

STRING

parent_id

INTEGER

position

INTEGER

teams

The teams table contains info about teams.

Replication Method

Full Table

Primary Key

Join teams with	on
agents	teams.id = agents.teams.id
menus	teams.id = menus.team_assignments.team.id

agents_count

INTEGER

assignees

ARRAY

This is a nested data structure:

agent_number: STRING
avatar_url: STRING
first_name: STRING
id: INTEGER
last_name: STRING
name: STRING

deleted

BOOLEAN

INTEGER

name

STRING

parent_id

INTEGER

position

INTEGER

user_statuses

The user_statuses table contains info about user statuses.

Replication Method

Full Table

Primary Key

color

STRING

INTEGER

name

STRING

wfm_id

INTEGER

此頁面是否對您有幫助？

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

在此留下意見回饋