topic Re: Retrieving data from a web file using a URL in QlikView

Retrieving data from a web file using a URL

nam — Tue, 14 Apr 2015 08:26:25 GMT

Hi im doing a simple loop which should increment the pages in a url and give me a resultant output concatenating the results of the loop.

if I change the page number 1 at a time I can see that there is a value for each page.

when I run the loop I can see it increments through the 10 pages, however the result is just 1 line for 1 page.

loop below:

for i=0 to 10

LET $(vPage) =$(i);

summaryTable:
LOAD total_rows,
index,
PageNumber,
summaryKey
FROM [http://test.test-api.com/testing/api/sometable.php?appid=testappid&token=someToken&page=$(vPage)]
(XmlSimple, Table is [sometable/summary]);

Next ;

am i doing something obviously wrong here?, any pointers will be welcome

Tue, 14 Apr 2015 09:13:26 GMT

looks fine, and as you say is iterating through the 10 pages. When you hardcoded in page1 did you return more than a single row?

Joe

nam — Tue, 14 Apr 2015 09:19:49 GMT

if I hard code page 1 I get 1 row with the page number showing page 1 and so on for the other pages.

the loop only returns the last page its almost like it does not append to the first 1-9 pages..

Tue, 14 Apr 2015 09:52:04 GMT

Ah right sorry, change

LET $(vPage) =$(i);
to LET vPage = $(i);

and give that a try, by expanding the variable like that, it's like you are saying

Let 1 = x

and not actually changing your vPage variable and looping the same page 10 times

Joe

nam — Tue, 14 Apr 2015 09:56:46 GMT

Joe Simmons

Spot on. I overlooked that

Tue, 14 Apr 2015 10:08:31 GMT

No worries let me know if that resolves the issue when you re-run

nam — Tue, 14 Apr 2015 10:37:28 GMT

That works perfect.

Tue, 14 Apr 2015 11:02:08 GMT

perfect, can you mark and close this one down then if possible, cheers