Articles for "JSON"

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 …

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 …

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