SSRS REST API, does /Reports support expand

Plugin Team 0

In swaggerhub exists GET /Reports, and "expand" doesn't specify there, but it works for some entities (for example .../v2.0/reports?$expand=HistorySnapshots). Should it work at all? And why expanding Policies (/reports?$expand=Policies) just return an empty array everywhere

1 answer

AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor

2023-04-25T07:00:51.0666667+00:00

Hi @Plugin Team

For the SSRS rest API, you can refer to these links.

https://learn.microsoft.com/en-us/sql/reporting-services/developer/rest-api?view=sql-server-ver16

https://www.mssqltips.com/sqlservertip/5568/sql-server-reporting-services-rest-api/

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya
Please sign in to rate this answer.
Plugin Team 0 Reputation points

2023-04-25T07:17:27.7766667+00:00

And what should I see there? link to the swaggerhub, which I specified in the question?

AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor

2023-04-26T03:23:06.1733333+00:00

Hi @Plugin Team

In fact I don't know much about the API, I searched for a lot of information, $expand it seems to be OData "query options". When using Web APIs, you can add $expand to the end of the base API URL to access information about related data elements.

For more details, you can check out these links.

https://blog.steveendow.com/2021/09/using-metadata-and-expand-with-business.html

http://docs.oasis-open.org/odata/odata/v4.0/os/part2-url-conventions/odata-v4.0-os-part2-url-conventions.html#_Toc372793860

Best regards,

Aniya

Plugin Team 0 Reputation points

2023-04-26T17:20:14.41+00:00

Hi @AniyaTang-MSFT , yeah, but why does it not work with the Policy entity, or where I can ask about it?

AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor

2023-04-28T06:41:24.96+00:00

Hi @Plugin Team

I tested but again returned an empty array. This may be related to the security policy of the report.

https://learn.microsoft.com/en-us/sql/reporting-services/extensions/secure-development/understanding-security-policies?view=sql-server-ver16

Best regards,

Aniya
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSRS REST API, does /Reports support expand

1 answer

Your answer