REST Connector does not pass Query Headers, but only when loading data, not in selection
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.
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.