REST Connections

[gajananpu27]

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.  

[J_Lindberg]

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)?