Skip to main content

Open Exchange Rates

Overview

The integration pulls data from Open Exchange Rates

Output schema

It contains one stream: open_exchange_rates

Each record in the stream contains many fields:

  • The timestamp of the record
  • Base currency
  • The conversion rates from the base currency to the target currency

Data type mapping

Currencies are number and the date is a string.

Features

FeatureSupported?
Full Refresh SyncYes
Incremental - Append SyncYes
NamespacesNo

Getting started

Requirements

  • App ID

Setup guide

In order to get an app_id please go to this page and follow the steps needed. After registration and login you will see your app_id, also you may find it here.

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 USD.

Reference

Config fields reference

Field
Type
Property name
string
app_id
string
start_date
string
base

Changelog

Expand to review
VersionDatePull RequestSubject
0.2.132024-07-2042352Update dependencies
0.2.122024-07-1341775Update dependencies
0.2.112024-07-1041576Update dependencies
0.2.102024-07-0941149Update dependencies
0.2.92024-07-0640857Update dependencies
0.2.82024-06-2540300Update dependencies
0.2.72024-06-2139922Update dependencies
0.2.62024-06-0439028[autopull] Upgrade base image to v1.2.1
0.2.52024-05-1438141Make connector compatable with builder
0.2.42024-04-1937208Updating to 0.80.0 CDK
0.2.32024-04-1837208Manage dependencies with Poetry.
0.2.22024-04-1537208Base image migration: remove Dockerfile and use the python-connector-base image
0.2.12024-04-1237208schema descriptions
0.2.02023-10-0330983Migrate to low code
0.1.02022-11-1519436Created CDK native Open Exchange Rates connector