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

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.