Oct 09 2017 01:43 PM
Oct 16 2017 06:39 AM
Sure thanks for responding. Here's a 'snip' showing the data and site. I think my question was poorly worded, but I just want to get data like this into excel. It's supposed to be a JSON api, but I have not been able to get the external query feature to work with this or similar data. Not sure what else to try. Thanks in advance.
Larry
Oct 16 2017 07:57 AM
Not very hard to do with PowerQuery, see attached.
May 28 2019 06:10 AM - edited May 28 2019 06:12 AM
@larry rubin hope it's not too late. There is excel inbuilt function called WEBSERVICE() to get api data into excel. Hope it helps other who are in need.