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