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.
See also: https://www.oauth.com/oauth2-servers/device-flow/token-request/
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;
