Forum Discussion
mass ip geolocation
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
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
Worked. Thanks a lot :D
- Awesome glad you got it working!
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
- Hi there.
I think you need to make it. Anonymous and put the API key as part of the url 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.