topic Qlik Sense REST API connector in Connectivity & Data Prep

Qlik Sense REST API connector

SS3 — Tue, 21 Dec 2021 14:01:50 GMT

Hi, I'm trying to connect the Netsuite with oauth 1.0 via REST connector from Qlik Sense Cloud. I can successfully load the data via postman with oauth 1.0 and "Add parameters to header" option. I'm trying do the same in Qlik Sense with query Header parameters but with no success (error with "http protocol error 401 unauthorized: Requested resource required authentication" appeared). Does anybody know if this is possible and how to fix it, how to "turn on" an authorization and set the header parameters correctly?

Thank you.

Re: Qlik Sense REST API connector

Quarry — Fri, 04 Dec 2020 23:10:14 GMT

I don't think Qliksense allows oauth

Re: Qlik Sense REST API connector

donovanredbeard — Sat, 05 Dec 2020 00:28:14 GMT

Some authentication requires a multi-step process. You can use WITH CONNECTION () and supply URL, Headers, Body, etc.....

Below is an example of capturing the cookie token from an NTLM authorization.

Set vHost = '127.0.0.1';
Set vPort = '4993';

LIB CONNECT TO 'REST Login'; //Setup LIB to URL auth

//Perform a GET call to NPrinting NTLM login API RestConnectorMasterTable:
SQL SELECT
"Set-Cookie",
"__KEY__response_header"
FROM JSON "_response_header" PK "__KEY__response_header";
[_response_header]:
LOAD [Set-Cookie] AS [Set-Cookie]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY__response_header]);
//Extracts session cookie from the API response
let vCookieRaw = Peek('Set-Cookie',0,'_response_header');
let vCookie = TextBetween('$(vCookieRaw)','Secure,','Path=/',2);
DROP TABLE RestConnectorMasterTable;

RestAppsMasterTable:
SQL SELECT
"__KEY_data"
, (SELECT
"id",
"name", "__FK_items"
FROM "items" FK "__FK_items")
FROM JSON (wrap off) "data" PK "__KEY_data"
WITH CONNECTION( URL "https://$(vHost):$(vPort)/api/v1/apps", HTTPHEADER "cookie" "$(vCookie)" );
[apps_items]:
LOAD [id] AS [apps_appId],
[name] AS [apps_appName]
RESIDENT RestAppsMasterTable
WHERE NOT IsNull([__FK_items]);

DROP TABLE RestAppsMasterTable;

Re: Qlik Sense REST API connector

stevedark — Sat, 05 Dec 2020 13:52:17 GMT

I've posted an example of OAuth with Jira to this thread, which may also help:

https://community.qlik.com/t5/Qlik-Connectors-Discussions/Qlik-Sense-Rest-API-Connector-for-Jira-Getting-custom-fields/m-p/1749299/highlight/true#M2456

Steve