Forum Discussion
How to iterate page count for json
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
2 Replies
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)) inI am using this code.
gopichilla any explanation for your solution? I don't understand what did you do
