Using Chris Webbs now infamous blog post, I have been able to create an API loop that successfully pulls a loop of an API (Zendesk chat data) which has a 'next_page' field attributed to it.
The below is the code which works fine on desktop but doesn't work in the service. I have been able to do this whilst incorporating the [startepochtime] which is a seperate basic query giving me the correct start time of my call 3 months ago.
I have tried what feels like a thousand times to use relative path, query etc etc. but when do so it just incessently loops the same page over and over.
PLEASE help!
let
iterations = 10000, // Max Number of iterations
url = "https://www.zopim.com/api/v2/" & "incremental/" & "chats?fields=chats(*)" & "&start_time=" & Number.ToText( StartEpochTime ),
FnGetOnePage =
(url) as record =>
let
Source1 = Json.Document(Web.Contents(url, [Headers=[Authorization="Bearer MY TOKEN GOES HERE"]])),
data = try Source1[chats] otherwise null, //get the data of the first page
next = try Source1[next_page] otherwise null, // the script ask if there is another page*//*
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])
