Enrich data from REST API

I’d like to be able to enrich my data by pulling in data from a REST API during the transformation. I’d like the ability to use an existing column to dynamically construct the API request URL like api.example.com/v1/details/{data}.

I can see how dynamically creating the URL would be useful.

Do you have an example of another piece of software that does a good job of interfacing with REST APIs?