QlikSense (NON CLOUD VERSION) integretion in .NET application

[NanuNic993799]

Hi everyone,

As I mentioned in the post title, I'm trying to implement some QlikSense API in a .NET console application to easily produce a monthly updated version of some reports.

I've seen in several posts and links that this is possible, but the issue is that I don't have the SaaS version of Qlik, only the On-Premise version.

I've tried every possible solution (both HttpRequest and SDK; for the SDK, I've tried every method indicated in the GitHub repo), and I always get this Exception: 'One or more errors occurred. (Unable to establish websocket connection.) (Unable to establish websocket connection.) (Unable to establish websocket connection.) (Unable to establish websocket connection.)'. I've tried to check if I have to add my pc to the WhiteList inside the QMC, but I only can find the Host Allow List, inside the Virtual Proxy

I'd like to try using an API key, but I can't find a way to generate one (I really hope this option isn't limited to the Cloud version).

Can anyone help me?

[rwunderlich]

When you say you've tried every SDK method in the repo, do you mean this repo?

https://github.com/AptkQlik/PublicExamples

There are some great examples there of connecting using the SDK. For on-prem, you can't connect with an API key. The equivalent might be making a certificate connection as shown here
https://github.com/AptkQlik/PublicExamples/tree/master/ConnectDirectRemoteServer

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[NanuNic993799]

I've tried that one to...

[rwunderlich]

When making the direct connection, is the port 4747 open on the Qlik server? Is there an inner exception in the websocket exception?

A good place to get help with the sdk is the qlik dev slack channel at qlikdeveloper.slack.com.

-Rob

[marksouzacosta]

Hi @NanuNic993799,

Have you tried this Qlik Rest SDK?
GitHub - kolsrud/qlik_rest_sdk: SDK for accessing the Qlik Sense REST APIs

This may also help you: qlik-cli | Qlik Developer Portal

Anyway, can you please share your whole .NET SDK Code, the part where you try to setup your connection?

@hugo_andrade may be able to help you as well on Qlik Security Settings.

[Øystein_Kolsrud]

As @marksouzacosta writes, if you post the code you use to configure your connection, then we might figure out what is wrong. In the mean time I'd recommend that you check your firewall settings.

[hugo_andrade]

Hi @NanuNic993799 ,

A few items to help you move forward:

• For Qlik Sense on Windows authentication I would recommend using the certificates method. Super powerful and simpler to use. Start with that: https://help.qlik.com/en-US/sense-developer/May2024/Subsystems/ProxyServiceAPI/Content/Sense_ProxySe...
• The Qlik CLI (API Keys) are meant for Qlik Cloud only. There's a different CLI for Qlik Sense on Windows, you can find more information here: https://community.qlik.com/t5/Official-Support-Articles/How-to-install-Qlik-CLI-for-Qlik-Sense-on-Wi...
• I saw your note about Allow List and Whitelist. These are the same. The name differs based on the version of Qlik Sense. The current language adopted by IT in general is allow list, but you will still find references of whitelist in older documentation.
• Regarding the websocket connection, I would recommend using a valid SSL/TLS certificate, and avoid using self-signed ones. Try to establish the connection using HTTPS instead of HTTP. Lastly, add a flag to skip certificate validation if you can't get a valid SSL/TLS certificate loaded on the Qlik Sense Proxy service.

Keep us posted on your progress fellow Qlikker!