Hi @LearnDB1234 ,

Here is the approach - You can make your API call dynamic by first running your SQL query and storing the results in a DataFrame. Then, you can loop through each row in the DataFrame and extract the FirstName and LastName values, passing them into your API request instead of hardcoding them.

Here’s a simple way to do it -

1. Run your SQL query to get FirstName, LastName, and Title into a DataFrame.

2. Convert the DataFrame into a list so you can iterate through each row.

3. Inside a loop, dynamically insert FirstName and LastName into your API request.

4. Call the API for each person and collect responses.

5. Store responses in a new DataFrame for further processing.

This way, every API request will use actual names from your SQL output, removing the need for hardcoded values. It keeps things clean, scalable, and automated.

Regards,

Brahma