LiveChat

LiveChat ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Livechat account email Livechat password
Replication Type	Key based Replication Full Replication
Replication Key	Date
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
list_all_agents	list_all_canned_responses
list_all_greetings	list_all_groups
list_all_tags	total_chats
chat_engagements

Integrate Livechat with Daton

1. Signin to Daton

2. Select Livechat from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your Livechat account email and Password to authorize Daton to periodically extract data from livechat.

5. Post successful authentication you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

LIVECHAT Data

TotalChats

Purpose: Shows how many chats occurred during a specified period.

Source API Documentation https://developers.livechatinc.com/docs/data-reporting/reports-api/#total-chats

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	TargetDatatype
date	STRING
chats	NUMERIC
missed_chats	NUMERIC

ChatEngagements

Purpose: This report shows you where you get your chats from. They can come from i.e. automatic invitations manual invitations or the visitors can start the chats by themselves.

Source API Documentation https://developers.livechatinc.com/docs/data-reporting/reports-api/#chat-engagement

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
date	STRING
chats_from_auto_invite	NUMERIC
chats_from_manual_invite	NUMERIC
chats_from_immediate_start	NUMERIC

ListAllAgents

Purpose:Returns all LiveChat agents list

Source API Documentation https://developers.livechatinc.com/docs/management/configuration-api/v2.0/#list-all-agents

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
name	STRING
permission	STRING
avatar	STRING
login	STRING
is_bot	BOOLEAN
group_ids	STRING
status	STRING

ListAllCannedResponses

Purpose:Returns the list of all currently set canned responses.

Source API Documentation https://developers.livechatinc.com/docs/management/configuration-api/v2.0/#list-all-canned-responses

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
id	NUMERIC
group	NUMERIC
text	STRING
modification_date	NUMERIC
tags	STRING

ListAllTags

Purpose:Returns tags from all groups.

Source API Documentation hhttps://developers.livechatinc.com/docs/management/configuration-api/v2.0/#list-all-tags

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
name	STRING
author	STRING
creation_date	NUMERIC
count	RECORD
group	NUMERIC

ListAllGreetings

Purpose:Returns the list of all greetings.

Source API Documentation https://developers.livechatinc.com/docs/management/configuration-api/v2.0/#list-all-greetings

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	NUMERIC
active	BOOLEAN
name	STRING
group	NUMERIC
rules	RECORD
properties	RECORD

ListAllGroups

Purpose:Returns all created groups

Source API Documentation https://developers.livechatinc.com/docs/management/configuration-api/v2.0/#list-all-groups

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	NUMERIC
name	STRING
language	STRING
status	STRING