Connecting Jaspersoft Report to Redcap API

[jcrozier]

We often write .jrxml reports that we upload and run from a website called Oncore.  I'd love to have a report that displays data that its getting through an API that connects to "Redcap".  It seems like it should be possible but I'm struggling.  I'll tell you what I've done so far:

First I went down this rabbit hole in this article here: https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/connecting-web-service-using-json-data-adapter

Redcap has pretty good documentation about everything you'd put into a post command here on a page like this:

 

but A-  I didn't really know how to plug it in, I tried stuff like this and it didn't work:  (just said 403 forbidden)

 

And B-  even if I created a data adapter.... we'd still be missing a piece.  My understanding is that data adapter would just connect my pc running jaspersoft to the API, but the second I've uploaded the jrxml to our Oncore website, it wont be able to connect.


So.... how do I tell my report that when its online, it'll query that API and download the necessary data?  Did I explain that well?

 

 

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Anuja Vilas Bhujbal]

Hello,

 

You can publish the report along with the data adapter so that the report can access the JSON data. Please refer to the below articles for more details-

https://community.jaspersoft.com/wiki/using-data-adapters-fill-reports-json-data-remote-url

https://community.jaspersoft.com/wiki/publishing-data-adapter-tibco-jaspersoft-studio-tibco-jasperreports-server