Forum Discussion

IADRIANS's avatar
IADRIANS
New Member
5 years ago
Solved

pagination problem with Quaderno import

Hi, im trying to import register from an url with the API authorisation and I just can import the first 100 register. Im using a list of page and then a function that call this list in order to impor...
Need Help
  • IADRIANS's avatar
    IADRIANS
    5 years ago

    Thanks to all!! I've already find a solution using a function with "Loop" and calling the function again!!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

You can use List.Generate  (for example) to not only fetch the records but then also do math on them (like identifying the oldest record), and can then feed that back into the next cycle.

 

 

  • IADRIANS's avatar
    IADRIANS
    New Member
    5 years ago

    Hi Ibendlin,

     

    Thank you for your reply. Could you be so kind to send me a exemple with a code? Im not high skilled with Query M and is dificult to me to understand how to use the value of a record in the next cycle.

     

    As i posted before a need to import the records form my url. I have a limit of 100 records by query. So I had to use the lower value of the "Id" field to recuperate the next 100 records. I would like to limite the querys to 50 (for instances) in ordert to not importing a huges amount of records (just 100x50).

     

    I will appreciate a lot your help.

     

    Thank you in advanced,

    Ignacio