I want to integrate a REST API that I built in Java with Microsoft SSRS 2017. Please help
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.
Not familiar with develop and java.
Official documentation about SSRS Rest API, please refer:
If the answer is helpful, please click "Accept Answer" and upvote it.
6 people are following this question.