Looping or using indexing to iterate through a derived list

Question

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

convEvalPairsList.png

Archaeopteryx · Answer

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

MacroError-Operator must be between operands-1.png

MacroError-Operator must be between operands-0-the input.png

MacroError-Operator must be between operands-2.png

MacroError-Operator must be between operands-3.png

echuong1 · Answer

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/ta-p/488165

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

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