Overview
Summary
This guide will show how to setup open weather so that Weather information for your location is updated within Bepoz to enhance reporting.
Prerequisites
OpenWeather API User Account
SETUP:
OpenWeatherMap
Step 1: Open Weather
Create an Account with open weather → https://home.openweathermap.org/users/sign_up
Once logged in, click on the API Tab → https://openweathermap.org/api
Subscribe to a Weather Data Collection in this example we will be using the 'Current Weather Data' (FREE)
This will create an API key → https://home.openweathermap.org/api_keys
Parameters that can be specified for Locations → https://openweathermap.org/current
By city name
By city ID
By geographic coordinates
By ZIP code
Step 2: (Bepoz Setup)
Create a New Scheduled Job → DLL NAME: Jobstd.dll → ClassName: Weather Open Weather
Job Options
Postal Code: is ZipCode (USA only) - example: 94040 &q=London
Schedule to the job to update once per hour, you can make 60 requests per minute. 1000000 calls per month
Example of a Report:
Known Issues
A known limitation is that the Location parameter is currently locked to ZipCode only
If the weather job has never been used, you need to create a dummy record
INSERT INTO Weather (ShiftID, VenueID, DateUpdated)
VALUES (73090, 1, 2020-01-01);