Rest Connector Query Returns No Values

lgtsotrsdh — Mon, 26 Jan 2026 21:26:37 GMT

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"

);

Re: Rest Connector Query Returns No Values

lgtsotrsdh — Wed, 24 Jul 2024 15:06:09 GMT

FYI, I just fixed this, but I'll leave the question here just in case anyone runs into something similar. The email address for the NPrinting Default User wasn't setup correctly.

topic Rest Connector Query Returns No Values in QlikView

Rest Connector Query Returns No Values

Re: Rest Connector Query Returns No Values