Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / 302 (The response is n...
Customer experience | Sales, Customer Insights,...
Suggested answer

302 (The response is not in a JSON format) error in Power Automate for SSRS report

(1) ShareShare
ReportReport
Posted on by Tapaswini Sabat 7

Hi,

I have created a flow to send SSRS report in PDF format. However, I'm getting the below error with HTTP GET request to download the PDF.

{
  "error": {
    "code": 302,
    "message": "The response is not in a JSON format."
  }
}
pastedimage1667477885966v1.png
Can anyone please help me with any links/videos to fix the issue apart from these.
  1. Using Dynamics 365 Reports as a PDF in Power Automate - YouTube
  2. Download Dynamics 365 Reports as a PDF with Power Automate » reenhanced
  3. Download SSRS report as a PDF with Power Automate - Part 1 - CloudFronts
Thanks in advance.
  • Suggested answer
    vincent_p74 Profile Picture
    vincent_p74 2 on at
    302 (The response is not in a JSON format) error in Power Automate for SSRS report
    The 'Do until' loop is nice, but not a real solution. By including the cookie from the first HTTP request (Report Viewer) to the second HTTP request (Download PDF), it works every time on the 1st try.
     
  • Talha Manzoor Profile Picture
    Talha Manzoor 31 on at
    302 (The response is not in a JSON format) error in Power Automate for SSRS report
  • kvp_patel Profile Picture
    kvp_patel 217 on at
    302 (The response is not in a JSON format) error in Power Automate for SSRS report

    Hello Everyone,

    I'm also facing same issue if you have resolved it could you help me out?

    Thanks in advance

  • Suggested answer
    Ryan Blaikie Profile Picture
    Ryan Blaikie 4 on at
    302 (The response is not in a JSON format) error in Power Automate for SSRS report
    Hi there,
     
    I also encountered this issue on this step when following the linked blog post. I noticed that the error was intermittent and not due to any problem in the request itself; sometimes it would fail and sometimes it would succeed without any apparent rhyme or reason. In my case I used a 'Do until' step combined with a try/catch scope and a flag marking the outcome to repeat the action until it is successful:

     
     
     
             
     
    This has resolved the issue for me. Cheers
  • Tapaswini Sabat Profile Picture
    Tapaswini Sabat 7 on at
    RE: 302 (The response is not in a JSON format) error in Power Automate for SSRS report

    Hi Abdul Wahab,

    The error is with Download PDF.

    Please do let me know if any further information is required.

    Thanks in Advance

  • Abdul Wahab Profile Picture
    Abdul Wahab 12,085 Moderator on at
    RE: 302 (The response is not in a JSON format) error in Power Automate for SSRS report

    Hi Tapaswini Sabat,

    May I know the exact component on which you are experiencing this error?

    Is it?

    CRM Report Viewer?

    .....

    Download PDF?

  • Chaitali12 Profile Picture
    Chaitali12 5 on at
    RE: 302 (The response is not in a JSON format) error in Power Automate for SSRS report

    Hello,

    Struggling with the same issue if you have resolved it could you help me out?

    Thanks in advance

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,207 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans