Author Topic: DB Email content rerieval  (Read 4471 times)

Offline ZIVI

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
DB Email content rerieval
« on: September 13, 2012, 03:37:41 PM »
Hi,

I am looking for a way to retrieve email & chat content and details after an interaction is over.
Meaning retrieve "From", "To", "Subject", "Body" and any interaction related info as time stamp and ID (All this in case of email).

I know that there is a way to connect to eServices UCS DB and retrieve it or use an API for it.

Can anyone point me to relevant documentation or give me pointers as how to achieve my goals above?

Thanks

Offline Adam G.

  • Hero Member
  • *****
  • Posts: 552
  • Karma: 12
  • Still Gorgeous.......
Re: DB Email content rerieval
« Reply #1 on: September 17, 2012, 08:10:55 AM »
Have a look at the Contact DB using your favourite DB GUI. It's all there and in ahuman readable format. Once you've found the correect fields just use SQL to read the information. No APIs or whatever Genesys try to sell you required.


Offline Michaelk

  • Newbie
  • *
  • Posts: 6
  • Karma: 0
Re: DB Email content rerieval
« Reply #2 on: December 06, 2012, 09:04:47 AM »
You should send RequestGetInteractionContent request to UCS, you'll receive EventGetInteractionContent in response - it contains e-mail subject, body, etc...

Offline ZIVI

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
Re: DB Email content rerieval
« Reply #3 on: December 10, 2012, 02:45:36 PM »
Hi,

Thanks you for your responses.

As far as i understand, using RequestGetInteractionContent  i can retrieve a response for a specific interaction ID.
In case i want to retrieve ALL interactions (In deltas), is there a way of doing this with the API or only while connecting to the DB?

Thanks,
ZIVI

Offline Michaelk

  • Newbie
  • *
  • Posts: 6
  • Karma: 0
Re: DB Email content rerieval
« Reply #4 on: December 10, 2012, 03:07:52 PM »
Hi Zivi,

If you want to catch received interactions in real time and get their content you can subscribe to Received event of InteractionServer, filter EventInteractionSubmited events, get from them an InteractionID and send RequestGetInteractionContent to UCS in order to get interaction contents. Also, in the beginning you should send RequestStartPlaceAgentStateReportingAll request in order to receive all events from all agents. Your client type should be ClientType = InteractionClient.ReportingEngine.