Jump to content
Changes to the Jaspersoft community edition download ×

Connecting Jaspersoft Report to Redcap API


jcrozier
Go to solution Solved by Anuja Vilas Bhujbal,

Recommended Posts

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:
converted-file.png.f36fa8b32697f0e9a27b302147ed9af0.png

 

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)

converted-file.png.d1f476f6ccda78825612b3690d2bf981.png

 

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?

 

 

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

  • Solution

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

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...