SRSS REST API get the content of the Report

Question

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.

Answer 1

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.