ContextQMD
Back to Airbyte

Exchange Rates API

docs/integrations/sources/exchange-rates.md

2.0.010.9 KB
Original Source

Exchange Rates API

<HideInUI>

This page contains the setup guide and reference information for the Exchange Rates API source connector.

</HideInUI>

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

  1. Create an account with Exchange Rates API.
  2. 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:

  1. Limit of 1,000 API calls per month
  2. 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 is EUR. :::

Step 2: Set up the Exchange Rates connector in Airbyte

  1. Enter a Name for your source.
  2. Enter your API key as the access_key from the prerequisites.
  3. Enter the Start Date in YYYY-MM-DD format. The data added on and after this date will be replicated.
  4. (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.
  5. Click Set up source.
<HideInUI>

Supported sync modes

FeatureSupported?
Full Refresh SyncYes
Incremental - Append SyncYes
NamespacesNo

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

FieldAirbyte Type
Currencynumber
Datestring

Limitations & Troubleshooting

<details> <summary> Expand to see details about Exchange Rates API connector limitations and troubleshooting. </summary>

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 is EUR.
  • Check out common troubleshooting issues for the Exchange Rates API source connector on our Airbyte Forum.
</details>

Changelog

<details> <summary>Expand to review</summary>
VersionDatePull RequestSubject
1.4.462026-03-1074462Update dependencies
1.4.452026-02-2473899Update dependencies
1.4.442026-02-1773457Update dependencies
1.4.432026-02-1073010Update dependencies
1.4.422026-01-2071902Update dependencies
1.4.412026-01-1471608Update dependencies
1.4.402025-12-1870600Update dependencies
1.4.392025-11-2570166Update dependencies
1.4.382025-11-1869393Update dependencies
1.4.372025-10-2968716Update dependencies
1.4.362025-10-2168560Update dependencies
1.4.352025-10-1467766Update dependencies
1.4.342025-10-0767277Update dependencies
1.4.332025-09-3065808Update dependencies
1.4.322025-08-2365295Update dependencies
1.4.312025-08-0964761Update dependencies
1.4.302025-08-0264335Update dependencies
1.4.292025-07-2664014Update dependencies
1.4.282025-07-1963607Update dependencies
1.4.272025-07-1262957Update dependencies
1.4.262025-07-0562781Update dependencies
1.4.252025-06-2862431Update dependencies
1.4.242025-06-2161941Update dependencies
1.4.232025-06-1461277Update dependencies
1.4.222025-05-2460376Update dependencies
1.4.212025-05-1060018Update dependencies
1.4.202025-05-0358841Update dependencies
1.4.192025-04-1958307Update dependencies
1.4.182025-04-1257765Update dependencies
1.4.172025-04-0557201Update dependencies
1.4.162025-03-2956474Update dependencies
1.4.152025-03-2255944Update dependencies
1.4.142025-03-0855292Update dependencies
1.4.132025-03-0154926Update dependencies
1.4.122025-02-2254447Update dependencies
1.4.112025-02-1553740Update dependencies
1.4.102025-02-0853379Update dependencies
1.4.92025-02-0152798Update dependencies
1.4.82025-01-2551697Update dependencies
1.4.72025-01-1151108Update dependencies
1.4.62024-12-2849990Update dependencies
1.4.52024-12-1449478Update dependencies
1.4.42024-12-1249196Update dependencies
1.4.32024-10-2947813Update dependencies
1.4.22024-10-2847549Update dependencies
1.4.12024-08-1644196Bump source-declarative-manifest version
1.4.02024-08-1544150Refactor connector to manifest-only format
1.3.112024-08-1243761Update dependencies
1.3.102024-08-1043639Update dependencies
1.3.92024-08-0342659Update dependencies
1.3.82024-07-2042348Update dependencies
1.3.72024-07-1341157Update dependencies
1.3.62024-07-0640924Update dependencies
1.3.52024-06-2640508Update dependencies
1.3.42024-06-2340125Update dependencies
1.3.32024-05-3038543[autopull] base image + poetry + up_to_date
1.3.22024-06-0639250[autopull] Upgrade base image to v1.2.2
1.3.12024-05-3038135Make connector compatable with the builder
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
</details> </HideInUI>