iterative macro iteration

[Kinetic_analytics]

Hello:

I have created an iterative macro to call an API. In every call getting 100 records. In the macro I have set up 350 times. Getting error Tool#13. How do I know how many records left?

Attached the SS

Appreciate your kind help. Thanks:) 

[binuacs · Accepted solution]

@Kinetic_analytics Change the interface tool settings of the macro like below and try again

[Kinetic_analytics]

Thank you. Appreciate your help in my learning process. 

[IraWatt · Accepted solution]

Would have thought that would be impossible to tell unless you knew how many records you were expecting to get from the API. The Schema problem you'll need to standardize the output, transposing everything before the macro output is a easy way to get round that.

[Kinetic_analytics]

Thank you for thoughts. Appreciate your help. :)