Get file content using sharepoint path throws 502 bad gateway

[Anonymous]

I'm new to power automate. Could any one please help to resolve the below. 

Flow:

error :

{

  "error": {

    "code": 502,

    "source": "asia-001.azure-apim.net",

    "clientRequestId": "384c2f48-45d4-4754-b9af-2b47b853c364",

    "message": "The response is not in a JSON format.",

    "innerError": "500 INTERNAL SERVER ERROR"

  }

}

[v-chengfen-msft]

Hi @Anonymous ,

Please try to delete this action and add it again.

If you still have problems, could you provide me with all the screenshots of the flow?

I also found some links about 502 errors

The SharePoint server returned an error : "(502) Bad Gateway" – ShareGate

How To Fix a 502 Bad Gateway Error [9 Quick Fixes] (kinsta.com)

Best Regards

Cheng Feng

[Anonymous]

@v-chengfen-msft  I tried deleting and adding the action again but couldn't resolve the error. The flow is when i try to download a csv file i'm getting output as 'click to download'

so created file in drive and while trying to get the content of csv file getting message as badgateway. 

[v-chengfen-msft]

Hi @Anonymous ,

The cause of the error is:
*File Path should input the location of a file in sharepoint, but you filled in a URL.

It is recommended that you use [Create file] of Sharepoint

Best Regards

Cheng Feng

[Anonymous]

@v-chengfen-msft  I tried the above earlier but still getting the same as click to download. I wanted the data from excel could you please assist how to proceed.  

[v-chengfen-msft]

Hi @Anonymous ,

Do you want to get the file content of [Create file]?

Please try:

Here is file content， which contains csv data：

Best Regards

Cheng Feng

[Anonymous]

@v-chengfen-msft  sorry may i know what is the below filecontent.

My flow is 

1.http get using download url - have body; header and no filecontent

2.passing the body to create file -one drive

3. get file content - one drive

Getting same output as 'click to donwload'

I wanted to read the data from the created csv. could you please help

[v-chengfen-msft]

Hi @Anonymous ,

Please try this link:

Parse CSV File Using Power Automate (c-sharpcorner.com)

The content of this link will be more detailed (although it is a file in sharepoint, it should be possible for onedrive):

3 steps to read csv files from SharePoint (sharepains.com)

Hope this helps you

Best Regards

Cheng Feng

[Anonymous]

@v-chengfen-msft  I'm not able to get the content from get content as mentioned in the above provided links. The file created in the flow and need a content of the file.

[v-chengfen-msft]

Hi @Anonymous ,

Sorry, I have been misunderstanding that:
You get the Csv file through Http, and then create the file in one drive through the return value of Http. Finally you want to parse the Csv file to get the data in it.

Could you please tell me what the Http request does?

Best Regards

Cheng Feng

[v-chengfen-msft]

Hi @Anonymous ,

The file content here I thought you got a csv file through the http request, so use this instead of [Body]

[Body] is in File content:

Best Regards

Cheng Feng

 

[Anonymous]

@v-chengfen-msft  Http needs to download a file. The issue is i dont get the csv file from http instead i get a 'Click to download' as output.

So i tried creating file using both onedrive and sharepoint but still getting the same output. I dont find the content to parse csv. Please help to get the content of the csv file instead of output getting displayed as 'click to download' as shown below 

[v-chengfen-msft]

Hi @Anonymous ,

The reason for this problem should be that the http request does not return the Csv file.
Because no file content is returned, subsequent operations are invalid

Best Regards

Cheng Feng

[Anonymous]

@v-chengfen-msft  when i click the link i'm able to view the csv file. Also i'm able to see the result in postman. Please address

[v-chengfen-msft]

Hi @Anonymous 

Since Http can return a file, please check [Create file] to see if creating a file in onedrive is what you want. According to your description, it should be possible to create a file

The Http request returns a file in encoded format, 'Click to download' as output is because of its encoding format, the content cannot be fully displayed on the page, and there is no way to display the data.

You can also follow the link I provided you, parse the csv file created by [Create file], get the data in it, and then process the data.

Parse CSV File Using Power Automate (c-sharpcorner.com)

Best Regards

Cheng Feng

[Anonymous]

@v-chengfen-msft  Thanks Since the data is huge i'm not able to view. I used the file with few rows and i'm able to proceed. May be will complete with test file and run with original file once i complete the flow

[v-chengfen-msft]

Hi @Anonymous 

If your data volume is relatively large, this link finally has a solution to the excessive data volume

3 steps to read csv files from SharePoint (sharepains.com)

If this post helps, then please consider Accept it as the solution to help the other members find it.

Best Regards

Cheng Feng

[Anonymous]

@v-chengfen-msft  i tried hard but couldnt find what's wrong. Followed the provided URL please help to resolve as getting irrelevant output 

[v-chengfen-msft]

Hi @Anonymous ,

From the screenshot you provided, there is something wrong with the format of your csv file.
Please follow the link below to save the file by [Create file]. (This is just a try as I haven't encountered this before in your case)

Solved: Re: Garbled text in CSV file - Power Platform Community (microsoft.com)

Best Regards

Cheng Feng

[Anonymous]

@v-chengfen-msft  Able to view the CSV. No issues in CSV but while trying to convert to json getting the above response. Followed 3 steps to read csv files from SharePoint (sharepains.com)