Currency Exchange Rates

version LATEST

๐Ÿ“˜

Check out theย docs Exchange Rates API for more information

Set up


You can access the historical exchange rate data for a vast number of currencies through Kleene.
To begin using the Exchange Rates connector you need to follow these steps to start pulling data:

Obtaining API Key

The API requires authentication to connect, and there are a couple simple steps to obtain a valid key for the source config:

  1. Go to https://apilayer.com/marketplace/fixer-api and subscribe to the Free Plan
    (May require account creation)
  2. Acquire the API Key for this exchange rates API
  3. Go to account page (https://apilayer.com/account) to view your API Key (or generate a new one)

Add API Key to Kleene

Final step is adding the API Key you just generated to the source config in Kleene:

And then making sure the source is named and a base currency is selected.

Save the config and you're ready to setup and run extracts from this connector.

Features


FeatureSupportNotes
Backfillโœ…The Full report allow data extraction of the majority of supported currencies from 1999.
Incrementalโœ…Supported with the Incremental report
API reliability๐ŸŸ Unreliable

๐Ÿ“˜

Incremental

The incremental report will load only the latest data if it is running to an empty table but if there is data it will return all the data from that date up to the most recent data.

Reports detail


โฌ‡๏ธ Report๐Ÿ”‘ Incremental key๐Ÿ”‘ Primary key๐Ÿ“„ Link to API endpoint
FullN/ADATEEndpoints
IncrementalDATEDATEEndpoints

Limitations

๐Ÿšง

Backfill periods

The API will allow you to query for daily historical rates between two dates of your choice, with a maximum time frame of 365 days. In case you need longer backfill, you may want to run an extract more than one times with different dates to cover all periods you need.