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. …

Agriculture elements in the Timeline Weather API

The Timeline Weather API includes elements that are designed for use by the agricultural, farming and horticultural industries. These elements are designed to providing weather data that influence those who grow plants or raise livestock. The elements on this page are available only to certain subscription levels. For more information, please see our pricing page. …

Date and Times in the Weather API

The Weather API uses a set of standards to include date time information. This article describes the standards used. Date formats in the Weather API Visual Crossing uses ISO 8601 based date formats for both date and times. Dates are formatted according to YYYY-MM-DD format (2022-06-15 for June 15th 2022). Times are formatted according to HH:mm:ss. The hours are specified in …

How to load weather data into a Juypter Notebook

This article describes how to create a new Jupyter notebook that retrieves weather data from the Visual Crossing Weather API. The example uses Python as development language but you can choose any language that Jupyter supports including C++ and R. JupyterLab is used to create the notebook. JupyterLab is a web-based interactive development environment for …

Using the time period parameter to specify dynamic dates for Weather API requests

Often when requesting weather data via the weather API we wish to request data for a fixed period based on the current data. For example, request the data for yesterday, today or the next seven days. The time period parameter of the weather API allows you to easily request data for dynamic time periods. Example …

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

This article shows how to import data into Microsoft Excel using Power Query from a RESTful Weather API. This API returns JSON-based data. 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 result table …

How to Load Weather Data into Microsoft Excel using a Web Query Data Connection

One of the powerful features of the Visual Crossing Weather Service is the ability to query data via a Web Service or URL.  This benefits not only coders but rather can be utilized to import data into most Business Intelligence Systems including Excel.   When you include your data into Excel, you can refresh the data …

How to include sunrise, sunset, moon phase, moonrise and moonset data into your API requests

In addition to providing historical weather observations and weather forecast data, the Weather API also provides astronomical information. This astronomical information includes sunset, sunrise and moon phase data. Why is astronomical information useful? Sunset, sunrise and moon information goes hand-in-hand with weather data in many use cases. The information can help answer some basic questions: …