urgent get data from API

[ezgi]

How can I get all employee details from that API link ?

 https://elels.re.com/api/getEmployeeRate?email=ali.ahmet@y.com

I have to change ali.ahmet@y.com that part for each employee. Is there any option to get all data?Also I have to put token for access to that API source

[ppm1]

Please see this video. You can start with a table of your email addresses and then concatenate that address into a separate Web.Contents call on each row.

Power BI - Tales From The Front - REST APIs - YouTube

Pat