I want to build an App that retrieves data from an API endpoint and performs multiple actions afterwards.
I created a table that uses a RestAPI Query to get data from the API endpoint. Good, everything works.
Now, for each row, I want to change part of the value in a specific column only if it matches a filter (like search and replace) and use the new modified value later.
After that, for each row, I want to call another API endpoint using, as path and body parameters, values in the table and the previously modified value (read above).
Is it possible to achieve that with Retool?