Articles for "JSON"

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 …

Timeline Weather API

The Timeline Weather API is the simplest and most powerful way to retrieve weather data. You can request data over any time window including windows that span the past, present, and future. The API will take care of the combining historical observations, current 15-day forecasts, and statistical weather forecasts to create a single, consolidated dataset …

Weather Data Documentation

The Visual Crossing Weather Data platform provides the ability to easily access weather data sets including weather forecast data, weather history data and historical weather summary data. The data is available for download through the Weather Data Query Page and the Timeline Weather API. Core weather columns These columns are common to most weather data sets unless disabled. …

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 …

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