Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
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 (3)
2 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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.