Inetgrate a custom REST API with Microsoft SSRS

Presswala, Aziz (CIB Tech, IND) 1 Reputation point
2021-03-03T13:18:34.377+00:00

I want to integrate a REST API that I built in Java with Microsoft SSRS 2017. Please help

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,797 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michael Taylor 47,806 Reputation points
    2021-03-03T15:09:32.747+00:00

    While I don't personally think this is a good idea there is a blog article from way back in 2015 that talks about using an API as a data source in an SSRS report. The key, at the time at least, was to ensure the API returned data in XML. If it doesn't then SSRS won't work (at least then) because it doesn't understand JSON. In new SQL versions it may now work as JSON is a supported format in SQL.

    0 comments
  2. ZoeHui-MSFT 32,581 Reputation points
    2021-03-04T06:15:43.737+00:00

    Hi @Presswala, Aziz (CIB Tech, IND) ,

    Not familiar with develop and java.

    A modern REST API calls for modern API documentation. The REST API is built on the OpenAPI specification (also called the swagger specification) and documentation is available on SwaggerHub. Beyond documenting the API, SwaggerHub helps generate a client library in the language of choice - JavaScript, TypeScript, C#, Java, Python, Ruby, and more.

    Official documentation about SSRS Rest API, please refer:

    rest-api

    Reporting-Services
    Regards，

    Zoe

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments