Weather Data

[Clark_White]

I would like to create an app that displays Weather data via a map along with Operational Metrics.   Is there a free datafeed or WebConnection that I can use for this?

[lorenzoconforti]

https://openweathermap.org/api

[Clark_White]

Thanks for the response, I keep getting a "Failed to Connect to Server" message with the Rest Connector.   Do you know the specific settings we need to use with the OpenWeather API?   I am fairly new to Qlik. 

[lorenzoconforti]

You don't need a specific connector, you can just use the Web file connection. I've created a dashboard to illustrate this; see attached

You will need to

1. create an account on openweathermap.org; you will be given an API key

2. create a new connection in the Data load editor; select "Web file" (URL "https://samples.openweathermap.org/data/2.5/forecast", name "WeatherData")

3. in the data load editor, edit the variable vAPIKey and replace <YourAPIKey> with the API key at step 1

4. reload

The loading script will go through the list of cities included in the locations table and query openweathermap and retrieve the forecast information; I've added some extra information in the sample stats table which are displayed in the tooltip on the map (you need sense february 2020 for this to work)

Study the file and then let me know if you have any questions

[Clark_White]

Thanks.  The app looks good!  

I get the SSL/TSL handshake failed. Certificates and/or passwords are invalid. 

From my research, it looks like I need to Create a SSL Certificate for the Web Connectors.    Is this correct?

[lorenzoconforti]

Does it give you error when you create the new connection or when you run the script?

I just tried and it also works with http so you can probably just edit the two URLs in the loading script 

[Clark_White]

It still fails.    I get an unknown error when I try http.

[lorenzoconforti]

Does this happen in 1 or 2:

1 - when you create the connection (i.e. Data model viewer -> Create new connection -> Data sources -> web file -> URL "https://samples.openweathermap.org/data/2.5/forecast", name "WeatherData"

2 - when you press the Load data button

[lorenzoconforti]

Also, please post a screenshot of the error message

[Clark_White]

This is what I get from the New Connection Screen.