Dear Qlik NPrinting experts,

My goal with this post is to know how to get the user id created by the Qlik NPrinting POST Users REST API method inside a Qlik Sense load script.

Environment:

Qlik Sense: May 2023 SR4

Qlik NPrinting: May 2023 SR1

I followed the instructions documented in the How to use Qlik NPrinting APIs inside a Qlik Sense load script post created by @Gianluca_Perin and the user creation via Qlik Sense load script implementing Qlik NPrinting REST APIs worked perfectly well. Although my new user is created as expected, I need to know why I don't get the user id returned to my Qlik Sense script.

I followed the documentation above and the table remains empty after creating the user.

Here is my Qlik Sense script and the data connection configuration is also attached:

/*** lOGIN ***/
LIB CONNECT TO 'REST_NPrinting_GET';

//Perform a GET call to NPrinting NTLM login API
RestConnectorMasterTable:
SQL SELECT
  "Set-Cookie",
  "__KEY__response_header"
FROM JSON "_response_header" PK "__KEY__response_header";

[_response_header]:
LOAD
	[Set-Cookie] AS [Set-Cookie]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY__response_header]);

//Extracts session cookie from the API response
// let vCookieRaw = Peek('Set-Cookie',0,'_response_header');
// let vCookie = TextBetween('$(vCookieRaw)','Secure,','Path=/',2);

let vCookieRaw = Peek('Set-Cookie',0,'_response_header');
let vCookie = TextBetween('$(vCookieRaw)', 'SameSite=None,', 'Path=/', 3);


DROP TABLE RestConnectorMasterTable;

//----------------------------------------------------------------

/*** CREATE USER ***/
LIB CONNECT TO 'REST_NPrinting_POST';

set vBody = '{"Username":"UserA","Email":"usera@qlik.com","Password":"123","Enabled":"true","Folder":"","Subfolder":"","DomainAccount":"","Timezone":"Europe/Berlin","Locale":"en"}';
let vBody = replace(vBody,'"', chr(34)&chr(34));

set vPostUserULR = 'https://mynprintingserver:4993/api/v1/users';
set vQSServer = 'https://myqliksenseserver';


RestNPPOSTandPUTTestTable:
SQL SELECT
	"__KEY_data"
FROM JSON (wrap off) "data" PK "__KEY_data"
WITH CONNECTION( URL "$(vPostUserULR)", BODY "$(vBody)",
HTTPHEADER "Origin" "$(vQSServer)",
HTTPHEADER "Content-Type" "application/json",
HTTPHEADER "cookie" "$(vCookie)");

// [post_and_put_items]:
// LOAD [__KEY_data] AS [__KEY_data]
// RESIDENT RestNPPOSTandPUTTestTable
// WHERE NOT IsNull([__KEY_data]);

// DROP TABLE RestNPPOSTandPUTTestTable;

It would be really great if anyone could shed some light on this issue.

Thanks in advance.

Best regards,

Huberto Pereira Haidemann

Hello everyone,  

I have a problem with RangeSum, I want to hide the red line from June to December 2024, this part of the fold does not make any sense in the chart. How do I hide it? Thank you!

Additionally，Grey and black lines need to show data for 12 months of the year.

The measure used for the red line: RangeSum(Above(SUM({<Year={2024}>}QTY),0,RowNo()))

Hello all,

I am trying to regroup some date.

As you can see my original field is Activities_Cannib_Eventtime is in the format 'MM/DD/YY hh:mm:ss'.

I want to have one field for one date. Actually I am having several date with a different timeline for the same date.

How could I only take one date for each date ?

For example : I want to have only one time 7/29/2016 in the last column 

I already used distinct but didn't work [Distinct(date(Activities_Cannib_Eventtime)]

Hi all, 

I have 2 fileds: AccountID and Scope. Some Account does not have a Scope (null in scope) and I would like to find them. I can work only in Front End, so no load script can be used.

E.g.:

I managed to create a KPI that show how many Account with null scope I have, with the formula

count({1}distinct AccountID) - count({1<[Scope]-={"-"}>} distinct AccountID)

(note that the formula "count({1<[Scope]={"-"}>} distinct AccountID)" gives a wrong answer: always 0.

Now I would like to see WHAT are those AccountID.

I tried a table with the dimension column "AccountID" and the measure column "Count({<Scope-={"*"}>} AccountID)", but it doesn't work

Neither does the measure column "Only({<Scope={"-"}>}  AccountID)" (it gives only one one full-null row)

Neither "IF(Count({<Scope={"*"}>} AccountID))=0, AccountID)" (it gives only one one full-null row)

Thank you for your help

Hi all

How can I prevent users from modifying the order and width of columns in tables within Qlik Sense SaaS?

After deployment, certain users consistently rearrange columns in tables, leading to issues and support tickets when they can’t restore the original layout.

Is there a feature or setting in Qlik Sense SaaS that can restrict users from modifying column order and width to maintain consistent table layouts?

Thank you very much

Hi, I would like to calculate rolling sum like in the table below. Data should be grouped by column "Family". For each quarter I want to take a look at current quarter and 2 quarters backwards. Any idea how to achieve this in script editor? I am not interested in set analysis using rangesum - above combination. Column "Quarter" comes from fiscal master calendar.

Thank you.

Hello Experts

Our customer has upgraded v2022.05 to v2023.11 and encountered the problem below:

In 2022.05, when the following warning occurred, CDC task continued without any errors.

[TARGET_LOAD ]I: Load finished for table 'ADM'.'XXXXX' (Id = 1). 85627944 rows received. 0 rows skipped. Volume transferred 98611582288. (streamcomponent.c:3976)
[TARGET_LOAD ]I: TPT statistics for table 'REP.YYYYY': Operator=LOAD, CPU time=1115.296875, Received Rows=85627944, Sent Rows=85627944, Applied Rows=85627917 (teradata_tpt_engine.cpp:778)
[TARGET_LOAD ]W: Not all rows have been loaded successfully for 'REP'.'YYYYY' due to possible 'TPT LOAD' errors. Consult Target 'xxxx_E?' / 'xxxx_L?' Error / Log tables contents. (teradata_tpt_engine.cpp:786)
[TARGET_LOAD ]I: teradata_terminate_tpt(...) successfully applied conn->Terminate() method for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_tpt_engine.cpp:839)
[TASK_MANAGER ]I: Loading finished for table 'ADM'.'XXXXX' (Id = 1) by subtask 1. 85627944 records transferred. (replicationtask.c:3012)
[TARGET_LOAD ]I: teradata_stop_imp(...) stopping task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:857)
[TARGET_LOAD ]I: teradata_free(...) freeing resources for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:878)
[TARGET_LOAD ]I: teradata_disconnect(...) disconnecting for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:92)
[TARGET_LOAD ]I: teradata_disconnect(...) disconnecting Data Connection succeeded for task identified by '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:104)
[TARGET_LOAD ]I: teradata_disconnect(...) No active Lookup Connection to disconnect from was detected for task identified by '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_endpoint_imp.c:122)
[TASK_MANAGER ]I: Subtask #1 ended (replicationtask_util.c:591)

However the behavior has changed after upgrading to v2023.11.
After the same warning occurred, it is detected as an error and the table is suspended.

[TARGET_LOAD ]I: Load finished for table 'ADM'.'XXXXX' (Id = 1). 85986652 rows received. 0 rows skipped. Volume transferred 99014228864. (streamcomponent.c:4076)
[TARGET_LOAD ]I: TPT statistics for table 'REP.YYYYY': Operator=LOAD, CPU time=1126.937500, Received Rows=85986652, Sent Rows=85986652, Applied Rows=85986625 (teradata_tpt_engine.cpp:781)
[TARGET_LOAD ]W: Not all rows have been loaded successfully for 'REP'.'YYYYY' due to possible 'TPT LOAD' errors. Consult Target 'xxxx_E?' / 'xxxx_L?' Error / Log tables contents. (teradata_tpt_engine.cpp:789)
[TARGET_LOAD ]I: teradata_terminate_tpt(...) successfully applied conn->Terminate() method for task identified by UUID '74a9fd96-8335-5944-bb67-6aaa83fb3782' (teradata_tpt_engine.cpp:846)
[TARGET_LOAD ]E: TPT data acquisition failed [1020403] (teradata_endpoint_imp.c:1480)
[TARGET_LOAD ]E: Handling End of table 'REP'.'YYYYY' loading failed by subtask 1 thread 1 [1025000] (endpointshell.c:3069)
[TASK_MANAGER ]W: Table 'ADM'.'XXXXX' (subtask 1 thread 1) is suspended. TPT data acquisition failed; Handling End of table 'REP'.'YYYYY' loading failed by subtask 1 thread 1 (replicationtask.c:3208)

Is there any options to ignore the warnings/errors and continue the task like v2022.05?

Any advice would be appreciated.

Regards,
Kyoko Tajima