UTM to LatLong

[Anonymous]

Hi,

Tryinto convert UTM to Lat Long. I am using a web source calling an URL and invoking a function. The error I get says invalif Northing and Easting coordinates. The same corodinates I use in the web gives me the Lat Long. Any ideas what I am doing wrong.

I am using a view as a data source having the data with ODBC connection.

let aa=(easting as number,northing as number) =>
let
Source = Json.Document(Web.Contents("http://www.bgs.ac.uk/data/webservices/CoordConvert_LL_BNG.cfc?method=BNGtoLatLng&easting=&easting&&n..."))
in
Source
in aa

[v-lionel-msft]

Hi @Anonymous ,

After converting to table.

Is this what you want?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous That link is not working for me:

[Anonymous]

Hi Greg,

Link is below? Am I doing something wrong in the code?

http://www.bgs.ac.uk/data/webservices/CoordConvert_LL_BNG.cfc?method=BNGtoLatLng&easting=429157&nort...

[Anonymous · Accepted solution]

Hi Greg,

Yes I got it working thanks

Oscar