Importing data from a JSON Weather API into Microsoft Excel using Power Query

In this article we are going to demonstrate how to import data from a RESTful Weather API. This API returns JSON-based data into Microsoft Excel. We are also going to explain how to create a loop within our script so that we can call the API multiple times for multiple locations and create a combined …

What is a Weather API?

A weather API is an Application Programming Interface that allows weather data to be queried from scripts and code. Good weather APIs provide both historical weather data and forecast data via an easy-to-use, well-defined programming interface. The best APIs have dozens of weather measures, near-real-time current conditions reporting, and decades of worldwide historical weather reports. …

Where can I find historical precipitation data?

Historical precipitation data is an important weather measure that is very useful for many types of personal analyses and business use cases. Whether you are looking for precipitation data to plan a trip, schedule a conference, or optimize agriculture, a weather data service such as Visual Crossing Weather can provide precipitation data easily using global …

How to retrieve hail, tornado, wind damage and earthquake events in the weather API

The Timeline Weather API includes the ability to include significant weather and environmental events that have occurred near to a place of interest. These events can include earthquakes, hail, tornado and wind damage. When found, events are are included in the daily results. What kind of reports are available? There can be a number of …

In what environments can I run weather API queries?

All types of development environments need access to weather data. From command-line tasks such as database ETL, to scripts that drive websites and priority alerts, to mobile apps and complex business applications, weather data drives insight, decisions, and revenue. A good weather API is flexible enough to span all of these use cases, bringing a …

How to use timeline weather API to retrieve historical weather data and weather forecast data in Java

Our recently released Timeline Weather API allows you to easily retrieve hourly and daily historical weather data and weather forecast data in a single RESTful API call. In this article we demonstrate how to use the API in the Java programming language. For the full source of this example, download it from our GitHub repository: …