loop through the column

Hi!

I have just one table with a column of names. 

I`m trying to get the data through rest api so I`m using the query link :    /rest/usermanagement/1/user?username="" . Instead of "" in the username attribute I have to add each username from the column with names (unfortunately, there`s no wildcard for this attribute that I could use to avoid looping through column).

What I have now: 

I enter manually the username to the query link and get the detailed info about user. Query returns xml formatted data (there`s no problem with expanding it in the Power BI) 

(just one row with data about one user only).

And what I need is:

a lot of rows with the info about each user in one table. Maybe I need to write a function and pass the name column as a parameter to it, but I`m not sure how to do that.

Any help would be really appreciated.

Cheers