Iterative macro

[ISAMELDIN]

Helo gents 

I have Iterative macro calling API I have filtered the bad headers, and I need to give to tries when its bad request or any error 

how to do the ? I have been traying [engine iteration] but no luck

PFA

[Raj]

@ISAMELDIN 
update formula too 58 with this formula

[RecordID] = [Engine.IterationNumber]+1


mark done if solved.

[ISAMELDIN]

sorry i need more datils 

[ISAMELDIN]

@Raj 

[CoG]

This workflow confuses me based upon the sample data, but hopefully I can be of some service:

1. I noticed that you are filtering on RecordID = 1, which isolates a single record for each iteration of the macro (passing the remaining records through the iteration Macro Output Tool). This doesn't make sense since you are throttling records later on before running through the Download Tool.
2. If you stop doing that, you can move your macro output forward so that only the records that fail the API call (header code != 200 based code) are passed on to the next iteration.
3. If you don't intend to stop/cannot stop that filter, then you can just Union failed records into the remaining records so that both sets of data get passed through to the next iteration.

Hopefully this helps provide some clarity as to how you can approach this problem. Happy Solving!