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	ユースケースに応じて Data Movement gateway を選択します。情報メモ Qlik Talend Cloud スターターサブスクリプションでは Data Movement gateway をサポートしていないため、この項目は使用できません。別のサブスクリプションティアを利用しており、Data Movement gateway を使用しない場合は、 [None] (なし) を選択します。 Data Movement gateway の利点とそれを必要とするユースケースの詳細については、「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

このページは役に立ちましたか?

このページまたはコンテンツにタイポ、ステップの省略、技術的エラーなどの問題が見つかった場合はお知らせください。

こちらにフィードバックをお寄せください