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

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

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 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 ability isn’t only limited to 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 …