question

PresswalaAzizCIBTechIND-6618 avatar image
0 Votes"
PresswalaAzizCIBTechIND-6618 asked ·

Inetgrate a custom REST API with Microsoft SSRS

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

sql-server-reporting-services
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

cooldadtx avatar image
0 Votes"
cooldadtx answered ·

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.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered ·

Hi @PresswalaAzizCIBTechIND-6618,

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



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.