Is there any weather api return data type of json?
You can use Yahoo! weather API through YQL and get response in JSON format. Try it here.
As mentioned, you can use the yahoo weather API and if you want an easy way of extracting the data, you can use json-csv.com
in General Discussion at YDN