NPrinting API – Qlik Rest SubRoutines v1.2

Hi All,

This is just urgent update of NPrinting.qvs library to allow for its usage with NPrinting February 2020 SR1. This version of NPrinting returns from API response cookie with additional string which needs to be handled differently when creating vCookie variable. The below change is incorporated in library and requires one more parameter to work: vNPVersion variable. This is a variable which value you need to update accordingly to your version and it simply represents year-month-sr version. So for February 2020 SR1 you need to set it to 20200201, where meaning of digits is: 2020 – year, 02 – feb, 01 – SR1.

Below code is added in library to handle rest of it.

 
//  NPrinting version (this is to maintain one library and support for release changes)
//  version (as of now 27 Mar 2020 there is only change prior Feb 2020SR1 and after)
  
     Let vNPVersion    =   '20200201';    // Meaning of digits: 2020 - year, 02 - feb, 01 - SR1
     ...
     ...

// Cookie version
     If $(vNPVersion) < 20200201 Then
        Trace Loading cookie based on NPrinting version prior Feb 2020 SR1 release;
        Let vCookie 	= TextBetween('$(vCookieRaw)','Secure,','Path=/',2);
     Else
        Trace Loading cookie based on NPrinting version equal or post Feb 2020 SR1 release;
        Let vCookie 	= TextBetween('$(vCookieRaw)','SameSite=None,','Path=/',2);
     EndIf
     ;

cheers

Lech

9 Comments

  1. Lech, how could we amend the task call to just grab all executions? We were considering trying to use the NPrinting API to send Failed or warning task statuses to our Microsoft Teams alerts. We are using this for Qlik Sense and it works well.

    Like

    1. Hi Roostor,
      When you say “to just grab all executions” what do you mean? Do you want all executions ever done for all tasks, or something like get all Tasks in Admin console and the latest executions for all of them? What would be the final expected result? Something like 1 table with 3-4 columns like: App Name–>Task Name–> Last execution status-> Last updated?

      My Subroutines dont have scenario where you would get all information at once. Since you need to pass appid to get task ids and task ids to get execution details I assume It would be a nested loop like the dummy concept below

      For each vAppId
      Get Task Ids List
      For Each vTaskId
      Get ExecutionsIds
      For Each vExecutionId
      GetExecutionDetails
      Next
      Next
      Next

      My current code would need to be adjusted to allow you to do that.

      Like

  2. Hi Lech

    Great library! I hope this product gets more attention in the future.

    Is there a way to get a list of the single reports generated in one task? For now I think we dont get the reports that failed inside a task.
    If you have generated 100 reports it is very time consuming to check the failed ones in the Log section of the Task execution.
    Did you came across such an use case?

    Best regards
    Hatus

    Like

    1. Hi Hatus,
      Library is still work in progress, and there are improvements coming in filter creation section

      Regarding your question:
      API does not allow you to get single report execution details. It only allows you to get high level task execution details and as you know 1 task can actually contain 100s reports.

      So log section will still give you a lot more info and details than api.

      And no-the purpose of library was not monitoring but rather task and error handling

      Like

  3. Hello,
    with June 2020 relase I have to change it again
    Let vCookie = TextBetween(‘$(vCookieRaw)’,’SameSite=None,’,’Path=/’,3);

    Regards

    Like

    1. Hi Gianfranco, thanks for this information. At present I am not having a working environment running on June 2020, so I cannot comment on this. I will however work on that as soon as I can.

      Like

    1. Hi Gianfranco – Correct, this seems like rest connector issue. I am aware that Qlik is working on fix. At this stage there is nothing we can do other than wait for next patch/release, check release notes and see if something was changed in rest connector. I presume the earliest it will be in Sep 2020

      Like

Leave a Reply to roostor Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s