search

xHeliotrope / redcap-wdc

REDCap Web Data Connector for Tableau
6 stars 7 forks source link

Not pulling data #1

Open carsonk3 opened 7 years ago

carsonk3 commented 7 years ago

When I enter my REDCap site and my API token, it doesn't pull data. It continues to execute query for an extended period of time without successfully pulling data. I'm using a different REDCap host than the original programmer used (mine is redcap.iths.org). Would that make a difference in pulling data since I enter my REDCap API site?

xHeliotrope commented 7 years ago

I'm not 100% sure, but you may need to use the URL associated with the specific university at redcap.iths.org. For example, the Washington University Demo server's url is https://redcap.wustl.edu/redcap/srvrs/dev_v3_1_0_001/redcap/, so I imagine the one for your specific university should be a bit longer than redcap.iths.org.

Sorry, I may not be able to debug this problem further, since I don't have access to your specific server.

carsonk3 commented 6 years ago

I discussed with our administrator but it seems that it has to do with the log-in process. Ours uses Shibboleth authentication, while I think your might be using a table authentication process. I'm working on sorting out the kinks. fingers crossed

xHeliotrope commented 6 years ago

I'm not so sure that is the reason. I think the ReST API should work regardless of the auth scheme that is set up on the server, but I guess it is possible.

Have you tested out your API key/url in the REDCap API Playground? if that works, then the problem may be with Tableau. Be sure that you are accessing localhost:3000 through Tableau as a web data connector data source, and that your Tableau version is greater than/equal to 9.

One last thing, is you could test the connector out in the browser(won't actually work), but if you look at the network tab in chrome dev tools, you should be able to see why the request to the REDCap API is failing, that is, if it is failing.

carsonk3 commented 6 years ago

We've tested our API token with other data connectors and unfortunately ours automatically takes us to the Initial login page, where it asks you to give the username and password, rather than collecting the data. The data connectors we've used work with our other research sites whose REDCaps are using table verification instead of Shibboleth. I've checked out the API key/url in the API playground. In the meantime, I'll definitely check out chrome dev tools.

Our REDCap administrator said that Shibboleth requires a specific kind of request that matches the language in the API playground exactly. Unfortunately, the WDC uses javascript rather than Java and I'm rather new to coding, and thus don't know how to change the data appropriately. Do you have any tips for how to properly "translate" the code?

Thanks!

dearfranco commented 5 years ago

I have followed your instruction and have installed on a different server. I would like to connect to the server from my local desktop which run tableau. I am unable to get to redcap_wdc.html page using http://<servername:3000