7 Replies Latest reply: Nov 8, 2017 9:56 AM by Jan-Hendrik Esterhuyse RSS

    Qlikview - creating a loop for an API call

    Twan Peters

      I'm trying to create a loop for an API Call to Eloqua and i can use some help for this.

       

      The Eloqua Rest API returns 1000 records per page.

       

      The URL looks like below for the first 1000 records:

      https://secure.p01.eloqua.com/api/REST/2.0/data/contacts?count=1000&page=1

       

      In case there are more than 1000 records that you want to extract, you need to change the page number:

      The below URL will return 1001-2000 records

      https://secure.p01.eloqua.com/api/REST/2.0/data/contacts?count=1000&page=2

       

      However, you don't know how many pages there are, hence, the API call needs to stop when the API call doesn't return any records.


      Therefore, for the API call i need to create a loop where the pagenumber is 'x', and the call needs to stop when the call returns with 0 records. Till then the API call need to extract data and place it in a table.

       

      I simply don't know how to write this, can someone help me with this?