Share via

SRSS REST API get the content of the Report

Aileen Sable 0 Reputation points
2024-06-06T02:08:04.9866667+00:00

Hello,

I am new to SRSS and we were introduced REST API being available. I am confused about the swagger/OpenAPI document with regards to this endpoint

/Reports({{Id}})/Content/$value

Here are my questions:

  1. What does this return? Is this the content e.g. the records of the report?
  2. What is the $value? Should that be defined?

Another question would be, is it possible using the REST API to download the data (contents) of the report the same way as the "ReportExecution - Render" does and save it as .csv file?

I have this question because what we wanted to do is have a scheduled event and download the report and save it to our data lake.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,869 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 35,381 Reputation points
    2024-06-06T06:54:26.9666667+00:00

    Hi @Aileen Sable,

    What does this return? Is this the content e.g. the records of the report? /Reports({{Id}})/Content/$value

    It is used to get the content of the specified Report CatalogItem specified by the Id.

    What is the $value? Should that be defined?

    No, you only need to define the Id.

    See Reports - Get Report Content

    As far as I know, we could not use REST API to download the data.

    But you could do that via URL access.

    See Export a report by using URL access

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.