Im fairly new in Power bi. I worked through lot of different sugestions how to et data in from painated api, but i still can't figure it out what is the problem.
Here is code to get next page.
let
Source = Json.Document(Web.Contents("https://xxxxxxxxxxxx?page[size]=2000&page[number]=1", [Headers=[Authorization="Bearer "&Gettoken()]])),
links = Source[links],
next = links[next]
in
next
Here is code to get data from 10 pages.
let
iterations = 10, // Number of iterations
url = "https://xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
FnGetOnePage =
(url) as record =>
let
Source = Json.Document(Web.Contents(url),[Headers=[Authorization="Bearer "&Gettoken()]]),
data = try Source[data] otherwise null,
next = try Source[links] [next] otherwise null,
res = [Data=data, Next=next]
in
res,
GeneratedList =
List.Generate(
()=>[i=0, res = FnGetOnePage(url)],
each [i]<iterations and [res][Data]<>null,
each [i=[i]+1, res = FnGetOnePage([res][Next])],
each [res][Data])
in
GeneratedList
Can someone point me into right direction. Thank you for advance 🙂
