Connectivity & Data Prep

[Devel82]

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;

[Anil_Babu_Samineni]

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

[Devel82]

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.

G.