ece 1.5 and chat history content extract from database

[thanvi2001]

hi, any 1 knows how to extract the chat content / history from the ece database table EGLV_SESSION_CONTENT as the content is stored in encoded format ?

[Omar Deen]

In 11.5, there's no easy way to extract this information without it being messy. You can look into the Interactive APIs, specifically calling on payload.chat.transcript, but you'll find that to be messy as well and will need considerable work to clean up.

In version 12 ES1, Cisco/eGain added GET Conversation

[thanvi2001 · Accepted solution]

Thanks,

Am giving the work around for all. 

ECE II.6 es4, it is achievable through Interaction API's --> Get Activities by ID (Page 960 of ece_11.6es4 Interaction API Guide)

Get THE URL in postman or any SOAP UI

http://<Hostname or IP of ECE Web server>/system/ws/v12/interaction/activity/ <chat activity ID for eg= 1088>?$attribute=all

Above URL fetch all the attributes for Chat ID 1088 including the transcript.

With the URL need to pass Headers and their values

X-egain-session

accept

content-Type

accept-Language

[Omar Deen]

What value are you using for your X-egain-session header?

[thanvi2001]

value like 735861bf-100c-4cb0-8953-ec714f9e31b9, this can be generated through Login API Call .

/system/ws/v12/authentication/user/login

{
"userName":"Agent Login Name",
"password":"PASSWORD"
}