SSRS report integration API with parameters

76719856 40 Reputation points

I am calling an API from SSRS with a parameter but an API with a parameter is not working every time I am facing an error without a parameter,but API with a parameter is calling successfully from SSRS, and it's working but my project demand is to call an API with a parameter. I have also attached the screenshots for your reference.API is returning XML.

This is my API data source image with the id parameter.


This is the error image.



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

0 additional answers

Sort by: Most helpful