Unanswered

Parsing the conversation transcript JSON from annotation.documentBody

(1) Share

Report

Posted on by CU13030700-0

Looking for guidance on how to parse and transform the annotation.documentBody value from a Dynamics 365 Customer Service environment

The values in this column are BASE64 encoded. After decoding them, the values are JSON formatted, however include a lot of (seemingly) unnecessary backslashes

When I paste the decoded value into a JSON formatter, the formatter gives me errors such as 'Expecting 'EOF', '}', ':', ',', ']', got 'undefined''

Does anyone have or know of a documented way to successfully decode and parse the annotation.documentBody values into a usable format, similar to conversationTranscript.content?

TIA

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @LT-13020453-0

So the thing you are seeing are all the escape slashes in the string.

Can you share a full example. Then I can help you no problem. If you are concerned you can DM it to me.

Was this reply helpful? Yes No
CU13030700-0 3 on at

Like (0)

Report
Copy link

Link copied!
Hi @Michael E. Gernaey ,, I am unable to share due to confidentiality and data classification policies within our business

I have simply used an online decode, as well as Power Query
Lines.FromBinary(Binary.FromText(text,BinaryEncoding.Base64), null, null, 1252){0}

Are you able to point me to any open-source code or logic to decode and parse the JSON, or make your suggestion and I will attempt to apply to our data

Thanks!

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

HI

You are doing what you should based on what you have. WIthout seeing it though I cannot tell you what is wrong.

You will need however to do a replace to any of the characters you do not want., This means you can replace the \ slashes, since you dont need them escaped, if its jus giving you "text" escaped.

literally do a compose action

replace(string(myjson, '\', '')

Now again since I can't see it thats just one thing you may need to do.

Was this reply helpful? Yes No