Get File Content "$content-type": "application/octet-stream",

Like (1) Share

Report

Posted on 6 Aug 2021 12:43:47 by Vstar19

354

Hello.

I am using the Get File Content to grab the contents of a CSV file, however the output of the get file content is

{

"$content-type": "application/octet-stream",

"$content": "S24354542JKLSDFHDSAF5hbCBJZCxOYW1lLEVtYWlsLFRva2VuLEV4ZWN1dGVkLFN0YXR1cyxDb3VudHJ5IDogUmVzZWFyY2ggICBQcm9wb3NhbCAgIFN1Ym1pc3Npb24gMSxDb3VudHJ5IDogUmVzZWFyY2ggICBQcm8908SDFHLKASDFpb24gMixDb3VudHJ5IDogUs08909WDFHJSDKSDHFALKSwxLCwsT2xpdmVyIFNlcmdlYW50LG9saXZlcnNlcmdlYW50QGhvdG1haWwuY29tLCwwMy8wNi8yMDIxLEFOU1dFUkVELDI0LDI4LDMzLDM5DQo="

}

I have been googling, but to no avail - i simply am failing to understand why the output of the get file content is appearing as it is (in the application/octet-stream format).

Can someone

a) explain what this application/octet-stream is

b) explain how i can extract the contents of this CSV so i can play around with the data

Thanks in advance.

All responses (9)

Answers (1)

Xerxel 67 on 18 Jan 2023 at 19:10:25

Like (0)

Report

Re: Get File Content "$content-type": "application/octet-stream",

Alternatively, paste this into a Compose:

@{decodeBase64(outputs('Get_file_content')?['body']['$content'])}
JozefMacak 8 on 16 Dec 2022 at 12:48:44

Like (3)

Report

Re: Get File Content "$content-type": "application/octet-stream",

You need to decode, what is inside of $content.
This is decode function that you are looking for, pointing to $content from example below:
decodeBase64(outputs('Compose_2')['$content'])

BTW you can paste what is inside of $content to notepad++ and decode via MINE Tools->Base 64 Decode

Hope this helps
kgreen8790 189 on 04 Dec 2022 at 23:01:41

Like (1)

Report

Re: Get File Content "$content-type": "application/octet-stream",

I have mine set to yes but am still getting the octet-stream object with the weird string. I've tried the video link in the accepted solution but it is unfortunately dead.
kgreen8790 189 on 04 Dec 2022 at 22:53:16

Like (0)

Report

Re: Get File Content "$content-type": "application/octet-stream",

The video link is dead. YouTube says that it is due to the account being terminated. I'm also dealing with this same issue and am looking for help.
pthimm 8 on 24 Oct 2022 at 11:00:38

Like (3)

Report

Re: Get File Content "$content-type": "application/octet-stream",

hey mate, instead of a link to your channel a written answer could still be available here, in contrast to your video...
TheSaj 7 on 01 Sep 2021 at 19:34:16

Like (0)

Report

Re: Get File Content "$content-type": "application/octet-stream",

My experience is that it has generally been marked Yes by default. But it did not make a difference.

Though, having it on did prevent my flow from being able to read in and parse the content of a JSON file. In that case, I had to set it to "No".
Community Power Pla... on 31 Aug 2021 at 02:45:10

Like (0)

Report

Re: Get File Content "$content-type": "application/octet-stream",

Here is a solution for you, this works for me all the time.
Have you tried to change the option Infer Content Type to Yes (default is No)?

See the difference in my flow below.

Infer Content Typs = No

Infer Content Type = Yes

Let me know if you need more help with the following steps to extract the CSV data.

Mark as solved if it did answer your question.
TheSaj 7 on 30 Aug 2021 at 20:25:50

Like (0)

Report

Re: Get File Content "$content-type": "application/octet-stream",

I am dealing with the same issue, and trying to find a solution that does not require a third party connector like Encodian, as it is not an option for me.

- Jason
Verified answer

Powerplatform01 386 on 06 Aug 2021 at 17:15:11

Like (2)

Report

Re: Get File Content "$content-type": "application/octet-stream",

@Vstar19

If you want to fetch CSV data and want to save it in SharePoint or in some other location you can refer this video.Also request you to please subscribe this PowerAutomate channel.

(link removed by Admin)