question

alan2468 asked Feb 18, '20

Can SSRS have an API call as datasource passing in a body in json format

I have an api url and the body in json format to return data. Can this be done in SSRS? I can use fiddler and enter the post url and the body and get the json data back. I need to do this in SSRS to report on the returned data.

ssrs

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green · Feb 18, 2020 at 12:25 PM

Not possible at the moment natively in SSRS.

SSRS doesn't support an API or JSON as a data source.

You would need to write something like a CLR procedure to call the API, load the JSON into a table and then pull that table out using a native SQL SELECT and then point the SSRS report to execute the procedure instead.

0 ·