Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.