Exchange Rates API
This page contains the setup guide and reference information for the Exchange Rates API source connector.
Overview
The Exchange Rates API integration is a toy integration to demonstrate how Airbyte works with a very simple source.
Prerequisites
- Exchange Rates API account
- API Access Key
Setup Guide
Step 1: Set up Exchange Rates API
- Create an account with Exchange Rates API.
- Navigate to the Exchange Rates API Dashboard to find your
API Access Key
.
note
If you have a free
subscription plan, you will have two limitations to the plan:
- Limit of 1,000 API calls per month
- You won't be able to specify the
base
parameter, meaning that you will be only be allowed to use the default base value which isEUR
.
Step 2: Set up the Exchange Rates connector in Airbyte
- Enter a Name for your source.
- Enter your API key as the
access_key
from the prerequisites. - Enter the Start Date in YYYY-MM-DD format. The data added on and after this date will be replicated.
- (Optional) Enter a base currency. For those on the free plan,
EUR
is the only option available. If none are specified,EUR
will be used. - Click Set up source.
Supported sync modes
Feature | Supported? |
---|---|
Full Refresh Sync | Yes |
Incremental - Append Sync | Yes |
Namespaces | No |
Supported streams
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 map
Field | Airbyte Type |
---|---|
Currency | number |
Date | string |
Limitations & Troubleshooting
Expand to see details about Exchange Rates API connector limitations and troubleshooting.
Connector limitations
Rate limiting
The Exchange Rates API has rate limits that vary per pricing plan. The free plan is subject to rate limiting of 1,000 requests per month. Review the Exchange Rates API Pricing Plans for more information.
Troubleshooting
- With the free plan, you won't be able to specify the
base
parameter, meaning that you will be only be allowed to use the default base value which isEUR
. - Check out common troubleshooting issues for the Exchange Rates API source connector on our Airbyte Forum.
Changelog
Expand to review
Version | Date | Pull Request | Subject |
---|---|---|---|
1.4.2 | 2024-10-28 | 47549 | Update dependencies |
1.4.1 | 2024-08-16 | 44196 | Bump source-declarative-manifest version |
1.4.0 | 2024-08-15 | 44150 | Refactor connector to manifest-only format |
1.3.11 | 2024-08-12 | 43761 | Update dependencies |
1.3.10 | 2024-08-10 | 43639 | Update dependencies |
1.3.9 | 2024-08-03 | 42659 | Update dependencies |
1.3.8 | 2024-07-20 | 42348 | Update dependencies |
1.3.7 | 2024-07-13 | 41157 | Update dependencies |
1.3.6 | 2024-07-06 | 40924 | Update dependencies |
1.3.5 | 2024-06-26 | 40508 | Update dependencies |
1.3.4 | 2024-06-23 | 40125 | Update dependencies |
1.3.3 | 2024-05-30 | 38543 | [autopull] base image + poetry + up_to_date |
1.3.2 | 2024-06-06 | 39250 | [autopull] Upgrade base image to v1.2.2 |
1.3.1 | 2024-05-30 | 38135 | Make connector compatable with the builder |
1.3.0 | 2023-08-25 | 29299 | Migrate to low-code |
1.2.9 | 2023-08-15 | 23000 | Fix schema and tests |
1.2.8 | 2023-02-14 | 23000 | Specified date formatting in specification |
1.2.7 | 2022-10-31 | 18726 | Fix handling error during check connection |
1.2.6 | 2022-08-23 | 15884 | Migrated to new API Layer endpoint |
0.2.6 | 2022-04-20 | 12230 | Update connector to use a spec.yaml |
0.2.5 | 2021-11-12 | 7936 | Add ignore_weekends boolean option |
0.2.4 | 2021-11-08 | 7499 | Remove base-python dependencies |
0.2.3 | 2021-06-06 | 3973 | Add AIRBYTE_ENTRYPOINT for kubernetes support |
0.2.2 | 2021-05-28 | 3677 | Adding clearer error message when a currency isn't supported. access_key field in spec.json was marked as sensitive |
0.2.0 | 2021-05-26 | 3566 | Move from api.ratesapi.io/ to api.exchangeratesapi.io/ . Add required field access_key to config.json . |
0.1.0 | 2021-04-19 | 2942 | Implement Exchange API using the CDK |