I need trigger a process to get each record from a table, and later pass values to a workflow variable

Hi community ,

I´m needing trigger a process with an API call (I have clear this process) in order  to retrieve a couple of values from each record stored in a table in joget to do an evaluation and pass the outcomes to a email tool.  I think that I can use a SQL tool or a beanshell tool but I´m not sure how can I do to pass the values to a workflow variable or to call another process with this input.

Do you have an idea about how can I do to automatize it?