question

alan2468 avatar image
alan2468 asked

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 comment
10 |1200

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

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 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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