API to Excel

I want to import information from a Restful API into Excel (all data). I would like the refresh button to update the data on demand. If that is not easily possible then updating on a schedule will work as well.