Ujet OP DEZE PAGINA
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.
Momentopname functie Een beknopt overzicht van deze connector, inclusief nuttige koppelingen en ondersteunde functies.
Functie/mogelijkheden Ondersteuningsdetails Ondersteunde Qlik Talend Data Integration -projecten Alleen replicatieprojecten . Gegevenspijplijnprojecten worden niet ondersteund. Bijwerkmethoden doel
Replicatietaken:
Wijzigingen toepassen
Wijzigingen opslaan
Gegevens tijdelijk opslaan in een datalaketaak:
Metagegevens beheren
Handmatig metagegevens genereren is niet nodig. Schema-evolutie
Alleen de bewerking Type kolomgegevens wijzigen wordt ondersteund. Replicatie van LOB-kolommen (NCLOB, CLOB en BLOB) Niet ondersteund. Gepland CDC Vereist. Zo wordt het doel up-to-date gehouden met wijzigingen in de bron.
Voor replicatietaken raadpleegt u Taken plannen
Voor tussenopslagtaken voor lake, raadpleegt u CDC plannen voor tussenopslagtaken in lake
Meldingen Gedeeltelijk ondersteund
Meldingen instellen voor wijzigingen van de bewerking
Bewaking Alleen CDC, omdat volledige lading niet relevant is voor deze connector.
Een afzonderlijke gegevenstaak bewaken
Automatisch denesten van nettoladingen van JSON-kolommen Niet ondersteund. Nettoladingen van JSON-kolommen in brongegevensverzamelingen worden niet automatisch gedenest op het doel.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Informatie Zorg dat het account dat u gebruikt leestoegang heeft voor de tabellen die u wilt ophalen.
Creating the connection Ga voor meer informatie naar Verbinding maken met SaaS-applicaties
Vul de vereiste verbindingseigenschappen in. Geef in Verbindingsnaam een naam voor de verbinding op.
Selecteer Metagegevens verbinding openen om metagegevens te definiëren voor de verbinding nadat deze is gemaakt.
Klik op Maken .
Connection settings Setting Description Data gateway
Selecteer een Data Movement gateway als dit is vereist voor uw usecase.
Informatie Dit veld is niet beschikbaar met het Qlik Talend Cloud Starter -abonnement, omdat het geen ondersteuning biedt voor Data Movement gateway . Als u een ander abonnementsniveau hebt en Data Movement gateway niet wilt gebruiken, selecteer dan Geen .
Raadpleeg Qlik Gegevensgateway - Gegevensverplaatsing Data Movement gateway en usecases waarvoor deze is vereist.
Start Date Voer de datum in, in het formaat MM/DD/YYYY, vanaf wanneer de gegevens van uw gegevensbron naar uw doel moeten worden gerepliceerd.
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 .
Informatie 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
id
Replication Key
started_at
agent_activity_logs table foreign keys 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
agent_activity_logs table schema
activity
STRING
agent_id
INTEGER
call_id
INTEGER
chat_id
INTEGER
duration
INTEGER
ended_at
DATE-TIME
id
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
id
Replication Key
status_updated_at
agents table foreign keys 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
agents table schema
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
id
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
id
Replication Key
updated_at
calls table foreign keys 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
calls table schema
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
id
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:
voicemail_reason
STRING
voip_provider
STRING
wait_duration
INTEGER
chats
The chats table contains info about chats.
Replication Method
CDC
Primary Key
id
Replication Key
updated_at
chats table foreign keys 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
chats table schema
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
id
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:
wait_duration
INTEGER
The menu_tree table contains info about menu trees.
Replication Method
Full Table
Primary Key
id
The menus table contains info about menus.
Replication Method
CDC
Primary Key
id
team_tree
The team_tree table contains info about team trees.
Replication Method
Full Table
Primary Key
id
team_tree table schema
agents_count
INTEGER
deleted
BOOLEAN
id
INTEGER
name
STRING
parent_id
INTEGER
position
INTEGER
teams
The teams table contains info about teams.
Replication Method
Full Table
Primary Key
id
teams table foreign keys Join teams with on agents teams.id = agents.teams.id menus teams.id = menus.team_assignments.team.id
teams table schema
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
id
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
id
user_statuses table schema
color
STRING
id
INTEGER
name
STRING
wfm_id
INTEGER
