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

How to use the Timeline Weather API to retrieve historical weather data and weather forecast data in Java

The Timeline Weather API allows you to easily retrieve hourly and daily historical weather data and weather forecast data in a single RESTful API call. In this article we demonstrate how to use the API in the Java programming language. For the full source of this example, download it from our GitHub repository: https://github.com/visualcrossing/WeatherApi/tree/master/Java/com/visualcrossing/weather/samples The …

How to load weather data in JavaScript using Fetch API, jQuery, d3 or node.js

Many applications need reliable weather forecast data or historical weather data that can be directly accessed from JavaScript code. They may be as simple as a weather forecast widget, a sophisticated historical weather data dashboard built using a JavaScript library such as jQuery, d3 or even a server side JavaScript application using node.js. All of …