Need some help here with Excel Power Query with function LIst.Generate.
I need to call a rest endpoint recursively until no more data is fetched. The issue here is that total number of pages is unknown and there is no next page key available.
I did try List.Generate function based on other posts but did not succeed, as it was giving me N number of records as the exit condition was not getting satisfied. ( [Results] <> null ).
Would really appreciate if you could give me a sample LIst.Generate function with api call being used.
Note : Attached screenshot shows the results of calls being made to api. There are 3 records, First call fetch 2 records, second call fetches 1 record and the third call is empty.
Thanks in advance.