How to iterate page count for json

[gopichilla]

Hi All, I have JSON web links(1-15 pages) like https://company.teamwork.com/comments.json?page=1 https://company.teamwork.com/comments.json?page=2 . . . . In Furthermore, data will add on that time adding one more JSON file into my Power BI desktop. I don't want like that it will update automatically is there any presses or not. Thanks, Gopi

[gopichilla]

let
    Query1 = let
    Source = 
        List.Generate(
            ()=>Text.From([page=0]),
            each Text.From([page])<10000,
            each Text.From([page])=Text.From([page])+1000,
            each Json.Document(Web.Contents("https://company.teamwork.com/comments.json/rest/v10/Opportunities?OAuth-Token=2342423&max_num=1000&page="& Text.From([page])))
        ),
Page = Function.InvokeAfter(()=>GetPage(Accounts_List_To_Query), #duration(0,0,0, Delay))
  
in
    

I am using this code.

[ewmartinez]

@gopichilla  any explanation for your solution? I don't understand what did you do