API Querry Passing Data from Table Column

[unais]

Team,

I have a Table with a Public IP address that needs to be passed on to the web service " http://ip-api.com/json/24.48.0.1" Get Location details

please have the best option to achieve 

API Response 

{
  "query": "24.48.0.1",
  "status": "success",
  "country": "Canada",
  "countryCode": "CA",
  "region": "QC",
  "regionName": "Quebec",
  "city": "Montreal",
  "zip": "H1K",
  "lat": 45.6085,
  "lon": -73.5493,
  "timezone": "America/Toronto",
  "isp": "Le Groupe Videotron Ltee",
  "org": "Videotron Ltee",
  "as": "AS5769 Videotron Telecom Ltee"
}

[unais]

@amitchandak 

am reporting a Reporting to identify the server accessing location by IP Address. I have a database with the column value of the Public IP address list. I need to Pass this Value Specific API and Get a response from API with IP address city and country.

[amitchandak]

@unais , refer if these can help

https://community.powerbi.com/t5/Desktop/API-Calls-from-column/m-p/568646

https://community.powerbi.com/t5/Developer/Pull-Rest-API-Query-based-on-existing-column-data-as-key-...

[amitchandak]

@unais , Not very clear

Do you need

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

or

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78