Unanswered

I want to query user conversations from conversation transcripts Dataverse table using session id or conversation id or logged-In user id..

Like (0) Share

Report

Posted on 14 Dec 2023 13:30:19 by Community Power Pla...

Hi Team,

When user escalates, I want to transfer whole conversations of PVA bot to a live agent of another bot.
I am able to query using "/Api/data/v9.2/conversation transcripts" API, but I want to query using either session id or user id or conversation id.

When I am passing "system Conversation Id" of PVA, no records are matching, Api is returning empty result. *
Also, passed logged user id, but there are no properties available for user id.

Is it possible to get session id or some unique id within current channel (Web or Teams), so that based on that unique id, I can fetch whole conversations for the current channel from conversation transcripts using "/Api/data/v9.2/conversation transcripts" REST API?

Thank you.

Categories:

General

All responses (5)

Answers (0)

TSunIslam 2 on 12 Mar 2024 at 02:19:44

Like (0)

Report

Re: I want to query user conversations from conversation transcripts Dataverse table using session id or conversation id or logged-In user id..

Hello, i have a related query. I want to get the conversations (script) log of chatbot for security reasons. Now, i have seen options from TABLE & SESSION id, it gives conversation with all codes that i don't require. Is there any way to retrieve only those conservations or if can filter or while exporting data can add cleansing activities?
Community Power Pla... on 19 Dec 2023 at 10:10:05

Like (0)

Report

Re: I want to query user conversations from conversation transcripts Dataverse table using session id or conversation id or logged-In user id..

Hi Henry,
Thank you so much for the links. Appreciated. I understood how to query data using Direct Line API.
Is it possible to get conversation id for direct line API within PVA Bot?

If not, how to get conversation id for direct line Api? I won't be posting conversations using Direct Line API but I want retrieve PVA bot conversations using Direct Line APIs.

Here is my requirement in detail:
1) User comes to PVA bot, ask some questions and PVA bot will reply to them.
2) If User ask for live agent help, I want to transfer conversations happened with PVA bot to third party live agent.
3) To retrieve conversations, I am using Direct Line APIs to fetch those conversations and passing system variable conversation id value but using that I am not able to retrieve conversations.
Still getting same error:
{
"error": {
"code": "BadArgument",
"message": "Token not valid for this conversation"
}
}

Please help me out with this requirement.

Thank you.
HenryJammes on 18 Dec 2023 at 17:54:35

Like (0)

Report

Re: I want to query user conversations from conversation transcripts Dataverse table using session id or conversation id or logged-In user id..

It looks like you're using a GUID for the conversation ID, which isn't the correct format for a Direct Line Conversation ID.
Have a look at these examples at how to interact with the API: https://powerusers.microsoft.com/t5/General/API-integration-witn-Power-Virtual-Agent-Chat-bot/m-p/2419823/highlight/true#M7010
Community Power Pla... on 18 Dec 2023 at 17:23:27

Like (0)

Report

Re: I want to query user conversations from conversation transcripts Dataverse table using session id or conversation id or logged-In user id..

Hi Henry,
Thank you so much for your quick response.
I am able to generate bearer token using /v3/direct line/tokens/generate Api by passing web channel security secret key as authorization.
In the next call, I am passing previously generated token to below v3/directline/conversations/{conversationid} Api.
I am getting below error.
Token not valid for this conversation

I didn't enable authentication for my bot. Can you please help me out with this?
Thanks in advance.
HenryJammes on 14 Dec 2023 at 14:43:30

Like (0)

Report

Re: I want to query user conversations from conversation transcripts Dataverse table using session id or conversation id or logged-In user id..

Hi @Anonymous

I don't think this approach can work, as conversation transcripts in Dataverse are not available instantly but are created 20/30 minutes after the conversation has ended.

When doing the hand off over the Direct Line API, the full conversation transcript and variable values are available as an attachement to the handoff activity.

Henry