API Call

[Anonymous]

Hi! I need help with an API Call

Here's the code:

= List.Generate(()=>
[Result = try fRetrieveRatings(1) otherwise null, Page = 1],
each [Result][next_page]<>null,
each [Result = try fRetrieveRatings([Page]+1) otherwise null, Page = [Page]+ 1],
each [Result])

 I'm able to get all the information except the last page. Here you have the API answer to call 1:

satisfaction_ratings = List

nextpage = https://domain.com/api/json?page=2

previous_page = null

The problem is in the first each, but i dont know how to iterate once more to get the last page.

Thank you!

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Stopping-when-looping-through-a-paginated-API-feed/m-p/310382#M137477