topic Re: REST connector not sending cookie header in Connectivity & Data Prep

REST connector not sending cookie header

JMohlmann — Thu, 23 Dec 2021 12:52:43 GMT

Hi all,

One of the application that I have build for my company makes use of a REST connector to an internal server to get data. Validation of the user on that server is done by logging in using a username and password. The server creates for that session a cookie which can be used for all next GET request authentication.

Since the company updated to the June 2020 patch 2 still connector is not getting any data anymore. The validation with the session cookie fails. I can see that the part of collecting the cookie works. I can use that cookie in postman to reach the exact same endpoints and still get data.

Next was to try and see what headers are posted to the endpoint. Using webhooks I posted one request from Qlik and 1 from Postman. The Qlik REST connector fails to post the 'Cookie' header. I have absolutely no idea why this fails. A ticket is already submitted to our own qlik support team but they also have no idea why the connector fails to post the cookie header since the update.

So, anyone an idea on why the cookie header is not posted? Other headers are posted.

Code example:

SQL SELECT
"Name"
FROM JSON (wrap on) "root"
WITH CONNECTION (
Url "https://webhook.site/testwebhook",
HTTPHEADER "cookie" "$(sessionid)", // Does NOT work
HTTPHEADER "Cookie2" "tst", // Does work
HTTPHEADER "DNT" "1" // Does work
);

Re: REST connector not sending cookie header

JMohlmann — Mon, 24 Aug 2020 13:33:50 GMT

Apparently this might have something to do with QB-1890, which only seems to focus on connecting to NPrinting but does affect everything that uses cookie headers in POSTS

Re: REST connector not sending cookie header

blaise — Mon, 07 Sep 2020 11:39:44 GMT

any new on this @JMohlmann ? Have you been in contact with Qlik Support?

Re: REST connector not sending cookie header

blaise — Mon, 07 Sep 2020 11:49:06 GMT

i just created my own api listener using node and express and can verity that Qlik Rest Connector June2020 (QS Desktop june2020 path3) does NOT send a request header if its called "cookie".

Re: REST connector not sending cookie header

JMohlmann — Mon, 07 Sep 2020 13:06:59 GMT

There has been some contact with Qlik by the helpdesk of my company, but without any solution.

I still need to explain the exact issue each time to new people (NOT sending request header with the name 'cookie'). So still no progress since the issue arose within my project 6 weeks ago.

Re: REST connector not sending cookie header

blaise — Tue, 08 Sep 2020 07:59:54 GMT

I have filed a ticket to Qlik Support. Will update you on the progress @JMohlmann

Re: REST connector not sending cookie header

JMohlmann — Tue, 08 Sep 2020 10:12:09 GMT

Thank you, I will also update you if there is any progress on my side.

Re: REST connector not sending cookie header

blaise — Mon, 14 Sep 2020 08:13:26 GMT

confirmed as a bug by Qlik Support. Solved in QS Sep2020 @JMohlmann

Re: REST connector not sending cookie header

JMohlmann — Mon, 21 Sep 2020 08:18:57 GMT

Thank you very much Blaise, you are my hero. My company is working with Qlik on this for two month and we did not get any further than weekly being asked to explain the issue and show the logs. For the 6th time now..

Again thank you for understanding and examing the issues with only 1 post describing the issue.

Re: REST connector not sending cookie header

JMohlmann — Fri, 02 Oct 2020 09:53:25 GMT

Blaise, do you have a support/ticket ID? This will help in aligning our internal efforts with this issue.

Re: REST connector not sending cookie header

weinerch — Fri, 02 Oct 2020 11:52:25 GMT

Hi,

we use Qlik Sense September 2020 Patch 1 and have the same problem. When I write:

WITH CONNECTION(HTTPHEADER "Content-Type" "application/json",
HTTPHEADER "cookie" "user-token=$(authToken1)",
HTTPHEADER "x-xsrf-token" "$(authToken2)"

I receive the following error:

HTTP protocol error 401 (Unauthorized): Requested resource requires authentication.

When I use Postman everything works fine.

Re: REST connector not sending cookie header

blaise — Fri, 02 Oct 2020 14:18:30 GMT

@JMohlmann 02056221