topic Re: Triggering Sense reloads/tasks from Qlikview script via API, can't get the cookie information for the POST in Integration, Extension & APIs

Triggering Sense reloads/tasks from Qlikview script via API, can't get the cookie information for the POST

sique132 — Thu, 30 Dec 2021 20:05:56 GMT

I am trying to trigger the reload of Qlik Sense QMC tasks/apps using the rest connector in a QlikView file much like you would do for triggering NPrinting tasks but I am unable to get the Session Cookie id with a GET call. The only connections that seem to work are only allowing CSV response type which QlikView won't handle but also do not have the cookie. I've seen a ton of other posts where people are struggling with the POST aspect but I haven't found one explaining how to get the Cookie as the first step.

I'm using windows authentication and from my understanding that means I have to go through the virtual proxy. I've tried every possible combination I can think of and have hit a wall. Any help is much appreciated.

Re: Triggering Sense reloads/tasks from Qlikview script via API, can't get the cookie information for the POST

Damien_V — Fri, 07 Jan 2022 10:58:53 GMT

Hello @sique132

Could you try to change the endpoint to /rim1/qrs/about instead of /rim1/qps/about/info ?
Also, try to add a request header called "Agent" with value "Windows" so that it knows it has to use Windows authentication and not form authentication.

Re: Triggering Sense reloads/tasks from Qlikview script via API, can't get the cookie information for the POST

sique132 — Fri, 07 Jan 2022 16:04:57 GMT

Hi Damien, same error is generated.

Re: Triggering Sense reloads/tasks from Qlikview script via API, can't get the cookie information for the POST

Damien_V — Wed, 12 Jan 2022 13:25:52 GMT

Hello @sique132
Can you send screenshots of the altered REST connection ?

Also, can you confirm that the "rim1" virtual proxy has "Windows" set as the authentication pattern in the QMC ?

Re: Triggering Sense reloads/tasks from Qlikview script via API, can't get the cookie information for the POST

sique132 — Mon, 24 Jan 2022 17:15:08 GMT

So I went to check that on a test proxy I made which has the same method listed as "Ticket" and we don't seem to have NTLM as an option. Am i missing that method or misunderstanding the setup?

Re: Triggering Sense reloads/tasks from Qlikview script via API, can't get the cookie information for the POST

Marc — Tue, 25 Jan 2022 01:46:05 GMT

In Qlik Sense have a look at the Data connection monitor_apps_REST_task. This Data connection does a Get Against the /qrs/task api for the monitoring apps, but is a working example of what you need to communicate with the QRS api's and it should be fairly easy use as a basis for your Post request.

alternatively you why not try something like this.

https://community.qlik.com/t5/QlikView-Documents/QlikView-and-Windows-PowerShell/ta-p/1497315

A simple PowerShell script saved as a .ps1 would then be all that you needed.

using https://github.com/ahaydon/Qlik-Cli-Windows

Connect-Qlik -Computername QlikSenseServerHostName -TrustAllCerts Start-QlikTask -id 00000000-0000-0000-0000-000000000000

https://github.com/ahaydon/Qlik-Cli-Windows/wiki/Installation