Forum Discussion
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...
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
SourceReplacing 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.115Can 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
SourceAnd 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=0I badly need this to work :( Please help
Thanks,
indhu
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
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
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