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?
