Parse JSON file Attached in email

(0) Share

Report

Posted on by barathibaburaj

Hello I have an email with a JSON file attached.

Here is the content of the file

{
"Releases": {
"Path64: "/Test/Test/Test Ver. 1.0 64-bit.zip",

"Version": "1.0",
"Path32": "/Test/Test/Test Ver. 1.0 32-bit.zip",
"Product": "Test"
}

My flow is very simple - all I want to do is grab this email, parse the attachment content into JSON using Parse JSON action.

}

The issue though is the JSON file content gets converted to a blob content type: application/octet-stream. And Parse JSON throws an error. I have also tried extracting the content of the attachment and converting them to base64string prior to invoking parse json - unfortunately the issue is the same.

Here is a snapshot of the error, the input content is in an octet stream format. I generated the schema using my json file - but I am still getting this error. Am I doing something wrong? Is there any other way to get this working?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report
Hi @barathibaburaj,

The attachment is encoded:

You can use the following expression to decode the attachment to plain text:

decodeBase64(items('Apply_to_each')?['contentBytes'])

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
barathibaburaj 8 on at

Like (0)

Report

Thanks @ekarim2020 . Your solution worked but the data post decoding contains special characters. Could you share your json file. I am not sure if mine has become corrupt. I tried the above solution with a simple json file and it worked but with the existing file I have it is showing special characters.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report
The JSON file is saved as a plain text file using Notepad:

This is the content:

{ "Releases": { "Path64": "/Test/Test/Test Ver. 1.0 64-bit.zip", "Version": "1.0", "Path32": "/Test/Test/Test Ver. 1.0 32-bit.zip", "Product": "Test" } }

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

jsonFile (2).zip

Was this reply helpful? Yes No
barathibaburaj 8 on at

Like (0)

Report

Thank you so much @ekarim2020.
The issue was when I edited the file in NotePad++ the encoding changed to UTF 16 BE BOM causing the issue.
Once I modified that to ANSI or UTF8 it worked as expected.

Was this reply helpful? Yes No