Iterative API download not ending after end condition met.

Question

The iterative macro below pulls data down from Coupa's API until the payload back from Coupa is empty "= [] " I have tested this conditional outside of the macro and it works, but when I run in the macro it doesn't exit until the max iterations is hit. Attached the macro below.

* attached does have my api access token, but is just for the test site, and also for good measure I changed shortly after posting this (before someone tells me its bad practice to post that).

Would really appreciate a second set of eyes, thanks!

Coupa_API_Loop.yxmc

Felipe_Ribeir0 · Answer

@mathias149  Your iterations wont stop until you have this on your iteration loop.

It seems that your current workflow continue to provide the URL`s even after the last available data.

mathias149 · Answer

@Felipe_Ribeir0 thanks sir. I'll give that a shot. I like to understand what I am doing wrong, can you help me understand why my approach didn't work, Still not quite understanding that bit.

Felipe_Ribeir0 · Answer

@mathias149

Ok, so if you replicate this idea it will work

1-When download data is null, [] or what it is after the last iteration, fiter it

2-Append this table with null rows (and sample = 1) to the next page parameter (so it wont exist)