topic Re: Retrive Group users info from Nprinting API in Qlik NPrinting

Retrive Group users info from Nprinting API

Woojtek_96 — Fri, 15 Nov 2024 22:15:13 GMT

Hi all,

I'm trying to retrive info about users in my groups from NPrinting API.

I stuck at:

So far I managed to retrive info about tasks, users, groups. In this request I want to retrive users from particular group.
In place where I load data i have to select desired fields but when i write "guid" i don't have any resposne. The same is for Guid, guId, GuID etc. I had tried many combinations.
For example when I was retriving info for users i have field named "UserName" but in qlik script field name is "userName" finally worked

I had readed many websites and topics on this forum and didn't find anything helpful.
Other case is to know which fields I'm getting from API, I can't make select * so maybe some kind of for.. each?
but I don't know how to write it (in Select Statement?)
In addition i'm pasting my QV script:

Thanks for all help

Re: Retrive Group users info from Nprinting API

JHuis — Mon, 11 Apr 2022 08:47:29 GMT

Hi,

You could use the next links they were a real life saver. I hope this helps?

https://nprintingadventures.com/2019/11/28/nprinting-api-qlik-rest-subroutines-v1-1/

Re: Retrive Group users info from Nprinting API

Woojtek_96 — Mon, 11 Apr 2022 09:48:05 GMT

Unfortunately, I didn't find any useful info in this links. But thank you very much for help

Re: Retrive Group users info from Nprinting API

Miguel_Angel_Baeyens — Mon, 11 Apr 2022 09:52:09 GMT

Take the examples from here:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-use-Qlik-NPrinting-APIs-inside-a-Qlik-Sense-load-script/td-p/54441

Although it refers to Qlik Sense script, the logic and syntax is all valid except for the data connection.

Re: Retrive Group users info from Nprinting API

Woojtek_96 — Mon, 11 Apr 2022 10:00:15 GMT

@Miguel_Angel_Baeyens I Based on this with creating tables for authentication, tasks andusers. But in this doc there isn't anything about groups

Re: Retrive Group users info from Nprinting API

Miguel_Angel_Baeyens — Mon, 11 Apr 2022 10:10:51 GMT

Since you already have the user IDs, you can use something like this:

LET vAllGroups = 'https://server:4993' & '/api/v1/users/' & '$(vNPUserID)' & '/groups' ;

... do something ...

For example, to add a user to a group

Table:
SQL SELECT
"__KEY_data"
FROM JSON "data" PK "__KEY_data"
WITH CONNECTION
(
URL "$(vAllGroups)",
BODY "$(vGroupIDs)", //ID or IDs of groups
HTTPHEADER "Origin" "$(vQlikSenseServer)",
HTTPHEADER "Content-Type" "application/json",
HTTPHEADER "X-HTTP-Method-Override" "PUT",
HTTPHEADER "cookie" "$(vCookie)",
QUERY "Limit" "1000000"
);

Some other good examples here: https://community.qlik.com/t5/Connectivity-Data-Prep/Nprinting-Rest-Get-user-groups/td-p/1535570

Re: Retrive Group users info from Nprinting API

Woojtek_96 — Mon, 11 Apr 2022 10:23:21 GMT

@Miguel_Angel_Baeyens This is what i looking for.

Thank you very much and have a nice day