Forum Discussion
List.Generate - Connect to REST API without Total Number of Pages and Total Number of Entries
I got it... i got it... i'm sooooooo happy.
= List.Generate(
() => [PAGE = 1, RESULTS = GetPageClientes("1")],
each Table.RowCount(Table.SelectRows([RESULTS], each [count]>0)) >0,
each [PAGE = [PAGE] + 1, RESULTS = GetPageClientes(Number.ToText([PAGE] + 1))],
each [RESULTS])My research was that:
https://www.dalesandro.net/handling-paginated-rest-api-results-with-power-query/
https://www.thebiccountant.com/2020/05/15/miss-last-page-paging-power-bi-power-query/
https://www.youtube.com/watch?v=05yhwnuCjRw
https://www.youtube.com/watch?v=IASH1Fr16HY
hello everyone,
I get partial success now. I can list 7 pages, but I know that there is a 8 one.
Probably, the solution is on the line 4... if someone could suggest anything, I will appreciate.
Tks in advance,
--
Alexandre.