Share via

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,972 questions
0 comments
Accepted answer
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-05-15T02:51:53.7333333+00:00

    Hi @76719856

    I'm sorry I don't know much about APIs. I found a thread similar to yours, maybe you can use it as a reference.

    https://stackoverflow.com/questions/19790123/consume-web-api-in-ssrs-with-parameter

    Best regards,

    Aniya

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.