Repeating a separate process during the execution of an iterative macro

Archaeopteryx

I'm running API calls and saving data to a SQL Server. There is an iterative macro involved which runs an API that includes an ID number. Each iteration of the macro produces a new ID number until the data request has exhausted all id numbers.

I need to run a SQL Server stored procedure between each iteration of the macro calling that Stored Procedure. 

I have the SP set up in an Input Tool. And it is in its own workflow.

Can someone assist as to how that SP can be called in between each iteration of the macro? I have tried the Runner CReW macro, but it seems to halt the iteration of the macro and it hangs. 

Thank you,

Chris

danilang

Hi @Archaeopteryx 

As @MattBSlalom suggested, add the call to the SP in the iterative macro.  Use a Dynamic Input as opposed to an Input tool so that you'll be able to place the tool wherever you need to in the workflow.  The Dynamic Input needs to have at least one option set, so check the Modify SQL Query option and Pass a Field to The Output.   

Just make sure you use a Summarize or Sample tool before the Dynamic Input so that you only call the SP once.

Dan