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

junseiuchida — Tue, 13 Mar 2018 07:39:00 GMT

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.

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

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

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