cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IADRIANS
New Member

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 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

1 ACCEPTED SOLUTION
IADRIANS
New Member

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

View solution in original post

4 REPLIES 4
IADRIANS
New Member

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

View solution in original post

v-kkf-msft
Community Support
Community Support

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
Super User
Super User

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.

 

 

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.