topic How to use Qlik NPrinting APIs inside a Qlik Sense load script in Qlik NPrinting

How to use Qlik NPrinting APIs inside a Qlik Sense load script

Gianluca_Perin — Tue, 20 Feb 2018 11:21:49 GMT

Hi all,

attached you'll find a step by step tutorial explaining how to use Qlik Sense (and also QlikView) load script to interact with the Qlik NPrinting APIs.

The examples include:

Logging in into NPrinting
Collecting data from NPrinting
Reloading metadata for a NPrinting connection
Create, update and delete NPrinting users
Triggering a NPrinting publish task

This document also shows how to use Qlik Sense Tasks to chain these different events directly from QMC.

This tutorial uses standard Qlik REST Connector.

Please read carefully the requirements before to dig into the actual examples.

Enjoy!

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

pablolabbe — Wed, 21 Feb 2018 20:47:30 GMT

This is great for Qlik Sense. What about QlikView ?

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

Daniel_Jenkins — Thu, 22 Feb 2018 04:32:37 GMT

Just a heads-up, you will also need to allow response headers in the REST login connection settings (page 8/9):

HTH - Daniel.

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

Daniel_Jenkins — Thu, 22 Feb 2018 04:34:41 GMT

Hi Pablo,

From page 2 of the document:

The concepts explained in this document are applicable to call all the available NPrinting APIs;

All the examples shown in this tutorial has been tested in a QlikView script as well.

HTH - Daniel.

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

bramkn — Thu, 22 Feb 2018 07:28:05 GMT

I noticed the bug was solved with the last update, like you said when helping metrying to figure this out. But this document with all the examples and such is a great help, thanks!

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

ingoginqo — Thu, 22 Feb 2018 23:57:44 GMT

Gianluca,

this is wonderful ... thank you for the very useful documentation!

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

tan123qlik — Mon, 26 Feb 2018 14:19:05 GMT

I have tried but cannot get the REST connection to work.

I have all the right versions of Nprinting and REST installed.
I have turned of the firewall on the NPrinting server
When I try the get connection I receive the error below
I have tried from my own computer, from a Qlik Sense server and also installed REST+QlikView on the NPrinting server.
I looked in the Nprinting logs and the full error message is:
- Qlik.NPrinting.Repo 18.0.3.0 Qlik.NPrinting.Repo.Service.AuthenticationService 20180226T151015.662+01:00 INFO STRNPRINT 0 0 0 0 0 0 0 0 Windows login failed. No valid Windows identity in the current principal.

Does anyone have a clue what the problem could be?

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

bramkn — Tue, 27 Feb 2018 07:00:58 GMT

You can try API calls on the NPrinting server in the webbrowser to see what is happening.

I am assuming your login is correct and you checked all the correct checkboxes. Is the login you are using the account used to connect Sense and NPrinting together? if not can you try this account and see what happens? I have been playing with this a lot also before the bug was fixed and never had any issues with the login request.

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

Ruggero_Piccoli — Tue, 27 Feb 2018 09:15:17 GMT

Hi,

The logs say "Windows login failed. No valid Windows identity in the current principal.". Please check that you have configured the domain account field for the Qlik NPrinting user you are using.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

tan123qlik — Tue, 27 Feb 2018 15:40:01 GMT

Thanks for your support. I have done more tests but still get the same result. I also installed Postman at the Nprintng server to test. I get the same result from that. See below for the setup from postman and Nprinting. From what I can see the accounts are correct.

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

tan123qlik — Tue, 27 Feb 2018 15:40:31 GMT

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

kfoudhaily — Sun, 04 Mar 2018 13:37:06 GMT

hello, did you check if you are using http or https?

are you using a self signed certificate?

I have tried it out and it seams to working ok for me.

in order to check, you may install Google Chrome ARC extension and see if you succeed to establish an NTLM connection to you NPrinting server.

regards,

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

Daniel_Jenkins — Mon, 05 Mar 2018 03:32:47 GMT

Hi Thomas,

Works for me. The only differences I can see are marked:

HTH - Daniel.

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

Ruggero_Piccoli — Mon, 05 Mar 2018 09:21:59 GMT

Hi,

Did you tried to activate the XHR extension?

Best Regards,

Ruggero

---------------------------------------------

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

tan123qlik — Mon, 05 Mar 2018 12:49:04 GMT

Thanks for all your support.

I finally found the error. I had written https://strnprint:4993/api/V1/login/ntlm

If you look carfully you see a capital "V". When I changed that to a lower case "v" everyting works

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

glacoste — Tue, 13 Mar 2018 20:41:31 GMT

Dear Guys!,

I try follow the example from QlikView but I see the follow error in the step of retry user information:

I have user with locale in 'es' and 'pt-BR' in appear nprinting failt to get information of the pt-BR users !, this is a issue?

I use:

Qlik Rest Connector 1.3.0

QlikView Desktop November 2017 SR1

Qlik NPrinting February 2018 SR1 18.0.4

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

Ruggero_Piccoli — Wed, 14 Mar 2018 11:29:44 GMT

Hi Gustavo,

This seems a bug. To better investigate please open a support ticket. Send us all useful information like the logs and, if possible, a backup of you NPrinting repository.

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

glacoste — Wed, 14 Mar 2018 14:01:32 GMT

I change the locale for the users from 'pt-BR' to 'es' and this work correctly, I send a case for review the bug.

I think that nprinting has a problem with the '-' character, this character is present in the locale string and the machine name

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

Ruggero_Piccoli — Wed, 14 Mar 2018 14:07:10 GMT

Thanks for your test, it confirms that it is better to deeper investigate.

BR,

Ruggero

Re: How to use Qlik NPrinting APIs inside a Qlik Sense load script

pokassov — Wed, 30 May 2018 09:53:58 GMT

Hi Gianluca,

Great job!

Does Rest API have a row limit?

I connected to NPrinting and load the list of apps using your example.

I've got only 50 rows.

Meanwhile, I have 63 apps.

The same is true for tasks, connections, etc.

Do you know how to extract all the rows?

Best regards,

Sergey