SSRS report integration API with parameters

76719856 40 Reputation points
2023-05-12T06:54:23.0933333+00:00

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.

API_DataSource

This is the error image.

SSRS_Error

Thanks.

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