After upgrade from Nprinting February 2020 to February 2020 Patch 1 starting tasks from qlik sense stopped working.
Yesterday everything was fine.
There is a problem with post method.
Wystąpił następujący błąd:
HTTP protocol error 403 (Forbidden): The server refused to fulfill the request.
I've checked:
On Demand settings in nprinting (name and address is correct - same as in Qlik Sense connections in Query headers section)
Report has option : Enable On-Demand and API report generation.
Get call is ok.
Could it be a Feb2020 patch1 problem?
My script:
let vTaskId='XXXXXX';
let vPublshTaskURL='https://nprinrintgaddress:4993/api/v1/tasks/'&'$(vTaskId)'&'/executions';
LIB CONNECT TO 'Nprinting REST Login (GET)';
//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;
LIB CONNECT TO 'Nprinting REST Login (POST)';
RestNPTaskTriggerTable:
SQL SELECT
"__KEY_data"
FROM JSON (wrap off) "data" PK "__KEY_data"
WITH CONNECTION( URL "$(vPublshTaskURL)", HTTPHEADER "cookie" "$(vCookie)");
[_post_items]:
LOAD [__KEY_data] AS [__KEY_data]
RESIDENT RestNPTaskTriggerTable
WHERE NOT IsNull([__KEY_data]);
DROP TABLE RestNPTaskTriggerTable;
