Cannot connect to NPrinting API with QvRestConnector 1.3

[blaise]

Hi fellow forum members

Im trying to fetch Users from NPrinting API using the Qv Rest Connector 1.3 from QlikView.

I've followed the guide How to use Qlik NPrinting APIs inside a Qlik Sense load script but for some reason it doesn't work.

I've successfully connected to the /login/ntlm endpoint and extracted the cookie but when i try the following script it doesn't work (QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 500 (Internal Server Error).

RestUserMasterTable:

SQL SELECT

"__KEY_data",

(SELECT

"id",

"email",

"__FK_items"

FROM "items" FK "__FK_items")

FROM JSON (wrap off) "data" PK "__KEY_data"

WITH CONNECTION( URL "https://fullservername:4993/api/v1/users", HTTPHEADER "cookie" "$(vCookie)" );

Im trying with a user with Administrator role in NP.

Port 4993 is open as i can use web console without any issues

Qv Rest Connector is of version 1.3 (i've installed it after Qlik Sense and have also tried to uninstall Qlik Sense before and install Qv Rest Connector afterwards)

I've tried both Nov17 and Feb18 releases.

I've added <ALL> logging to QvRestConnector but that didn't gave me any meaningful info.

The exact same qvw (except the servername in the url) is working on other NP Installations running both Nov17 and Feb18.

[blaise]

Yes, even though you dont explicity list the Locale field, the load fails.

[blaise]

no worries, didn't saw it until you mentioned it

[nicolett_yuri]

Thanks for the tip! Helped me a lot

[covering]

I'm using NPrinting June 2020. The bug is still there. If one user's locale is set to Chinese (with the NPrinting user interface) the API method users returns an HTTP 500 error (whatever client is used).

NPrinting log : ApiPagedResponse`1.Items.Items.Items9[9].Locale.Locale↓↓↓↓Source value:↓↓zh-CN ---> System.ArgumentException: Requested value 'zh-CN' was not found.