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 import all the register and everything was working well. The problem is that now, the url has change its pagination method and does not use the parameter "page" anymore. Now it uses the parameter "created_before". So i need to indicate the "id" of the last register in order to know from wich register i have to continue my import. Another problem is that the url does not return the register ordered, so a have to know the lower value of th id in each query to use it as a parameter for the following query. Anybody who help me please? Thanks in advance

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

pagination problem with Quaderno import | Microsoft Fabric Community

lbendlin
Super 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
  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
v-kkf-msft
Community Support
5 years ago
Hi IADRIANS ,

Please see if this post is helpful:

How To Do Pagination In Power Query

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
IADRIANS
New Member
5 years ago
Thanks to all!! I've already find a solution using a function with "Loop" and calling the function again!!