Importing data from a JSON Weather API into Microsoft Excel using Power Query
This article shows how to import data into Microsoft Excel using Power Query from a RESTful Weather API. This API returns JSON-based data. 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 result table …
Continue reading “Importing data from a JSON Weather API into Microsoft Excel using Power Query”
How To Load Weather Data into Google Sheets using JSON
While it is very easy to load weather data into Google Sheets via CSV, loading JSON can seem a bit more challenging. However, for the savvy Google Sheets user, loading JSON weather data from the Visual Crossing Timeline Weather API is almost as easy as using CSV and offers additional benefit and functionality that CSV …
Continue reading “How To Load Weather Data into Google Sheets using JSON”
Weather API JSON result structure
This document applies to the /forecast and /history endpoints. If you are using the Timeline Weather API (/timeline), you can find the JSON structure documented on the Time Weather API documentation page. This article describes the JSON structure returned from the weather API. This same basic structure is returned for both weather forecast, weather history …
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 …
How to retrieve the Visual Crossing API Query String when using the Web Query Builder interface
For trouble shooting purposes it is often helpful and sometimes needed to have the exact query string at hand, which is send to Visual Crossing when using the Graphical User Interface of the Web Query Builder. This helps, amongst others, with identifying connectivity problems or interface compatibilities. Moreover it is needed by our data quality …
Bulk Weather Alerts API
The bulk weather alerts API endpoint allows authorized users to retrieve all the active weather alerts for a region or area. Please note: The Bulk Weather Alerts API is currently in testing and open to invited users only. If you would like to be considered for this testing, please send the details of your use …
Air Quality Elements in the Weather API
The Timeline Weather API offers optional air quality index elements. This article describes how to include them with your API request. Air Quality Elements are currently available globally with limited history and five day forecast (hourly or daily). Please note: The Air Quality Elements are currently in testing and open to all users to provide …
Weather Alerts
In addition to basic weather forecast information, we also support retrieving weather alerts for many locations. Weather alerts are alerts, warnings and other high priority information issued by local weather organizations that indicate severe weather or other weather conditions of note that the population should take action on or be aware of. Weather alerts are …
How do I run a weather API query using HTTP POST?
While it is very easy to run weather queries using HTTP GET requests, there are times when it is preferable or even necessary to use HTTP POST requests instead. While HTTP POST requests are a little more complicated to configure and execute, they are well within the reach of any modern script or language. Also, …
Continue reading “How do I run a weather API query using HTTP POST?”
How to load Visual Crossing weather data into Alibaba Cloud DataWorks
Aliaba Cloud DataWorks is an end-to-end big data development and governance platform that provides data warehousing, data lake, and data lakehouse solutions based on big data compute engines. Weather data is widely used in a variety of scenarios in data analytics and AI applications and hence often to be integrated in your data load scenarios. …
Continue reading “How to load Visual Crossing weather data into Alibaba Cloud DataWorks”