Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Devel82
Contributor
Contributor

Data load Editor "SELECT block" limit

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;

Labels (1)
2 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Devel82
Contributor
Contributor
Author

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.