topic API based users import in Qlik NPrinting with a Qlik Sense app in Qlik NPrinting

API based users import in Qlik NPrinting with a Qlik Sense app

krzohi — Thu, 17 Nov 2022 10:54:46 GMT

Hi all,

i need to transfer all existing users from Qlik Sense to NPrinting. I found video that shows Qlik Sense applications that use API to synchronize users, but provided link to this app is no longer active. https://www.youtube.com/watch?v=WdHCAjerxcc

Anyone from community knows how to do this? Maybe also you know other way to synchronize users?

Re: API based users import in Qlik NPrinting with a Qlik Sense app

Ruggero_Piccoli — Thu, 17 Nov 2022 11:20:35 GMT

Hi,

You can use Qlik NPrinting to create and export an Excel file with users information from Qlik Sense and use the generated file in a Qlik NPrinting import user task. Then you can coordinate the execution of the two tasks via APIs.

Maybe this post https://community.qlik.com/t5/Qlik-Sense-Documents/Distribute-NPrinting-reports-after-reloading-a-Qlik-App/ta-p/1479632 cloud give you some more suggestions.

Best Regards,

Ruggero

Re: API based users import in Qlik NPrinting with a Qlik Sense app

krzohi — Thu, 17 Nov 2022 11:37:35 GMT

Hi @Ruggero_Piccoli ,thank you for fast replay.

How to create this export to Excel file?

Re: API based users import in Qlik NPrinting with a Qlik Sense app

Ruggero_Piccoli — Thu, 17 Nov 2022 11:44:53 GMT

Hi,

Excel template development is explained in detail at https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Intro-Excel.htm

The Excel file created to import users must be exactly as explained in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm#anchor-2

You can download an example from https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/Examples/Examples.htm

Best Regards,

Ruggero

Re: API based users import in Qlik NPrinting with a Qlik Sense app

krzohi — Thu, 17 Nov 2022 12:14:59 GMT

Hi, i think i got the point, thanks!

Re: API based users import in Qlik NPrinting with a Qlik Sense app

Lech_Miszkiewicz — Thu, 17 Nov 2022 12:15:47 GMT

you can also use the subroutines I have written for API simplification

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

Re: API based users import in Qlik NPrinting with a Qlik Sense app

krzohi — Tue, 22 Nov 2022 07:24:26 GMT

Hi,

i'm testing it on other machine and i'm facing with issue, that i'm not getting any values, no matter which api.

Re: API based users import in Qlik NPrinting with a Qlik Sense app

Ruggero_Piccoli — Tue, 22 Nov 2022 10:32:52 GMT

Hi,

I did not understand what the issue is. Do you have a specific error message? In any case about QlikView and Qlik Sense APIs I suggest opening a question on related forums. You will have more chances to have an answer.

About Qlik NPrinting API, you have to start with the NTLM authentication and extract the session cookie:

//Perform a GET call to NPrinting NTLM login API RestConnectorMasterTable: SQL SELECT "Set-Cookie", "__KEY__response_header" FROM JSON "_response_header" PK "__KEY__response_header"; [_response_header]: LOAD [Set-Cookie] AS [Set-Cookie] RESIDENT RestConnectorMasterTable WHERE NOT IsNull([__KEY__response_header]); //Extracts session cookie from the API response let vCookieRaw = Peek('Set-Cookie',0,'_response_header'); Let vCookie = TextBetween(vCookieRaw,'SameSite=None,',' Path=/',SubStringCount(vCookieRaw,'SameSite=None')-1); DROP TABLE RestConnectorMasterTable;

There are many examples in the community like:

Official documentation is at https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/Extending/Intro-Extending.htm

Best Regards,

Ruggero