topic Extract roles ids using NPrinting API in Qlik NPrinting

Extract roles ids using NPrinting API

slogue1234 — Fri, 15 Nov 2024 20:58:16 GMT

Hi, I have been using an NPrinting API connection in Qlikview, so far I've been able to GET to users, apps, connections, etc without any problems.

However, I can't figure out how to pull the Role IDs associated with individual User IDs - the "items" column returns null:

RestUserMasterTable:

SQL SELECT

"totalItems" ,

"offset" ,

"limit" ,

"items" ,

"__KEY_data",

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

WITH CONNECTION( URL "https://nprintingserver.domain.com:4993/api/v1/users/$(vUserid)/roles", HTTPHEADER "cookie" "$(vCookie)",

QUERY "Limit" "1000000",);

I can't find anything in the documentation that parses the array

Thanks

Re: Extract roles ids using NPrinting API

Frank_S — Fri, 02 Aug 2024 14:18:40 GMT

Hello

I suggest trying the Nprinting governance dashboard as it may meet your requirement.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-NPrinting-Governance-Dashboard-Version-3-Now-Available/ta-p/1744538

Kind regards...

Re: Extract roles ids using NPrinting API

Ruggero_Piccoli — Mon, 05 Aug 2024 07:39:36 GMT

Hi,

Please when opening a new conversation add only the label of the version you are using: the answer could depend on it. Be also sure you are using a supported environment.

You are using the right API call https://help.qlik.com/en-US/nprinting/February2024/APIs/NP+API/index.html?page=70. If the selected use has roles their IDs will be included in the JSON answer:

I removed the roles of the selected user via UI and re-run the GET call:

So be sure the selected user has roles assigned.

Best Regards,

Ruggero

Re: Extract roles ids using NPrinting API

Lech_Miszkiewicz — Wed, 07 Aug 2024 08:51:36 GMT

Hi @slogue1234

I have written required subroutines in my NPrinting.qvs which covers most of the API endpoints. Feel free to have a look it should be all straightforward there.

https://nprintingadventures.com/2019/04/08/nprinting-api-qlik-rest-subroutines/

cheers

Re: Extract roles ids using NPrinting API

slogue1234 — Thu, 15 Aug 2024 14:35:17 GMT

Thanks for your replies - unfortunately I am unable to use any solution that requires Qlik Sense.

I was able to get my code to work with the below amendment:

RestUserMasterTable:

SQL SELECT

"totalItems" ,

"offset" ,

"limit" ,

"__KEY_data",

(SELECT

"@Value" as "@Value_u1"

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

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

WITH CONNECTION( URL "https://nprintingserver.domain.com:4993/api/v1/users/$(vUserid)/roles", HTTPHEADER "cookie" "$(vCookie)",

QUERY "Limit" "1000000",);