mass ip geolocation

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