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

이 페이지가 도움이 되었습니까?

이 페이지 또는 해당 콘텐츠에서 오타, 누락된 단계 또는 기술적 오류와 같은 문제를 발견하면 알려 주십시오!

여기에 피드백을 남겨주십시오.