Unanswered

Parse JSON from Azure Data Lake Store

(0) Share

Report

Posted on by Community Power Pla...

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.

I have the same question (0)

All responses (5)

Answers (0)

ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Parse JSON from Azure Data Lake Store

hi @Anonymous this could be a temporary issue my friend, please wait 24hr, if not I suggest you to open a microsoft support case.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Parse JSON from Azure Data Lake Store

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 !

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Parse JSON from Azure Data Lake Store

Hi,

I'm having a similar issue too.

How did you manage to solve this?

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

Like (0)

Report

Re: Parse JSON from Azure Data Lake Store

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.

Was this reply helpful? Yes No
Ayush Singroul 2 on at

Like (0)

Report

Re: Parse JSON from Azure Data Lake Store

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.

Was this reply helpful? Yes No