Import JSON data from Web

Hi,

I want to import data in Excel spearsheet from a web site in JSON format.

I use an URL like this one : "https://api.weather.com/v2/pws/history/hourly?stationId=KCAOAKLA44&format=json&units=m&date=20181001&apiKey=yourApiKey "

Each request download data for 1 day, giving 288 lines with 38 columns each. It works fine by using the import data from web menus in Excel. Each data for 1 day is then in 1 spreadsheet, each new day downloaded giving a new spreadsheet.

As i want to get data for all days of 1 year, i.e 365 days at least, i would like to find a way to ease the work.

Issues with the normal way of working :

- date requested should be a variable able to be entered during the process

- data for each day should be appended to one spreadsheet and not going to a different spreadsheet

- for each request i have at least 4 or 5 clics to enter date, launch request, open results, deploy lines, deploy columns, save in speadsheet, etc.… how can i have only one clic to get all data integrated in the same speadsheet as all previous data already gathered… ? 

Or should i use another tools than excel ? Access ? other ?

Is it mandatory to code some prog language like VBA or other to achieve that ?

Regards

Bernard