I am working on converting an old MS Access report to SSRS, making some much needed improvements along the way. This is for our pharmacy. I've got to incorporate what's known as a National Drug Code (NDC) value into the report, as a flag. I won't go into the details, as its not pertinent to my question. What is pertinent is I've got to reference what is known as the NDC Database, located here. Looking at that link I see that the US Food & Drug Administration has provided various REST APIs. I'm thinking that might be the best way to retrieve the data I need, when generating the report.
However, I've never called an API before in an SSRS report. I don't even know if it's possible. I've search for it using SSRS that would use an API. One website I came across was Microsoft's documentation site Develop with the REST APIs for Reporting Services. This isn't encouraging to me, as it talks about SSRS 2017 and newer. The newest SSRS we've got here is SSRS 2016.
So, I'm wondering a few things. First, am I correct, that SSRS 2016 won't call APIs that someone else, such as the US Food & Drug Administrations provides?
If the answer to question one is yes, then I thought maybe I could write a separate app, that retrieves the needed information from the NDC Database, puts it "somewhere", then have the SSRS report incorporate it somehow. Does that make sense? Has anyone done that before?
Kindest Regards, Rod Connect with me on LinkedIn.