Forum Discussion
gopichilla
Resolver III
9 years agoHow 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 a...
gopichilla
Resolver III
9 years agolet
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
3 years agoNew Member
gopichilla any explanation for your solution? I don't understand what did you do