pagination problem with Quaderno import

[IADRIANS]

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

[IADRIANS · Accepted solution]

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

[v-kkf-msft]

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.

[lbendlin]

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]

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