Modifying a Lat/Long function to extract ID and Reference from a Google Place query

Hello,

I have a function and a macro that are using Google Geocode to extract the coordinates for an address within a cell.
I would like this function modified so that it uses the Google Nearby Search to extract from a link within a cell the ID and Reference of that place.

The link within the cell is something like this:
https://maps.googleapis.com/maps/api...YourAPIKeyHere

The result for ID should be this: 017640196914becd7636d212b4cff247ec36317f

The result for Reference should be something like this: CnRlAAAAOTVp1uuJM5oZC6jSbQUaj_1oAFlEththZyqIpx85MZXwZtAgqW0Q11dTXnywQEJL0mrBoMAuoprt28GCGC2gXiCUkxOn-8o4T4Eo2kGqvWJXXjxDaJdp9s3prbzmtL4u8UI3V5SUPbmc2omjR6qjTBIQvx_j5lPaAGY1KzmEJE-puhoUjlZDQNYJtqQXlaofog4rrbzYiUc

From what I figured so far, inserting the link into the macro\function is no big deal, but extracting certain fields from the query result is and I don't know how to do it properly.

Can anyone help me with this?
Would really appreciate it.

This is the documentation link for Google Places API where the list of details for each search is detailed.
https://developers.google.com/places...tation/details

Copy of Lat_Long_Google_MAP.xlsm

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.