Hi,
I have the following query that I'm using in QlikView to extract information like task IDs from NPrinting. It works in our existing system, but in the new one I just setup it returns no values. As far as I can tell the configuration is the same on both systems with the same versions of QlikView and NPrinting. Connection string seems to work fine. Anyone have any ideas on what's going on?
let vEndpoint= '$(vNPrintingServer)' & '/api/v1/' & '$(vObject)' ;
Switch vObject
CASE 'users'
let vRESTFieldName='userName';
let vObjectName = chr(39) & vObjectName & chr(39);
CASE 'tasks'
let vRESTFieldName='name';
CASE 'tasks?type=import'
let vRESTFieldName='name';
Default
let vRESTFieldName='name';
let vObjectName = chr(39) & vObjectName & chr(39);
end Switch
CUSTOM CONNECT TO $(vAPIConnectionNameForGET);
RestConnectorMasterTable:
SQL SELECT
"__KEY_data",
(SELECT
"id",
"$(vRESTFieldName)",
"__FK_items"
FROM "items" FK "__FK_items")
FROM JSON (wrap off) "data" PK "__KEY_data"
with Connection (
URL "$(vEndpoint)",
HTTPHEADER "Cookie" "$(vCookie)",
QUERY "Limit" "10000"
);
