topic Re: how to call Npriting ondemand requests via qliksense load script in Qlik NPrinting

how to call Npriting ondemand requests via qliksense load script

vimalthehero — Fri, 11 Apr 2025 13:25:19 GMT

i see several blogs to call nprinting tasks using qliksnese load script via rest apis.

can we call OnDemand nprinting requests via qliksense load scripts too.. for applying some dynamic filters in nprinting..??

Re: how to call Npriting ondemand requests via qliksense load script

mpc — Fri, 11 Apr 2025 13:54:07 GMT

Hi,

You can use the Qlik REST Connector, and use this endpoint: Qlik NPrinting API − post /ondemand/requests | Qlik NPrinting Help

Best

Re: how to call Npriting ondemand requests via qliksense load script

Lech_Miszkiewicz — Fri, 11 Apr 2025 14:27:12 GMT

hi @vimalthehero

Personally I dont think those end points will work given that they work very differently. The API endpoints we normally use within load script are for actions which are triggered and dont require interactive interface.

I dont think content types from https://help.qlik.com/en-US/nprinting/February2024/APIs/NP+API/index.html?page=45 will be supported in load script.

cheers

Re: how to call Npriting ondemand requests via qliksense load script

vimalthehero — Fri, 11 Apr 2025 15:34:25 GMT

do you have any sample code to refer calling those ondemand apis in Qlik sense load scripts??

Re: how to call Npriting ondemand requests via qliksense load script

Lech_Miszkiewicz — Sat, 12 Apr 2025 01:42:27 GMT

Hi @vimalthehero - that is question to @mpc as he said you could use it in load script.

I personally see no reason using this OnDemand Api in load script. Everything you need can be achieved using other APIs (Filter & task Api) which we know works in Load script and to apply dynamic filters (whatever you mean by that).

It just look like you are overcomplicating things which can be simpler just by using different solution you have not thought of yet maybe?

Maybe you could share scenario so we could try replicate and suggest you maybe different solution which would give you the same end result.
cheers

Re: how to call Npriting ondemand requests via qliksense load script

vimalthehero — Sun, 13 Apr 2025 07:12:26 GMT

Users will request reports via a Teams chatbox. These requests will trigger an automated process in Qlik Sense to generate the reports based on their specified filters. The generated reports will then be stored in SharePoint for users to access at any time, and they will receive an email notification upon completion.

Note: user wont have access to Qlik Nprinting ondemand report genration directly..!

all users requests will be procces via qliksense load script..

Re: how to call Npriting ondemand requests via qliksense load script

Lech_Miszkiewicz — Mon, 14 Apr 2025 08:40:41 GMT

Hi @vimalthehero

Have you considered that for some things you mentioned there are no existing solutions and you will have to build your own piece of soft to support it?

I see lots of issues with your initial proposal:

how were you planning to put reports on sharepoint - there is no API on NPrinting side doing this?
how were you planning to download reports created via OnDemand so they could be put on sharepoint? You may be able to get reports stored by regular tasks in folders but not via OnDemand tasks!
how were you thinking about putting filters in Qlik Sense script given that there may be multiple people trying to run the same thing at the same time you will have performance bottleneck!
Why are you planning to use Qlik Sense script for solution which can only do 1/4 of the job in load script? It can potentially trigger reports and pass parameters but at the same time you have think about performance issues this will create and potential concurrency which will not necesarilly work?

Your process looks cool but I cannot see it as a reliable solution as all steps have equivalent in real world but they were designed to work differently.

I may play with API to see if I could trigger simple OnDemand task - but I will do that in my free time as I would have to decipher how requests have to be built and understand how whole process works from API side.

I dont have much more constructive comment at the moment - sorry.

Re: how to call Npriting ondemand requests via qliksense load script

vimalthehero — Tue, 15 Apr 2025 00:04:57 GMT

I appreciate your feedback. The following are some of the approaches I plan to implement in response.

how were you planning to put reports on sharepoint - there is no API on NPrinting side doing this?
- Nprinting report which we will be geernating will be less than 10 MB and these report will be send to admin email id once it generated.. once the email are send to email id, we will execute power automate task which will store it in sharepoint. ( powerautomate will take care all reports storing tasks to sharepoint.
how were you planning to download reports created via OnDemand so they could be put on sharepoint? You may be able to get reports stored by regular tasks in folders but not via OnDemand tasks!
- we run all the npringting request as a pre defined Qlik task interval. one by one,, que system.. user will be notigfied only when thoser files are stored in sharepoint folders via powerautomate..! Note: ondeamnd tasks can be set emails once report is genrated too.
how were you thinking about putting filters in Qlik Sense script given that there may be multiple people trying to run the same thing at the same time you will have performance bottleneck!
- Qlik script is written in suah a way that all users filter and request will runn one by one ( que mechanism) and all users filters and request will be intially stored in a excel files which they request via team( chatbox). we procces thse requests one byone.. and keep unique request id to handle multiple user request and this reuest id will be used thorugh the report gnenrations till storing it to sharepoint..! Note: we are not smal team , where team isze is about 25 and user request is few in a day.. this service will be for those who doesnt have time to investigate in Qliksnese repot, but a final report (XLSX) on their request would be enough.. and they can wait till 3 hrosu to get it..!
Why are you planning to use Qlik Sense script for solution which can only do 1/4 of the job in load script? It can potentially trigger reports and pass parameters but at the same time you have think about performance issues this will create and potential concurrency which will not necesarilly work?
- we hae severla user who doesnt know how to effiecently use the Qliksense report as its very compleicated data, but they are ok to get a final report as per the basic filter applied..! since the user bse is less and request will be less .. we thought this approach to help users..! we will keep in mind about the perofrmance issue whie in theimplementation.. currently, i see Qliksense cloud is far better than any data analtics tool.. when it comes to generate report or loading the reports ...

Currently im trying to figure out the nprinting api call in Qliksense load script, which will be a parent report to run all the nprinting user requests..and figuring out the task exectuign api call

Re: how to call Npriting ondemand requests via qliksense load script

Lech_Miszkiewicz — Tue, 15 Apr 2025 03:03:50 GMT

Hi @vimalthehero

This is why I have issue with this approach. Many assumptions you were taking are not simple or possible.

OnDemand generated report are not sent via email hence you will not be able to use it! That obviously changes whole concept as in such case OnDemand API will not work in your framework as it is not designed to achieve your first step!
With that in mind your idea of using OnDemand API has to be dropped as obviously you will not be able to go through the first step.
Given that you cannot use OnDemand you need to take different approach by use of standard tasks - as only those can send emails or store reports to certain locations
1. Challenges are
  1. you will not be able to easily pass dynamic filters!
    1. Alternatives are:
      1. With each request update a filter and run task job
      2. or gather all filters and create dummy users import and run tasks to those dummy users
I have written comprehensive library of subroutines which can be used for this task: https://nprintingadventures.com/2019/04/08/nprinting-api-qlik-rest-subroutines/ all details how to use it are in the links inside that post. This is super simple and can be setup in just few minutes. My subroutines cover majority of the API calls such as Authentication, Users and Task as well as Task executions.
I recognize that my Subroutines dont have Filter Update API as I saw it irrelevant at the time given that much simpler and a lot more reliable solution is to use recipient import file with filters update to do the same: https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm#anchor-2

Given the responses I am getting in this chat I am not sure you are aware how much consideration you need to take to each of the questions I previously asked as your answers were not taking into account limitations of the existing API and some of the things you are saying you are going to do are just impossible.

I am also providing comments under your comments in next response to your comment.

cheers

Re: how to call Npriting ondemand requests via qliksense load script

Lech_Miszkiewicz — Tue, 15 Apr 2025 03:24:37 GMT

how were you planning to put reports on sharepoint - there is no API on NPrinting side doing this?
- Nprinting report which we will be geernating will be less than 10 MB and these report will be send to admin email id once it generated.. once the email are send to email id, we will execute power automate task which will store it in sharepoint. ( powerautomate will take care all reports storing tasks to sharepoint.
  - Sending email is only available via regular Publish Task. To achieve dynamic filtering you will need to update either NPritning user filters assigned to task or report/task filter before each time you trigger report. That can be very unreliable as fitlers must be created properly considering integrity of data model and data types such as (text, asci, date, intiger, timestamp, dual (!!!), and using appriopriet filtering method: https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-5
how were you planning to download reports created via OnDemand so they could be put on sharepoint? You may be able to get reports stored by regular tasks in folders but not via OnDemand tasks!
- we run all the npringting request as a pre defined Qlik task interval. one by one,, que system.. user will be notigfied only when thoser files are stored in sharepoint folders via powerautomate..! Note: ondeamnd tasks can be set emails once report is genrated too.
  - NPrinting OnDemand requests cannot sent emails!!! Show me documentation which says otheriwise. Only regular publish tasks can send emails but those rely on NPrinting created filters!!!
how were you thinking about putting filters in Qlik Sense script given that there may be multiple people trying to run the same thing at the same time you will have performance bottleneck!
- Qlik script is written in suah a way that all users filter and request will runn one by one ( que mechanism) and all users filters and request will be intially stored in a excel files which they request via team( chatbox). we procces thse requests one byone.. and keep unique request id to handle multiple user request and this reuest id will be used thorugh the report gnenrations till storing it to sharepoint..! Note: we are not smal team , where team isze is about 25 and user request is few in a day.. this service will be for those who doesnt have time to investigate in Qliksnese repot, but a final report (XLSX) on their request would be enough.. and they can wait till 3 hrosu to get it..!
  - If youa re creating requests and filters as excel files you may just use recipient import file to create those as part of the job: https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm
Why are you planning to use Qlik Sense script for solution which can only do 1/4 of the job in load script? It can potentially trigger reports and pass parameters but at the same time you have think about performance issues this will create and potential concurrency which will not necesarilly work?
- we hae severla user who doesnt know how to effiecently use the Qliksense report as its very compleicated data, but they are ok to get a final report as per the basic filter applied..! since the user bse is less and request will be less .. we thought this approach to help users..! we will keep in mind about the perofrmance issue whie in theimplementation.. currently, i see Qliksense cloud is far better than any data analtics tool.. when it comes to generate report or loading the reports ...
  - I very much disagree - for those users you could actually create sheet with filters they need to apply to generate proper OnDemand NPrinting report. It could be as simple as 1 sheet with filters they shoudl use and OnDemand button apearing conditionally once required filters are applied. If it is not complicated for them to request such report via teams why woudl it be more complicated via dedicated interface?

cheers

Re: how to call Npriting ondemand requests via qliksense load script

vimalthehero — Tue, 15 Apr 2025 04:39:55 GMT

thank you very much for the strong advices.. 🙂

yes, you are right, ondemand dunctionality cant send email, maybe i confused with the normal published report which has OnDemand report enabled.. can still send email report according to the filter user submits while calling the api.

then only option is to provide users to have nprinting ondemand button, where they select what they want and create the reprot their own from ondemand button...

sometims while providing the btton to users, we seee , users complains they camt generate reports, as they might need to login npringing before pressing ondemand button... sometime we endup support similar issues to explain user how to download..

let m econtact the internal IT support on how to get rid of this issue.. or any suggestion on it also welcome 🙂

i see Qlik forum support is very good compared to the internal IT support

Re: how to call Npriting ondemand requests via qliksense load script

Lech_Miszkiewicz — Tue, 15 Apr 2025 05:39:43 GMT

Hi @vimalthehero

When you say: "sometims while providing the btton to users, we seee , users complains they camt generate reports, as they might need to login npringing before pressing ondemand button..." That indicates to me potential issues:

User may not be created in NPriting with required role - as you know eweryone who triggers NPrinting OnDemand report needs to have NPrinting user assigned with the Domain account same as the one they use when accessing Qlik Sense
SSL certificate is not using FQDN (fully quilified domain name) and is not properly configured. I always suggest use of 3rd party trusted certificates
GPC is not configured to ALWAYS prompt users for username and password
NPrinting FQDN and Qlik Sense are not added as trusted sites/Internal sites in GPC

For properly working OnDemand Button with Qlik Sense and NPrinting you must ensure all requirements and setings are met: https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/On-Demand/Create-Report-On-Demand-QS.htm

There are also youtube Qlik support videos explaining this issue well:https://www.youtube.com/watch?v=eHVBVoLy16Y

Troubleshooting those issues does not take much time and if company policies are well maintained there should be no issue with this feature.

cheers

Re: how to call Npriting ondemand requests via qliksense load script

vimalthehero — Tue, 15 Apr 2025 08:11:05 GMT

Acknowledged, thank you for the inputs. I will forward our user issues/troubles and recommendations solutions to IT team realted to the ondeamnd button functionality. We will prioritize fixing the on-demand user button issue instead of taking complicated approaches.

Thank you very much 🙂

Re: how to call Npriting ondemand requests via qliksense load script

mpc — Wed, 21 May 2025 07:39:30 GMT

Hi,

I think I was a little bit tired when I've wrote my answer 😫

Best

Re: how to call Npriting ondemand requests via qliksense load script

vimalthehero — Thu, 29 May 2025 15:29:41 GMT

LIB CONNECT TO 'Nprinting_POST_RESTAPI';

RestNPTaskTriggerTable:
SQL SELECT
"__KEY_data"
FROM JSON (wrap off) "data" PK "__KEY_data"
WITH CONNECTION( URL "https://nprinting.domain.net:4993/api/v1/tasks/TASKID/executions", // update the url properly
HTTPHEADER "Origin" "https://qlik.Domain.net", // change the url as per the need
HTTPHEADER "Content-Type" "application/json",
HTTPHEADER "cookie" "NPWEBCONSOLE_SESSION=eac41f91sdfsdfsdf95441032a7dfsa5f9b80-%00userlogin%dddf2315745Z%00%00NPWEBCONSOLE_XSRF-TOKEN%3AqFcbKdHEr3HtU%3D%00%00_TS%3Asession%00%00userid%3A05645673ad4d2%00; Path=/; HttpOnly; Secure; SameSite=None");

[_post_items]:
LOAD [__KEY_data] AS [__KEY_data]
RESIDENT RestNPTaskTriggerTable
WHERE NOT IsNull([__KEY_data]);
DROP TABLE RestNPTaskTriggerTable;

Re: how to call Npriting ondemand requests via qliksense load script

vimalthehero — Thu, 29 May 2025 15:38:03 GMT

and it possible to update the Nprinting filter dynamically via qlik script using nprinting apis too.... i have tried it it working fine..... so basically the things which i thought before works for me... now it up to me how to pass the user request from teams chat bot to qlik ... to run the things... i feel what i thought to achieve its possible to integrate and implement.. thank you for all the support and guidance..

Note: im not using Nprinting ondemand request, just normal Nprint task executon with dynamic filter setting via qlik script will be used 🙂

Re: how to call Npriting ondemand requests via qliksense load script

Lech_Miszkiewicz — Fri, 30 May 2025 13:43:18 GMT

good luck mate!