The response is not in a JSON format Error code 302

Like (1) Share

Report

Posted on 25 Nov 2024 21:48:36 by StephanJ

Hi all,

I am running into an issue when inserting rows into an Excel file.

I am using the M365 connector 'Send and HTTP request' to POST the rows into an Excel.

The rows are in a JSON format.

The flow works fine if the JSON contains less than 20,000 rows of data. But as my dataset contains 25,000 rows, the flow is throwing a 'Redirect' message with code 302, which is not really an error.

So instead of troubleshooting the error below, I was thinking of finding a solution to the redirect error knowing that the flow works perfectly with less than 20k rows.

    "message": "The response is not in a JSON format.",
    "innerError": "Cannot read server response."
 
Any idea how I can handle this please?
 
Below is my Flow. We are getting the JSON from Powerapps and I am creating the Excel file on Onedrive.

Categories:

Process Advisor

All responses (2)

Answers (0)

StephanJ 71 on 26 Nov 2024 at 17:06:00

Like (0)

Report

The response is not in a JSON format Error code 302

This is what I receive when it is returning the redirect

"Location": "/error/error.html?aspxerrorpath=/x/_layouts/xlrestinternal.aspx",

but in case of success the location is https://graph.microsoft.com/
Nived_Nambiar 17,654 Super User 2025 Season 1 on 26 Nov 2024 at 02:29:07

Like (0)

Report

The response is not in a JSON format Error code 302

Hi @StephanJ ,

when getting the redirect url - any url value is found under response header ?

Thanks & Regards,

Nived N