Pagination of a REST API in Power Query using M

[Abi224]

Good Evening All,

Hoping experts can help as I'm well and truly stuck. I've successfully connected to a REST API using the below code:

let
    Source = Json.Document(Web.Contents("https://api.lm########.com/service/feedback?page=1&limit=1000")), 
    data = Source[data],
    #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
   
in
    #"Converted to Table"   

 The link  https://api.lm########.com/service/feedback?page=1&limit=1000   having more than 150 pages, and everyday new pages are keep adding , But i want to refresh only first 5 pages and remaining pages need to disabled loading. I don't want to load the historical pages only first 5 page need to load every time.

[goreavin]

@Abi224 : Looks like "page=1&limit=1000" is the code you need to tweak. Is there any way to get the total number of pages from the Rest API? You can use tools like Insomnia to debug. If you get the total number of pages, you can store the page count for the last query in a table and change the above code like:
"page=LastMaxPageCount&limit=NewMaxPageCount
Hope this helps