Unanswered

Parse JSON from Azure Data Lake Store

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to read a JSON file from the data lake (using Azure Data Lake Store - Read File) and then parse this (using Parse JSON) however I get the following error.

BadRequest. The property 'content' must be of type JSON in the 'ParseJson' action inputs, but was of type 'application/octet-stream'.

If I send the File Content output of the Read File action directly to an email then I can read the contents of the JSON, but I can't parse the output directly, or convert it using Initialize variable.

Is there a workaround to get access to the actual File Content and not the binary.

Categories:

Building flows

All responses (5)

Answers (0)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Anonymous this could be a temporary issue my friend, please wait 24hr, if not I suggest you to open a microsoft support case.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

this didn't resolve itself after 24 hours. i'm back again at the same problem this time with another flow.

any help greatly appreciated !
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I'm having a similar issue too.

How did you manage to solve this?
Ellis Karim 12,336 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't know if this will provide a work around, but can you put the file content into a compose action, then use expressions to access the content? This avoids using Parse JSON and may give you access to the File content properties:

Ellis

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

Like
a
(0)

Report
Copy link

Link copied!

When data mime-type is application/octet-stream then you can use below function to get JSON data
decodeUriComponent(base64ToString(items('Apply_to_each_|_Note')?['documentbody']))
replace items('Apply_to_each_|_Note')?['documentbody'] with your variable/parameter.