Can SSRS report connect to an API?

Sana 1 Reputation point
2021-11-03T18:05:10.577+00:00

Hi,

I would like to know if we can connect to an API (in other words use an API as a data source) for a SSRS 2014/2019 report?

I was searching about it but could not find any information. Has anyone tried it before?

Thank in advance for all your 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,798 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Isabellaz-1451 3,616 Reputation points
    2021-11-04T01:39:58.987+00:00

    Hi @Sana ,
    I think your issue is similar to this thread,please take a look at.

    how-to-authorize-rest-api-resource-as-ssrs-data-source-in-report-server

    Best Regards,
    Isabella

    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.

    0 comments