Iterative Macro: If result count = 100, Loop, else, output results

[PSmitty334]

Hey All,

I'm calling an API that doesn't give me "next" "count" or "page" results, all I can do is keep calling the max records until the count is less than the API cap, then I know I have all the data.

(Capture2.png) The workflow never stops, I get all of the data, but many many duplicates of the same record. (there are only 800 ish entries and the macro errored after 50 iterations).

Thanks!

[PSmitty334 · Accepted solution]

Apparently the System.IterationNumber was causing an infinite loop on the first few iterations, updating the existing $skip value via formula fixed the issue.