Add location and date time filters to ODATA weather data requests

The Visual Crossing Weather API supports requesting data using OData requests. This makes it easy to integrate weather data into tools that support the ODATA specification. In this article we discuss how to extend the basic ODATA requests to create dynamic queries using ODATA filters. The basic ODATA request As the introductory article discusses, the …

How to make a WordPress plugin that uses shortcodes to show the weather forecast

Note – If you want to use this plugin right away, you can download the ready-to-install version from the WordPress plugins directory. WordPress is a hugely popular content management system used by hundreds of millions of sites across the internet to build websites and blogs. In fact, it bills itself as “the world’s most popular …

How to look up the current weather conditions in the Weather API

Many weather data applications such as weather widgets, weather analytics tools and information displays find it useful to communicate the current weather conditions. These conditions include current temperature, wind speed and direction, recent precipitation and more. Looking up the current weather conditions for one or more locations is easy in the Visual Crossing Weather API. …

How can I load historical weather data using Google Apps Script?

Google Apps Script also known as Apps Script or sometimes Google Script, is a scripting language based on JavaScript and used within Google’s G Suite applications. Although it started life as a side project within Google Sheets, today it is used as a scripting language within all of the Google apps family including Google Sheets, …

How to use Python and Pandas to join historical weather data to road accident data

I am currently investigating the relationship between weather conditions and accidents by using a dataset of road accidents in Fairfax County, Virginia obtained from the Virginia Department of Motor Vehicles. The first step to perform the analysis is to combine the accident data with the historical weather conditions. In this article, we will discuss how …

What is the cause of “Maximum concurrent jobs has been exceeded”, HTTP response 429

The above error indicates that the servers have identified that the account is attempting to execute more weather requests at a single time than is allowed by the current plan. When a request above the permitted limit is executed, the HTTP response code returned will be “429 Too Many Requests”. In the case of plans …

Automate recent weather history data retrieval using Microsoft Power Query

In our previous articles about integrating Weather History data into Power BI and Microsoft Excel, we have used the Visual Crossing Weather API to retrieve historical weather data. In this article we discuss how to make those weather data queries automatically read the latest weather conditions using Microsoft Power Query. If you would like to …