topic Re: Nprinting REST API broke after June 2020 update in Qlik NPrinting

Nprinting REST API broke after June 2020 update

Carly_ — Mon, 22 Jun 2020 09:49:18 GMT

Goodmorning,

I have a failing script trying to call the Nprinting REST API after updating both Qlik and NPrinting to the June version. I also had this after the February update. The cookie is the problem in both cases. However, then I could easily change it by adjusting the TextBetween formula and now I cannot resolve the issue. Does anybody have an idea on how to change the cookie value so that the connection can be made again?

I cannot find anything in the release notes this time.

Re: Nprinting REST API broke after June 2020 update

Lech_Miszkiewicz — Mon, 22 Jun 2020 11:18:35 GMT

correct - it is a cookie. I personally could not test it yet, but I had someone posting this on my blog as a comment to this topic:

https://nprintingadventures.com/2020/03/27/nprinting-api-qlik-rest-subroutines-v1-2/

Let vCookie = TextBetween(‘$(vCookieRaw)’,’SameSite=None,’,’Path=/’,3);

Re: Nprinting REST API broke after June 2020 update

Carly_ — Mon, 22 Jun 2020 11:25:36 GMT

Hi Lech,

Thank you for your answer. However, I'm afraid this doesn't work as the second part of the cookie does not contain, samesite = none anymore. I've tried to exclude the first part based on NPWEBCONSOLE, but this doesn't work for me

NPWEBCONSOLE_XSRF-TOKEN=wXH0YB5fA/E/jIe1OiCFHBBjrQ0j6DFeBTC6TxVY3Zw=; Path=/; Secure; SameSite=None,NPWEBCONSOLE_SESSION=1419836eb7b7def93ed8abc4eb550b2c67ebe98b-%00userid%3A2fa9fdbf125c4289b5541e0d2ee04196%00%00userlogin%3A2020-06-22T11%3A23%3A35.6842749Z%00%00_TS%3Asession%00%00NPWEBCONSOLE_XSRF-TOKEN%3AwXH0YB5fA%2FE%2FjIe1OiCFHBBjrQ0j6DFeBTC6TxVY3Zw%3D%00; Path=/; HttpOnly; Secure; SameSite=None

Re: Nprinting REST API broke after June 2020 update

Lech_Miszkiewicz — Mon, 22 Jun 2020 11:39:21 GMT

Sorry - I hadn't test it yet.

I may have some answers tomorrow.

Cheers

Lech

Re: Nprinting REST API broke after June 2020 update

Carly_ — Mon, 22 Jun 2020 13:32:22 GMT

No problem, I have tried multiple things, but I notice the cookie I get from the field set-cookie is completely different from earlier cookies. It only consists of 2 parts and it includes a user login timestamp. No idea where this is coming from.

It would be great if you have anything that can be of help tomorrow

Re: Nprinting REST API broke after June 2020 update

Anubhavv — Mon, 22 Jun 2020 13:53:47 GMT

I also have the same issue and cannot figure out what to do. I am using April 2020 and the cookie i am getting is below

NPWEBCONSOLE_XSRF-TOKEN=gGWddTJJ7BPTZRNoGfFJ9vYmukd82U0unEUbvZbHULY=; Path=/,NPWEBCONSOLE_SESSION=e998a0652e2c0c148f19f8af93d617b3c599902c-%00NPWEBCONSOLE_XSRF-TOKEN%3AgGWddTJJ7BPTZRNoGfFJ9vYmukd82U0unEUbvZbHULY%3D%00%00_TS%3Asession%00; Path=/; HttpOnly

Not sure how to format it and use it further.!! Can someone shed some light?

Re: Nprinting REST API broke after June 2020 update

Lech_Miszkiewicz — Tue, 23 Jun 2020 09:43:29 GMT

For April 2020 use this approach: https://community.qlik.com/t5/Qlik-NPrinting-Documents/NPrinting-February-2020-Change-required-to-scripts-running-from/ta-p/1688353

https://nprintingadventures.com/2020/03/27/nprinting-api-qlik-rest-subroutines-v1-2/

For June 2020 you need to adjust highlighted part of code:

From:

//Extracts session cookie from the API response Let vCookieRaw = Peek('Set-Cookie',0,'cookie_items'); Let vCookie = TextBetween('$(vCookieRaw)','SameSite=None,','Path=/',2);

To This - note change in red: TextBetween('$(vCookieRaw)','SameSite=None,','Path=/',3):

//Extracts session cookie from the API response Let vCookieRaw = Peek('Set-Cookie',0,'cookie_items'); Let vCookie = TextBetween('$(vCookieRaw)','SameSite=None,','Path=/',3);

that works for me in June 2020

I will be adjusting my NPrinting.qvs soon and I will post about soon about it.

thanks

Lech

Re: Nprinting REST API broke after June 2020 update

eike_s — Tue, 23 Jun 2020 13:24:58 GMT

Thanks Lech, your solution works with the Sense April 2020 version. Or more precisely with the Rest Connector version 2.28.0, with Sense June 2020 comes a new version 2.34.0, with this version I could not successfully authenticate against NPrinting. A note from Qlik would be very helpful (@JonnyPoole ?, @Andrew_Kruger ?).

Re: Nprinting REST API broke after June 2020 update

Carly_ — Tue, 23 Jun 2020 13:55:15 GMT

Thank you for your proposal, but indeed it is unfortunately not the solution for the June 2020 version in my case.

Re: Nprinting REST API broke after June 2020 update

eike_s — Wed, 24 Jun 2020 12:17:26 GMT

As a workaround you can also exchange the RestConnector for the previous version and with the Lech customization it works again. The REST Connector is located in the directory C:\Program Files\Common Files\Qlik\Custom Data. I couldn't test if other components of Sense June2020 need the newer connector.

Re: Nprinting REST API broke after June 2020 update

Carly_ — Wed, 24 Jun 2020 14:08:31 GMT

That seems like a great solution, where can I find that previous version of the REST connector? In the downloads page from Qlik I can only find the QlikView versions.

Re: Nprinting REST API broke after June 2020 update

eike_s — Wed, 24 Jun 2020 16:17:45 GMT

I think Qlik would have to provide a separate link for this. I still had an April version on hand (see attachment, of course without warranty and without guarantee). Make a backup of the old folder first. Stop the engine, swap versions of the folders and restart the engine. As I said, this is all just a workaround.

Re: Nprinting REST API broke after June 2020 update

Carly_ — Mon, 29 Jun 2020 10:25:03 GMT

Thank you Eike, for now this was the solution. It works again, it is not perfect, but i'm glad it is resolved for now.

Re: Nprinting REST API broke after June 2020 update

Ruggero_Piccoli — Tue, 14 Jul 2020 08:14:30 GMT

Hi,

Please try to replace the code:

Let vCookie = TextBetween('$(vCookieRaw)','SameSite=None,','Path=/',2);

With:

Let vCookie = TextBetween(vCookieRaw,'SameSite=None,',' Path=/',SubStringCount(vCookieRaw,'SameSite=None')-1);

Best Regards,

Ruggero

Re: Nprinting REST API broke after June 2020 update

Fred — Tue, 28 Jul 2020 19:54:20 GMT

@Ruggero_Piccoli
Unfortunatley your code does not solve the issue (at least for QS June 2020 SR3 & NP June 2020 SR1).
There is some weird stuff going on with the cookies format and rest connector.

Replacing the rest connector with the april version still does the trick.

Are you guys already aware of this and/or investigating this? Otherwise I'll log a support ticket.

Thanks.

Re: Nprinting REST API broke after June 2020 update

Carly_ — Wed, 29 Jul 2020 06:28:57 GMT

@Fred It would be great if you could file a support ticket. The proposed resolution does not work and I still have the april version running, which does work well indeed.

Re: Nprinting REST API broke after June 2020 update

Ruggero_Piccoli — Wed, 29 Jul 2020 07:49:27 GMT

Hi,

We are already aware and working on this issue. If you want you can rise a support ticket, but it is not mandatory for this topic.

Thanks.

Best Regards,

Ruggero

Re: Nprinting REST API broke after June 2020 update

Qlik_Greg — Tue, 04 Aug 2020 16:01:54 GMT

Hi Ruggero.

Can you explain the issue succinctly? What works, what doesn't work here... and status on a resolution. We have upgraded to NPrinting June 2020 and planned to upgrade to QS June 2020 next week, but ran into, what I believe are, related issues to what is being discussed here in our QS Sandbox environment.

Re: Nprinting REST API broke after June 2020 update

micheledenardi — Fri, 07 Aug 2020 12:02:09 GMT

Hi Ruggero,

are there news on this topic?

i would avoid to replace RestConnector 2.34 (june 2020 patch 3) with previous versions...

The "set-cookie" returned has this structure:

NPWEBCONSOLE_XSRF-TOKEN=VR+Yk8FFNjcMg7gRSCQomIy2TkeAP380diD5JWVJZqg=; Path=/,NPWEBCONSOLE_SESSION=46f3820aa1ac24541d21efed2016cf10f9703126-%00NPWEBCONSOLE_XSRF-TOKEN%3AVR%2BYk8FFNjcMg7gRSCQomIy2TkeAP380diD5JWVJZqg%3D%00%00_TS%3Asession%00%00userid%3Abb9a2592bebd462abe70ed269837134a%00%00userlogin%3A2020-08-07T11%3A52%3A49.2135421Z%00; Path=/; HttpOnly

So no traces about "SameSite=None".

Re: Nprinting REST API broke after June 2020 update

ingoginqo — Fri, 14 Aug 2020 01:02:08 GMT

Hi Ruggero,

we have multiple customers/environments affected by this issue in the June 2020 REST Connector.

Can you provide a status update here, or do you want us to open more tickets on this issue?

Thank you,

Ingo.