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
GilbertQ's avatar
GilbertQ
Super User
8 years ago

Hi indhu

 

It appears that they have got a free option which has got 10 000 lookups.

 

Otherwise you would have to pay for a lookup service?

indhu's avatar
indhu
Helper III
8 years ago

GilbertQ 10,000 looks up is fine. I replaced your following code to this,

 

let
Source = (#"IP Address" as text) => let
Source = Json.Document(Web.Contents("https://ipstack.com/json/" & #"IP Address")),
#"Converted to Table" = Record.ToTable(Source),
#"Transposed Table" = Table.Transpose(#"Converted to Table"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table")
in
#"Promoted Headers"
in
Source

Replacing the source name to new web address. I am getting this error,

 

DataSource.Error: Web.Contents failed to get contents from 'https://ipstack.com/json/203.56.182.115' (404): Not Found
Details:
    DataSourceKind=Web
    DataSourcePath=https://ipstack.com/json/203.56.182.115
    Url=https://ipstack.com/json/203.56.182.115

Can you please point me out what I am missing?

 

I also tried another site, https://www.ipinfodb.com/api Following your post and replaced the M query as follows,

 

let
Source = (#"IP Address" as text) => let
Source = Json.Document(Web.Contents("http://api.ipinfodb.com/v3/ip-city/?key=<APIkey>" & #"IP Address")),
#"Converted to Table" = Record.ToTable(Source),
#"Transposed Table" = Table.Transpose(#"Converted to Table"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table")
in
#"Promoted Headers"
in
Source

And getting this error,

 

An error occurred in the ‘fn_GetIPAddressDetails’ query. DataFormat.Error: We found extra characters at the end of JSON input.
Details:
    Value=
    Position=0

 I badly need this to work :( Please help

 

Thanks, 

indhu

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago
    Hi there

    As per there documentation you will have to sign up and get an API Access key.

    Then when you query as part of the query string you would need to put in the API Key in order for it to work
    • indhu's avatar
      indhu
      Helper III
      8 years ago

      GilbertQ did that and in that M code replaced <API> with the actual API key. Got the following error,

      An error occurred in the ‘fn_GetIPAddressDetails’ query. DataFormat.Error: We found extra characters at the end of JSON input.
Details:
    Value=
    Position=0
      • GilbertQ's avatar
        GilbertQ
        Super User
        8 years ago
        Hi there

        Did you test it manually via the URL?

        If that works make sure that there are no spaces when passing it through via the function