SSRS report integration API with parameters

Question

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.

Thanks.

Answer 1

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