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 项目	仅 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` 输入必须将数据从源复制到目标的日期。
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

本页面有帮助吗？

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

在此处留下您的反馈