Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

The response is not in a JSON format Error code 302

Posted on 25 Nov 2024 21:48:36 by 69
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
    StephanJ 69 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
    Nived_Nambiar 16,505 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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard

Featured topics