Forum Discussion

Peter_Verweij's avatar
Peter_Verweij
Regular Visitor
5 years ago
Solved

BING API INVOKE FUNCTION

Hello,   I am struggeling with to get the LAT and LONG from the BING API. I am following this video: https://www.youtube.com/watch?v=uZoH4wITCH0 But at 11:45 when i invoke custom column i get an ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Peter_Verweij 

    The Web.Contents call needs to be modified slightly.  Try this (I tested this on my own PC and it works)

    BINGKEY = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
Bron = Xml.Tables(Web.Contents("http://dev.virtualearth.net/REST/v1/Locations?countryRegion=Netherlands"
&"&AdminDistrict2=" &Place
&"&postalCode=" &Postalcode
&"&addressLine=" &Adres
&"&o=xml&key="&BINGKEY)),

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Peter_Verweij 

The Web.Contents call needs to be modified slightly.  Try this (I tested this on my own PC and it works)

BINGKEY = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
Bron = Xml.Tables(Web.Contents("http://dev.virtualearth.net/REST/v1/Locations?countryRegion=Netherlands"
&"&AdminDistrict2=" &Place
&"&postalCode=" &Postalcode
&"&addressLine=" &Adres
&"&o=xml&key="&BINGKEY)),

Regards

Phil

Peter_Verweij's avatar
Peter_Verweij
Regular Visitor
5 years ago

Thank you so much PhilipTreacy 

I just coundt find it, but you did 😉

 

i am so happy.