Adjust List.Generate Code to limit Loop

[PowerUser123]

I have the below code:

    Pages = List.Generate(() => 
            CallAPI(endpoint, "1"),
            each HasContToken(Value.Metadata(_)),
            each try CallAPI(
                        endpoint, 
                        Text.Split(Text.Split(Value.Metadata(_)[next_page], "?page="){1}, "&"){0}
                    ) 
            otherwise null
        ),

I know the condition step is checking if certain metadata exists. That works well for my final query. But for testing purposes, I don't want it to loop until the check for metadata returns false. I just want it to loop say x amount of times and then finish. 

I tried changing the condition to each _ <10 but it just spins at evaluating when executing.

[OwenAuger]

Hi there,

Try something along these lines:

Pages = List.Generate(
	() => [APIResult = CallAPI(endpoint, "1"), Counter = 1],
	each [Counter] < 10,
	each
	  [
		APIResult =
		  try CallAPI(
			endpoint, 
			Text.Split(Text.Split(Value.Metadata([APIResult])[next_page], "?page="){1}, "&"){0}
		  )
		  otherwise null,
		Counter = [Counter] + 1
	  ],
	each [APIResult]
  ),

• The basic idea is to change the "initial" & "next" arguments so that they return records containing two fields, APIResult and Counter.
• In the "condition" argument, [Counter] can then be referenced as a field.
• In the "next" argument
  • [Counter] is also referenced in order to increment it.
  • The reference to _ is changed to [APIResult] since we just want that field.
• You then add a 4th "selector" argument to List.Generate which selects [APIResult] as the value to actually return as an item of the list.

Hopefully the above works and I haven't made syntax errors!

Regards,

Owen