Write Power Query code to retrieve and run existing web API calls already located in an Excel table. I want to substitute the hard-coded web API call example below, with one that I dynamically create using CONCAT() in Excel. Your task, is to read the Excel table, and run the calls contained successfully.
Current hard-coded example: [login to view URL]([login to view URL]("[login to view URL],-98.424119&radius=25000&type=post_office&key=YOUR_API_KEY_HERE"))
**You will need to get your free Google API key **
Please do your best work. I am looking forward to working with you, for both this, and future projects. Best Regards, Gary