How to efficiently schedule API WF on a list of CSV to create new items in the database without using recursion

[heyveejay0308]

How to efficiently schedule API workflow on a list of comma-separated values to create new items in the database without using recursion?

I’ve been working on creating multiple new items in my database from a list of comma-separated values. I previously set up a recursive workflow that splits the values and processes them one by one, which works but isn’t workload unit efficient.

Now, I’m trying to use “Schedule API Workflow on a List” to improve efficiency, but I’m running into issues. The values from my comma-separated list (e.g., Item1, Item2, Item3) are still being treated as a single string, and my workflow is spitting back values like “Item 1, Item 2, Item 3” as one item, rather than creating separate entries for each.

Has anyone encountered this? What’s the best way to split and schedule API workflows on a list of comma-separated values without using recursion, while ensuring each value is processed individually to create separate database entries?

[georgecollier]

Schedule API workflow on list of text

List to run on: (your text):split by ,

Inside the API workflow, create the Thing based on the current workflow’s text.

[heyveejay0308]

Woohoo!!! It worked

You are awesome.
Spending 0.70 WU on each recursion was a no-brainer.

Thank you.