Custom Connector Profile

Author: Matillion
Date Posted: Jun 24, 2024
Last Modified: Jul 23, 2024

Weather API

Download current and historic weather data by location.

This Data Productivity Cloud Custom Connector extracts and loads data from the Weather API.

Image ofWeather API endpoints
Weather API endpoints

Authentication

Under the “Connect” component properties, set the key to key and the value to the name of a Secret in which you have saved your WeatherAPI.com API key.

Parameters

Under Configure > Query Parameters, set the parameter q to your location.

The API allows:

  • Latitude and Longitude (Decimal degree) e.g: q=48.8567,2.3508
  • city name e.g.: q=Paris
  • US zip e.g.: q=10001
  • UK postcode e.g: q=SW1
  • more, as per the API documentation

The Historic endpoint also requires a dt parameter to specify the date in yyyy-MM-dd format (e.g. dt=2010-01-01)

Endpoints

  • Today
  • Historic

Downloads

Licensed under: Matillion Free Subscription License

Installation Instructions

How to Install a Data Productivity Cloud Custom Connector