Skip to main content

Exchange Rates API

Overview

The exchange rates integration is a toy integration to demonstrate how Airbyte works with a very simple source.

It pulls all its data from https://apilayer.com/marketplace/exchangerates_data-api

Output schema

It contains one stream: exchange_rates

Each record in the stream contains many fields:

  • The date of the record
  • One field for every supported currency which contain the value of that currency on that date.

Data type mapping

Currencies are number and the date is a string.

Features

FeatureSupported?
Full Refresh SyncYes
Incremental - Append SyncYes
NamespacesNo

Getting started

Requirements

  • API Access Key

Setup guide

In order to get an API Access Key please go to this page and enter needed info. After registration and login you will see your API Access Key, also you may find it here. You will then need to subscribe your account to the Exchange Rates Data API

If you have free subscription plan (you may check it here) this means that you will have 2 limitations:

  1. 1000 API calls per month.
  2. You won't be able to specify the base parameter, meaning that you will be dealing only with default base value which is EUR.

Changelog

VersionDatePull RequestSubject
1.3.02023-08-2529299Migrate to low-code
1.2.92023-08-1523000Fix schema and tests
1.2.82023-02-1423000Specified date formatting in specification
1.2.72022-10-3118726Fix handling error during check connection
1.2.62022-08-2315884Migrated to new API Layer endpoint
0.2.62022-04-2012230Update connector to use a spec.yaml
0.2.52021-11-127936Add ignore_weekends boolean option
0.2.42021-11-087499Remove base-python dependencies
0.2.32021-06-063973Add AIRBYTE_ENTRYPOINT for kubernetes support
0.2.22021-05-283677Adding clearer error message when a currency isn't supported. access_key field in spec.json was marked as sensitive
0.2.02021-05-263566Move from api.ratesapi.io/ to api.exchangeratesapi.io/. Add required field access_key to config.json.
0.1.02021-04-192942Implement Exchange API using the CDK