Forum Discussion
jsteffe
Helper III
Helper IIIBing map API : how to manage null results ?
I get this custom function that gives the address based on latitude and longitude using the BING MAP API : let
FindLoc= (lat, lon) =>
let
Source = Xml.Tables(Web.Contents("http://dev.virt...
That's not DAX, it is Power Query.
let FindLoc= (lat, lon) => let Source = Xml.Tables(Web.Contents("http://dev.virtualearth.net/REST/v1/Locations/"&Replacer.ReplaceText(Text.From(lat),",",".")&","&Replacer.ReplaceText(Text.From(lon),",",".")&"?o=xml&key=AqXbM3RmYA05LA89D0jBdRSYxgrYNUOwSNEsDS2G9aXaYBqFDOIYDT8IPoHKhJRp")), #"Removed Other Columns" = try Table.SelectColumns(Source{0}[ResourceSets]{0}[ResourceSet]{0}[Resources]{0}[Location]{0}[Address],{"FormattedAddress", "Locality"}) otherwise #table({"FormattedAddress","Locality"},{{"undefined","undefined"}}) in #"Removed Other Columns" in FindLoc
lbendlin
Super User
Super Userlet
FindLoc= (lat, lon) =>
let
Source = Xml.Tables(Web.Contents("http://dev.virtualearth.net/REST/v1/Locations/"&Replacer.ReplaceText(Text.From(lat),",",".")&","&Replacer.ReplaceText(Text.From(lon),",",".")&"?o=xml&key=AqXbM3RmYA05LA89D0jBdRSYxgrYNUOwSNEsDS2G9aXaYBqFDOIYDT8IPoHKhJRp")),
#"Type modifié" = Table.TransformColumnTypes(Source,{{"Copyright", type text}, {"BrandLogoUri", type text}, {"StatusCode", Int64.Type}, {"StatusDescription", type text}, {"AuthenticationResultCode", type text}, {"TraceId", type text}}),
#"ResourceSets développé" = Table.ExpandTableColumn(#"Type modifié", "ResourceSets", {"ResourceSet"}, {"ResourceSets.ResourceSet"}),
Location = try #"ResourceSets développé"{0}[ResourceSets.ResourceSet]{0}[Resources]{0}[Location][Name]{0} otherwise "undefined"
in
#"Location"
in
FindLoc
jsteffeThanks for your answer which perfectly works.
But I I wan to get 2 columns (lacationName and AdressLocality for example), should I create 2 function (one for each information) or can I return 2 columns (or a table) as the result of my function ?