topic Re: Data load Editor "SELECT block" limit in Connectivity & Data Prep

Data load Editor "SELECT block" limit

Devel82 — Mon, 13 Dec 2021 17:50:40 GMT

Hi,

I use rest connector to get data from web services.

I have some blocks like the one below. After 9th block, the loader ignore all the others. Is there a limit or I'm using a wrong way to get data?

Thank very much,

Giacomo

Events:
SQL SELECT
"success",
"info",
"__KEY_root",
(SELECT
"type",
"date",
"lat",
"long",
"__FK_events"
FROM "events" FK "__FK_events")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION (

URL "https://www.site.com/get_data.json",

HTTPHEADER "Authorization" "$(vToken)");

[events]:
LOAD [type],
[date],
[lat],
[long],
[__FK_events]
RESIDENT Events
WHERE NOT IsNull([__FK_events]);
DROP TABLE Events;

Re: Data load Editor "SELECT block" limit

Anil_Babu_Samineni — Fri, 25 Dec 2020 20:38:01 GMT

Please check both Qlik Sense connection and From Web services If there is any timeout?

Re: Data load Editor "SELECT block" limit

Devel82 — Tue, 05 Jan 2021 08:12:20 GMT

Hi,

there is no particular timeout neither in connection nor in we services.

It seems to be a problem about number of block. I have the same problem even I change position of blocks and put the biggest query as 10th block. It doesn't get executed.