This extractor allows you to look up the weather anywhere on the globe, returning hour-by-hour or day-by-day observations going back decades. Data are provided by the Dark Sky API.
To configure the extractor, you need to provide tables with locations, your Dark Sky API key, units to use and a desired forecast granularity.
Before you start, please create an account in the Dark Sky API. Log in and get your API Secret key. Dark Sky offers 1,000 API calls a day for free.
The extractor fetches weather conditions for locations provided by you in one or more tables. Each table must contain the following columns in this particular order:
latitude— The latitude of a location (in decimal degrees); positive is north, negative is south.
longitude— The longitude of a location (in decimal degrees); positive is east, negative is west.
date(optional) — The date in format
YYYY-MM-DD. By default, the current date is used.
Column names are not important. The only condition that has to be matched is the column order. If you have a table with more columns, or the order of your columns is different, use the advanced input mapping and select the required columns in the desired order.
You can test the extraction on this sample file.
The extractor produces one table called
weather with the following columns:
primary— hash of the latitude, longitude, date and key used for incremental saving of data
latitude— latitude of the location
longitude— longitude of the location
date— date and time of the weather condition
key— name of the weather condition (e.g.,
value— value of the weather condition
Data are always imported incrementally. You can find the description of all weather conditions in the Dark Sky API Documentation.