NP GET Users not working since february update

madmax88 — Thu, 16 Apr 2020 11:37:49 GMT

Hi all

The automatic Qlik Sense - Nprinting Reporting is not working anymore since february 2020 Update.

I have following Entry in the Part "NP GET USER":

// Get User with "user" email

RestUserMasterTable:
SQL SELECT
"__KEY_data",
(SELECT
"id",
"email",
"__FK_items"
FROM "items" FK "__FK_items")
FROM JSON (wrap off) "data" PK "__KEY_data"
WITH CONNECTION( URL "https://aswpqlik.root.net:4993/api/v1/users", HTTPHEADER "cookie" "$(vCookie)" );

[users_items]:
LOAD
[id] AS [users_userId],
[email] AS [users_userEmail]
RESIDENT RestUserMasterTable
WHERE NOT IsNull([__FK_items]) AND SubStringCount([email], 'su_aswpqlik@xy') <> 0;

//Extracts the userId of the desired NP User
let vUserId = Peek('users_userId',0,'users_items');

DROP TABLE RestUserMasterTable;

Error Message:

HTTP protocol error 403 (Forbidden): The server refused to fulfill the request.: RestUserMasterTable: SQL SELECT "__KEY_data", (SELECT "id", "email", "__FK_items" FROM "items" FK "__FK_items") FROM JSON (wrap off) "data" PK "__KEY_data" WITH CONNECTION( URL "https://aswpqlik.root.net:4993/api/v1/users", HTTPHEADER "cookie" "" )

Connection is working (Tested ok).

Any idea?

topic NP GET Users not working since february update in Integration, Extension & APIs

NP GET Users not working since february update