How to obtained Google Place ID?

Question

I've tried using Google Maps API connecting to Microsoft PowerBI with the following Web connector method: https://maps.googleapis.com/maps/api/place/nearbysearch/json?location=54.77614759999999,-1.5605721&radius=2000&type=restaurant&key=INSERT_API_KEY

But this is a "Place Search" and doesn't bring any details such as a website or phone numbers etc. To include a "Detail Search" I have to use JavaScript function mentioned in this topic: Google Places API - Places detail request undefined

I have both PowerBI and Visual Studio but just not used to JavaScript. Any help is much appreciated, thank you.

Answer 1

• API endpoint is placed by google for Place Details is at

https://maps.googleapis.com/maps/api/place/details/output?parameters

• For example,

https://maps.googleapis.com/maps/api/place/details/json?placeid=ChIJN1t_tDeuEmsRUsoyG83frY4&key=YOUR_API_KEY

where placeid can be obtained from the Place Search API you used before.

• In order to automate the process programmatically, whether by JavaScript, VBA or Power BI is up to you, and also depends on how you want to make use of the data afterwards.