Skipping an iteration

[fardeen9983]

In my iterative macro I am running a download tool and parsing the result based on some filters. It incudes use of select tools to rename fields based on parsed json output. SO in case the filters return no data, the filter and select tools are raising errors that their are no such fields by that name

I tried the Count and Test tool to stop the workflow which stops the iteration and goes to the next one. But the catch is that it raises an error and so the final results is filled with Errors. What I want is for it to silently skip the iteration on count condition failing and continuing business as usual

[afv2688]

Hello @fardeen9983 ,

How about having a text input with the common headers and a row with only null values? You could union it to the output and select and filter it afterwards, therefore never having the error. Not really elegant but may solve the issue easy and fast.

Regards

[fardeen9983]

I dont think the output fields will be the same all the time. And it will be a pain to change the fields if the response changes. The json data can be different based on payload

[fardeen9983]

Okay so for the solution I have removed those filter and select tools that depended on the dynamic fields outside of the iterative macro. Now if there are no records are generated as a whole (and not per iteration) it will generate an error (built in error mechanism) and break the workflow which it should

Now I just want to replace that error with a message tool and stop the execution there. (Dont want red alerts)