It is quite popular that Web-based data sources authenticate users in the first call, and return authentication credentials as cookies that user needs to use as part of subsequent calls. Example for such API sources are NPrinting API, SAP Business One.
However, as of the latest releases, QlikView and Qlik Sense do not yet support a connector that is able to save cookies for subsequent queries.
The closest to saving cookies is provided by Qlik REST connector, where you may consider:
- Run an initial REST connection to query the authentication URL and retrieve cookies into Qlik variables
- Run subsequent REST connections and use the cookies in (1) as query header parameters
This of course requires the API source to allow sending cookies as a query header. Specific documentation for particular API sources are not available. However you may refer to article How to use NPrinting APIs with Qlik REST Connector
for an example of using cookies with Qlik REST connector (see steps 2-4 in the article).Environment:
- QlikView up to November 2017
- Qlik Sense up to April 2018