Getting a file content on MS Flow using C#

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I was trying to get a file content from my one drive account and pass & read it on my API using custom connector.

Here is my flow I created:

And here is my data models in my API:

However, as I run my MS flow, I got this error:

As you can see that the error might be because my context's data type is a string but apparently the File Content passed by one drive connector is not a string but a binary (I tried to put a simple string instead of a File Content on my flow and it works). What would be the data type I can use in my API to be able to store the file content passed by the one drive connector? is this a right way to do this? or Is there a better way to do this?

Thanks Smiley Happy

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-yamao-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

If you are trying to transfer a binary file into a JSON string, you need to encode it. Please try to use base64 encoding, and your API will have to decode it. then you will use format with the value byte.

file:

       descrption:File content

       type:string

       format:byte

More details about registering and using Custom APIs, please check the docs at here:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/register-custom-api



Best regards,

Mabel Mao

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (2)

Report
Copy link

Link copied!

@v-yamao-msftThanks for the replay 🙂

I finally found the solution. I thought when we get the File Content from API, it will return some kind of base64 string. But it turns out that it will return JSON file, which has 2 property ($content-type and $content). And $content is the one that has the encoded content.

So what I did was I pulled the file content to my API as JSON formatted file, get its $content property, and convert it with convert.FromBase64String

Was this reply helpful? Yes No
deepakmsflow 23 on at

Like (0)

Report
Copy link

Link copied!

Hi, I have a question and I am new to MS flow, How did you got the template "Get File content using a path" I did a search in the Templates,but I couldn't find,

Was this reply helpful? Yes No
CurtisJohnson89 14 on at

Like (0)

Report
Copy link

Link copied!

Hey deepakmsflow

you should probably start a new post for this question rather than tagging on to this post. If you search 'onedrive' then it gives you all the actions, you might be looking in the trigger section rather than the action section.

Was this reply helpful? Yes No