Exactly what the title says. I've built a macro to pull in some data from an API we're using and it's working perfectly except for the fact that it continues to loop even after the iterative output hits 0 records.
In my testing container up there it's testing to see if the latest record being pulled has a date equal to the last record in an excel file it's reading from. If it isn't the same date it drops the date range by one day for the next API call and does it again until it reaches the last date. It works perfectly and when the date in the API call is equal to the date in the file nothing comes through on the false side of that first filter.
For some reason, however, when I plug it into my workflow it just continues to iterate up through my iteration limit. I'm assuming I'm missing something super obvious here. Can anyone chime in and save me from pounding my head against my desk for the rest of the day?
Solved! Go to Solution.
Solved, I guess. This only occurs if I have the "When Maximum Number of Iterations is Hit" option in the interface designer to "Error". If I change it to "Warn" then it doesn't keep on iterating.
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |