Open Exchange Rates
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Open Exchange Rates to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Enter your Open Exchange Rates App ID to pull foreign-exchange reference rates into the PostHog Data warehouse.
Find your App ID in your Open Exchange Rates dashboard.
The free plan is restricted to the USD base currency — a custom base currency requires a paid plan. The historical table walks one request per day from the start date, so a large backfill can use a lot of your monthly request quota.
Configuration
| Option | Type | Required |
|---|---|---|
App ID | password | Yes |
Base currency | text | No |
Start date (historical backfill) | text | No |
Linking Open Exchange Rates to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Open Exchange Rates
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
currencies | All currencies the API supports, as {code, name} rows. Full refresh only. | Full refresh | — | — |
latest | Latest exchange rate per currency against the base currency. Full refresh only. | Full refresh | — | — |
historical | Daily historical rates per currency, one request per day (walked from the start date). Supports incremental sync on the value date. | Incremental, Full refresh | date | — |
usage | Your Open Exchange Rates plan and current request usage, as a single row. Full refresh only. | Full refresh | — | — |