onetcenter / web-services-samples

Sample code using O*NET Web Services API
https://services.onetcenter.org/
MIT License
63 stars 26 forks source link

Qlik Sense REST API? #8

Open flashbangpow opened 2 years ago

flashbangpow commented 2 years ago

Attempting to create a REST connection in Qlik Sense... I've tried server-side with basic auth, with HTTP header, and the client-side parameters, tried multiple configurations (referencing web-services-samples/client-javascript/OnetWebService.js) but haven't been able to successfully connect.

Here's what creating a connection in Qlik Sense looks like:

image image image image

image image

Hopper262 commented 2 years ago

The API error codes help a lot in narrowing down problems, but you didn't tell us what error Qlik Sense is showing you, so we have to start from scratch.

Have you verified your Web Services account is active and working, through the online demo or a different client?

If your account is good, going by the screenshots, this configuration looks like it should work:

URL: https://services.onetcenter.org/ws/about Authentication Schema: Basic (and enter your O*NET Web Services username and password where prompted)

Leave everything else at the defaults shown in your screenshots, and click "Test connection." What does Qlik Sense show in response?

flashbangpow commented 2 years ago

Thank you so much for replying, and apologies for not including the error code >.<

Yes, account looks good: image

Here's what I get using the URL and Basic Auth Schema (everything else at defaults): image

(This is the same response I was getting before)

Hopper262 commented 2 years ago

No worries, I just hope we can get everything working together!

Seeing that error message, my first thought is: can Qlik Sense see any outside server? Do you have other REST connectors working? If not, try a URL like https://www.google.com -- while that isn't an API, it should at least connect and fail at a different step. If you get the same "Failed to connect" error, you may need to adjust your firewall or set the Proxy settings for your network.

flashbangpow commented 2 years ago

Eureka! I do have other REST connectors working, but I'm pretty sure those sites are on the same server - I got the same error with the Google URL.

Would checking "Use Proxy" work? Or would I need to get the https://services.onetcenter.org/ws/about site whitelisted?

Screen Shot 2022-03-11 at 8 27 48 PM
Hopper262 commented 2 years ago

Unfortunately, "Use proxy" only works in conjunction with the right IP Address and Port info, and only if your network has a proxy server set up (sometimes it's used instead of direct whitelists). So, it sounds like you'll need to check with your IT staff, and they should know whether you need to fill those out.

Best of luck getting your connector up and running! Let us know how it goes, either here or in an email to customer service.

flashbangpow commented 2 years ago

Figured it was a long shot :) Thanks so much for your assistance, it's nice to know what the next step needs to be (and much less stressful).