Looping or using indexing to iterate through a derived list

[Archaeopteryx]

Hi,

In the screen shot I have a list that has been derived through filtering and matching via cross tabbing. I would need to take each [ConversationID] and [EvaluationID] record pair and place each value in another formula field that consists of an API call.

For example "https://APIURL/Conversation/"+[ConversationID]+"/Evaluation/"+[EvaluationID]+"....."

I would do an API call with the above, then, I would need to take the next record pair into the formula above and do that API call again. I would repeat, until I've reached the end of the list.

The list could vary in number of record pairs as it would not be known beforehand how many ConversationID and EvaluationID pairs would be derived. 

Thank you for any assistance.

Chris

[echuong1]

This is certainly possible, and can be achieved with a batch macro. Essentially, you'd build a workflow to handle one item. From there, wrap it into a macro.

These resources may help you get started:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

https://community.alteryx.com/t5/Videos/Build-Your-First-Batch-Macro/td-p/52900

https://help.alteryx.com/current/designer/batch-macro 

[Archaeopteryx]

Hi,

Thank you for the tips. I would like to display some screen shots that show the error I'm getting and the macro set up. 

I'm not sure whether this requires a batch macro or iterative macro. I've set up a batch macro for now.

OBJECTIVE OF MACRO:

The objective of the macro is to replace two parameters, the Conversation ID and the Evaluation ID in the API call. See screen shots.

Then, when the API call has connected, I parse the JSON and create a file and name it based on the two parameters aforementioned. 

I'm getting a parse error inside the macro, " a separator has to be used between operands ". So, I'm not certain how the macro should be set up for this use case. 

Thank you,

Chris