Stop List.Generate when API return null

[Dagobert]

Hi,

I have a List.Generate that returns list rows of 1000 records from a API call. At this moment there is 22082 records in the source table and I want the list generation to stop when all records are received. In this case there should be 23 rows, with only 82 records in the last row. When harcoding it to stop after 24000 records I get a row with null. How can I make this loop to stop when the row is null?

[OwenAuger · Accepted solution]

Hi @Dagobert 

On line 4, change

each [cursor_position] <= 24000

to

each [WO_list] <> null

This is the loop-continuation condition for List.Generate.

Does this work at your end?

[Dagobert]

Yes, it works fine, so easy!

Thanks a lot