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,362 Super User 2025 Season 2 on at

Like (1)

Report

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
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,362 Super User 2025 Season 2 on at

Like (0)

Report

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