How to modify database query result in server actions?

[samrich]

If have a basic database query that will return several records. Each record would have for example: fname, lname, ID, email

Now in my server workflow / server connect action I have created the database query and it is returning the expected data. Now I would like to password encrypt each email before sending it to the front end. How do I modify each of the returned emails one at a time and send them back with the rest of each record? Is this some kind of “Repeat”? How do you modify the query result?

[franse]

Hello!
What about using server connect arrays?

Create a query with no output:

Then you create an array with the nedeed schema:

A repeat action that will add each record to the array with the encripted value:

And finally, a Get array list

Result:

If you’re using encrypt options don’t forget to backup everything before testing