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 …

How do I retrieve weather data using an ODATA request?

This article describes how to retrieve weather data such as weather forecast, historical weather observations and historical climate summaries using an ODATA based request. What is ODATA and when should I use it? According to odata.org: OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. …

How do I get started with the Weather API?

This article describes the fastest way to get started with the Visual Crossing Weather API by constructing API queries using the Weather Data Services page. Steps Navigate to Visual Crossing Weather Data Services Log in to your account (create a free trial account if necessary) Add one or more locations Construct a weather forecast or weather …

Bulk weather forecast data retrieval for multiple locations

Visual Crossing provides the ability to retrieve up to 16 day forecasts for any world wide location based on address, zipcode/postcode or latitude and longitude. In this article we discuss how to retrieve the full weather forecast for multiple locations in a single request. This makes it easy to import weather forecast information for many …