Hey All,
Is there a way to do an extremely simple "If row count = 100 Then, Else", and pass the workflow data through both ways? Adding a count to all rows, filtering them, then removing the column is the only way I can see to do this but from a programmatic standpoint seems extremely unnecessary.
More Info:
I have an interactive macro inside a batch macro. I'm using an API call to pull records from many databases (batch), but hit my API cap in some databases (iterative). Thankfully (sarcasm), my API's don't give me a "next", "count" or any way to know how if there is more data. The only thing I can do is download the max records for each call (100), iterate, and stop when I don't download 100.
I've discovered that a simple conditional row count and passing data is not a simple task. I can count/summarize, but I ALSO need to pass the URL/Auth data to the next iteration.
Not sure what to do...thanks!
Is there a way to do an extremely simple "If count = 100 Then, Else", and pass the data through both ways? Adding a count to all rows, filtering them, then removing the column is the only way I can see to do this but from a programmatic standpoint seems extremely unnecessary.
