Is it possible to add a field that outputs a query that takes in an argument from another field?

Say you’re creating a table visualization and you have something like this:

alertRuleId alertRuleName
123 aRule
456 anotherRule

What if you wanted to add a third column, say “status”, that shows, for each row, the result of an http request to a given endpoint:

alertRuleId alertRuleName status
123 aRule normal
456 anotherRule warning

How would you manage to do that?