Qlik Community

Qlik Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。質問に関する回答は基本的に日本語で行われます。 日本語資料はグループにJoinしなくてもダウンロード可能ですが、 質問を投稿したい場合は、CommunityへJoin Groupを行って下さい。 Join後に質問を投稿することが可能になります。 ログインはQlikIDを登録してください。

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
Explorer
Explorer

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

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


Tags (1)