Qlik Community

Qlik Sense Cloud Discussions

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
pgsimon3
New Contributor II

REST Connector does not pass Query Headers, but only when loading data, not in selection

Hi all,

we are connection to SAP Business One Service Layer via the Qlik Sense Cloud REST Connector. It seems like a update for the REST Connector on last Saturday, 15th Jan, broke this connection. Authorization for the API is provided via a cookie that need's to be passed in the Query Header, the connection worked fine since November until Saturday.

As requests from other tools (Power BI, Postman, Restlet client) are all successful, we had a look at the log files together with our SAP provider. The "Test Connection" in the REST Connector Setting is successful, as well as the select data dialog in which we can successfully see the correct data preview. As soon as we want to load data into the app, a 401 Unauthorized error arises.

The SAP log files (screenshot attached) show that the authorization cookie is not passed along correctly when loading data (timestamps 17:53:59, 17:58:23). However, it is passed successfully when testing the connection (timestamp 17:53:28) and in the select data dialog (timestamps 17:53:35, 17:53:37, 17:53:42). The cookie contains a sessionid (sid=) and a routeid (n=).

Anybody experience something similar or has some suggestions? I already did open a corresponding case with the number 01554549 .

@Michael_Tarallo as cloud subscribers don't have full access to the support portal, telephone support ends in endless waiting ques and support via email seems to react quite slow, could you try to escalate that? It prevents the usage of all our apps since one week and now reaches a business critical level as we are not able to access our main data source.

Best

Simon

Labels (3)
1 Solution

Accepted Solutions
Employee
Employee

Re: REST Connector does not pass Query Headers, but only when loading data, not in selection

Hi,

Rest Connector version 2.10.0 was just deployed with Sense version 13.16.3.

Please retry Your scenario now.

Best Regards

Lucke

4 Replies
Employee
Employee

Re: REST Connector does not pass Query Headers, but only when loading data, not in selection

As a quick workaround, you can always try to pass query headers using “WITH CONNECTION” keyword from of SELECT statememt, overriding heareds stored inside the connection object:

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Load-R...
pgsimon3
New Contributor II

Re: REST Connector does not pass Query Headers, but only when loading data, not in selection

Thanks for the reply. That was the solution we implement to always get a new cookie at the beginning of the data load and pass that as a variable in the WITH CONNECTION string. Unfortunately, it does not matter if the Cookie is written in the connector settings or in the WITH CONNECTION, it is not passed to the target server in either way.

Employee
Employee

Re: REST Connector does not pass Query Headers, but only when loading data, not in selection

Hi Simon - I got your note and forwarded on. 

Regards,
Mike Tarallo
Qlik
Employee
Employee

Re: REST Connector does not pass Query Headers, but only when loading data, not in selection

Hi,

Rest Connector version 2.10.0 was just deployed with Sense version 13.16.3.

Please retry Your scenario now.

Best Regards

Lucke