Qlik NPrinting API - How to get values of items array inside Qlik Sense Load Script

[junseiuchida]

Hi,

I tried to get NPrinting's Users/Filters/Groups from Qlik Sense LoadScript with Qlik NPrinting APIs.

I referred to the document attached in this thread "How to use Qlik NPrinting APIs inside a Qlik Sense load script", but I couldn't understand how to get values of "items" array like below.

• GET /users/{id}/groups
• GET /groups/{id}/users

I couldn't search any information in the web,, so, I'd like to post this article.

RestConnectorMasterTable:

SQL SELECT

  "__KEY_data",

  (SELECT

  "@Value",

  "__FK_items"

  FROM "items" FK "__FK_items" ArrayValueAlias "@Value")

FROM JSON (wrap off) "data" PK "__KEY_data"

WITH CONNECTION( URL "https://nprintingserver.domain.com:4993/api/v1/users/<user's id>/groups", HTTPHEADER "cookie" "$(vCookie)" );

//you refer to the document what "$(vCookie)" means

[items]:

LOAD

  [@Value] AS [Values],

  [__FK_items] AS [__KEY_data]

RESIDENT RestConnectorMasterTable

WHERE NOT IsNull([__FK_items]);

I pray for it to work!

Junsei UCHIDA