I have done web queries in the past. But I am now trying to use API data instead of whatever content imports from a web query.
When I go to the following url in a browser, I get a page full of script, I believe in JSON format: https://proapi.whitepages.com/2.2/lo...e+65&api_key=x
but when I try to paste this URL into the excel web query browser window, this same result does not display as with a normal browser window, but instead it asks me where to save the file. I can also open the file, but it opens a new excel window and places the data in there. I want the script to just import into excel the same as when I use the url in a normal browser window.
The problem I run into when trying to open the file is that none of these actions are recorded when I start recording a macro. I was hoping to record a macro of me web querying the api url and either get the JSON script directly in the excel window I had open or copy the script from the new excel window and paste it in the window I originally had opened.
If I cannot import the results of the web query with the api url, what is the next alternative to getting the data into exel?
I deleted the api key at the end of the url as I was not sure that this was something that should be posted.
Any help is appreciated
Bookmarks