Customer experience | Sales, Customer Insights,...

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

(1) Share

Report

Posted on by Tapaswini Sabat

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."

}

Can anyone please help me with any links/videos to fix the issue apart from these.

Thanks in advance.

I have the same question (0)

All responses (9)

Answers (0)

Chaitali12 5 on at

Like (0)

Report
Copy link

Link copied!

Hello,

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

Thanks in advance

Was this reply helpful? Yes No
Abdul Wahab 12,119 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Tapaswini Sabat,

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

Is it?

CRM Report Viewer?

.....

Download PDF?

Was this reply helpful? Yes No
Tapaswini Sabat 7 on at

Like (0)

Report
Copy link

Link copied!

Hi Abdul Wahab,

The error is with Download PDF.

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

Thanks in Advance

Was this reply helpful? Yes No
Suggested answer

Ryan Blaikie 4 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
kvp_patel 217 on at

Like (0)

Report
Copy link

Link copied!

Hello Everyone,

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

Thanks in advance

Was this reply helpful? Yes No
Talha Manzoor 33 on at

Like (1)

Report
Copy link

Link copied!

this video will help you How to Call SSRS Report In Power Automate Flow and send the report as a pdf file to Email

Was this reply helpful? Yes No
Suggested answer

vincent_p74 6 on at

Like (2)

Report
Copy link

Link copied!

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.

1 people found this reply helpful.

Was this reply helpful? Yes No
BE-30032328-0 5 on at

Like (1)

Report
Copy link

Link copied!

Hi Everyone, Just wanted to let you know that we implemented the fix that vincent_p74 recommended by adding the cookie to the 2 http requests and it now works every time. Great tip and resolved our issues. Thanks!

Was this reply helpful? Yes No
pp_csonthejjas 2 on at

Like (0)

Report
Copy link

Link copied!

My main issue was that the initial post request did not worked for me (500 internal server error), but after i figured that out and resolved that i ran into this issue too.
In both cases the resolution for me was to add the appropriate Accept header to the request.

Initial reportviewer request: Accept: text/*; charset=utf-8
For the download pdf: Accept: application/pdf; charset=utf-8

With the above additions now both request is stable for me.

For some reaseon, the SSRS server needs an explicit definition of the Accept header, but this is nowhere documented as far as i can tell.

Was this reply helpful? Yes No