Forum Discussion
Solved
List Generate function to fetch multiple API pages not working
Hi, I have this function- the aim of which is to fetch multi-page results from an api: let
// Initial CandidateIDs List from Offers Query
CandidateIDsList = offers[candidate_id],
...
Pagination is usually used for results. You seem to be attempting to do pagination for the source criteria ( 50 candidate IDs per call) . Make the List.Generate return strings, then add a column that calls the API with the string, then combine the results.
Inline the
#"FNGet-candidates"function so that it is housed inside your query, same like the (unfortunately named) "Source" function at the top of your code.
