Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

The response is not in a JSON format Error code 302

Like (1) ShareShare
ReportReport
Posted on 25 Nov 2024 21:48:36 by 71
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:
  • StephanJ Profile Picture
    71 on 26 Nov 2024 at 17:06:00
    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 Profile Picture
    17,654 Super User 2025 Season 1 on 26 Nov 2024 at 02:29:07
    The response is not in a JSON format Error code 302
    Hi @ ,
     
    when getting the redirect url - any url value is found under response header ?
     
     
    Thanks & Regards,
    Nived N
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - General Discussion

#1
stampcoin Profile Picture

stampcoin 25

#2
Pstork1 Profile Picture

Pstork1 22 Most Valuable Professional

#3
David_MA Profile Picture

David_MA 20 Super User 2025 Season 1

Overall leaderboard
Loading started