REST Connections

gajananpu27 — Wed, 19 Oct 2022 16:06:00 GMT

Hi All

I have REST Connection from ServiceNow (SN) to Qlik Sense. The source table on SN has got only 10K rows. however when I am loading data in qlik it is taking more than 30 minutes. I have setup all pagination information to load 5K instance at a time. Also one more thing the JASON script created to load data is taking creating cross table with every field I am trying to load from data.

Example :

I have EMP table in SN with 10K records with 10 fields:

When jason script is created in QS, it has got 10 select statement. like

RestConnectorMasterTable:
SQL SELECT
"__KEY_result",
(SELECT
"display_value",
"value",
"__FK_u_EMPID"
FROM "u_EMPID" FK "__FK_EMPID"),

Similarly, 10 selects statements are created to load data. This is creating cross joins and impacting the load. so wanted to know is there any way to reduce load time.

Re: REST Connections

J_Lindberg — Thu, 20 Oct 2022 14:32:15 GMT

Hello there,
This question seems to be unrelated to Qlik Application Automations. Could you please post your question again in the Connectivity & Data Prep forum (https://community.qlik.com/t5/Connectivity-Data-Prep/bd-p/qlik-sense-data-connectivity)?

topic Re: REST Connections in Qlik Automate

REST Connections

Re: REST Connections