It is possible to download a report using REST API?

Hi @ Miguel Based on my search, you can download the report in .rdl format using the API. I have tested and here is my example URL which successfully downloads the report in .rdl format. http://localhost/reports/api/v2.0/Reports(31E91AFB-A8A8-487D-83B8-42E17F0C5390)/Content/$value Best regards, Aniya

Sure, see https://learn.microsoft.com/en-us/sql/reporting-services/report-server-web-service/methods/rendering-and-execution-methods?view=sql-server-ver16

Load Report wih API REST

Accepted answer

AniyaTang-MSFT 12,311 Reputation points Microsoft Vendor

2023-05-05T06:56:43.58+00:00
Hi @Miguel

Based on my search, you can download the report in .rdl format using the API.

I have tested and here is my example URL which successfully downloads the report in .rdl format.

http://localhost/reports/api/v2.0/Reports(31E91AFB-A8A8-487D-83B8-42E17F0C5390)/Content/$value

Best regards,

Aniya
Please sign in to rate this answer.
Miguel Ortiz Jiménez 20 Reputation points

2023-05-05T07:41:47.1333333+00:00

Hello @AniyaTang-MSFT

But, is there a method similar to SOAP's LoadReport? I would like to know that is possible to download a pdf report by REST API.

Best Regards,

Miguel

AniyaTang-MSFT 12,311 Reputation points Microsoft Vendor

2023-05-05T08:02:38.73+00:00

Hi @Miguel

Based on my search, it seems that no way to download the report directly as a pdf file using the rest api was found. For more information about the features of the rest API in SSRS, you can check this link: https://learn.microsoft.com/en-us/sql/reporting-services/developer/rest-api?view=sql-server-ver16.

However, there is an alternative way to generate reports using URL Access (SSRS). You can see this link: https://learn.microsoft.com/en-us/sql/reporting-services/export-a-report-using-url-access?view=sql-server-ver16.

For example:

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fTest%2fCanGrow&rs:Command=Render

If these answers are useful, please click Accept Answer to let others with similar questions quickly find answers. If you have any questions, please feel free to let me know.

Best regards,

Aniya
Sign in to comment

Load Report wih API REST

1 additional answer