Forum Discussion
pagination problem import
Hi, im trying to import register form 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
ThanK you for your posts, I finally find a solution using a function with Loop and calling the function again!!
3 Replies
Please see this video for a simpler way to apporach this.
Power BI - Tales From The Front - REST APIs - YouTube
Pat
Thank you for your reply Pat,
The problem is that with the API of my url i don.t get the pagination information. 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. (If you have a code that i could use as an exemple it woul be very worht for me)
Thank you in advanced,
Ignacio
ThanK you for your posts, I finally find a solution using a function with Loop and calling the function again!!
