Working on a set of data in API Workflow

Need help APIs
1

I need to create an API that, when hit:

  1. Loads data from the database grouped by one of the fields
  2. For each hit from step 1, loads the first 3 items of that group
  3. Sends an email with the details of each item

Is there any way to accomplish this?

2

I think you can use recursive APIs. i think you need 2 APIs

API1
load data (list of things) and send it to API2:

API2

  1. for item#1, send emails
  2. if list of things > 1, then call API2 with list of things minus item#1

(NB: you could use first item instead of item#1, but for a whole set of reasons, you should use item#1.)

I’ve struggled with this a while back and documented my learning: Schedule API workflow on a list - does the list have a limit?

3

Maybe I’m missing something, but I don’t see a way to load a list of things. What I see:

image

Is it “copy a list of things”?