Rest api as sql server reporting service datasource with paramters

Dimitri Vandoorne 1 Reputation point


I would like to use rest api as datasource for ssrs report.

If I use my api (for ex: "https://localhost/products") the it is possible to het the information.

But if i want to use a parameter (for ex: "https://localhost/products?product=123"), how can i define the parameter in my ssrs report?


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,356 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 5,476 Reputation points Microsoft Vendor

    Hi @Dimitri Vandoorne
    Actually, I'm not particularly familiar with the REST API, but I found this link for you: unable-to-pass-in-parameters-to-dataset-using-ssrs-2017-rest-api-feature. It provides a way to pass parameters to Dataset.
    Hope this can help you.
    Best regards,