1 Reply Latest reply: Dec 29, 2017 4:46 AM by omar bensalem RSS

    Skip and Take dynamic from JSON load

    Paul Damen

      All,

       

      I have a JSON load from AFAS which I use the Qlik Sense rest connector for. Problem I face is that I can't get the whole pagination to work. I have a Skip and Take in the load which gets the value 0 and 100 from the source.

       

      What I need is to make this skip dynamic. So 0 in the first load, and then add 1000 for example in a loop. How can I get this to work? Not real familiar with this JSON type of scripting.

       

      Regards, Paul

       

      Let total = 0;

      Let totalfetched = 0;
      Let startAt = 0;
      Let pageSize = 100;

       

      for startAt = 0 to total step pageSize


      RestConnectorMasterTable:
      SQL SELECT
      "skip",
      "take",
      "__KEY_root",
      (SELECT ....

      .....

      ......

      .....

      .....

      FROM URL.....