Extract roles ids using NPrinting API

[slogue1234]

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

[Frank_S]

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-...

Kind regards...

[Ruggero_Piccoli]

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

[Lech_Miszkiewicz]

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

[slogue1234 · Accepted solution]

Hi 

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",);