Forum Discussion
Need help with iterating through API response pages
Hello, I have been trying to find a solution for the past week now and still struggling. I have an access to an API of our CRM system. The api response comes with total number of records per e...
Have you already tried adapting this function like this?
GetPage = (Index) =>
let Url = BaseUrl & "?Page=" & Number.ToText(Index),
Json = GetJson(Url),
Value = Json[#"results"]
in Value,
I also don't understand your List.Max line, but if it works, great.
Pat
List.Max is not doing anything as EntitiesPerPage is a constant, so it will always return that. Maybe in some other scenarios it would be useful, akin to COALESCE.