Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

mass ip geolocation

Hey PowerBI,    I'd like to conduct a mass look up of all IP addresses within my file providing them with associated latitudes and longitudes so I can accurately locate where they map out to.  I ha...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Back again, Gilbert! So we opted to continue with the IP stack API. I seeimingly still cannot get the function work once I click close & apply. The code definitely works as it loads up the table I want once I have invoked the custom function. The issue I keep coming up against is a web access issue after. I am using the http version of the website not the https. Is there a way of running the function so I can avoid this? 

 

This is my code below.

 

= (#"IpAddress" as text) => let
Source = Json.Document(Web.Contents("http://api.ipstack.com/"&#"IpAddress"&"?access_key=MYAPIKEY"& "&security=1")),
#"Converted to Table" = Record.ToTable(Source),
#"Transposed Table" = Table.Transpose(#"Converted to Table"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table")
in
#"Promoted Headers"

 

Thanks, 

S

GilbertQ's avatar
GilbertQ
Super User
7 years ago
Hi there.

I think you need to make it. Anonymous and put the API key as part of the url
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    How would I go about doing that? I'm only provided with two options. The website or the website + the IP address without the access key to follow.