This should be a simple little project for someone.
The BOM website provides a JSON feed of the data I need. Here it is:
I need a script to fetch this data and insert it into my MS SQL 2008 database. The script will run via Windows Server 2008 Task Scheduler once per day.
My database has columns like: city, temperature, wind speed, direction, pressure, rain