0

I want to do something as follows in Qlikview.

Need to call the API in the loop till the resp becomes empty array. Also need to append next value in the URL from the response.

TempTable:
Let next = '';
Let apiUrl = https://myapiurl;
do {
  resp = Calling my API (apiUrl + next);
  push resp.data to TempTable
  next = resp.next;
} (while resp.data.length > 0);

Target is I want a consolidate output of the API calls.

Suppose if we can't do it with TempTble, is there any other ways?

Gnik
  • 7,120
  • 20
  • 79
  • 129
  • are you using QV rest connector? – EldadT Jul 05 '19 at 08:12
  • Yes we are using rest connector – Gnik Jul 05 '19 at 09:35
  • have you watched this? https://www.youtube.com/watch?v=FqwNU_pnFt4&t=139s – EldadT Jul 05 '19 at 09:52
  • Hi EldadT, I watched this video just now. Already connected with API. My requirement is getting data based on some next link which contains key for next set of records and limit for pagination. That link will be available in each response to get next set of records – Gnik Jul 05 '19 at 10:21
  • In that video it show how to use that "next" link... – EldadT Jul 06 '19 at 15:01
  • Hi please check my answer here https://stackoverflow.com/a/54580152/10972959 it takes next link and call sub recursively again. Root table is dropped and data is auto-concatenated t new table – Hubert Dudek Jul 06 '19 at 23:24

0 Answers0