Currency & Exchange Rates
Synchronisation scope
Exchange rates (ECB)
ECB → Younium
Scheduled, at most daily; or on demand from the integration settings, optionally for a historical date range
Exchange rates (OANDA)
OANDA → Younium
On demand from the integration settings
Exchange rates (Sveriges Riksbank)
Sveriges Riksbank → Younium
Scheduled, at most every 30 minutes; or on demand from the integration settings
Not in scope: scheduled import from OANDA, export of rates from Younium.
Overview
Younium imports foreign exchange rates into CurrencyExchangeRate records for use in billing, invoicing, and base-currency conversion. Three providers are available: European Central Bank (ECB), OANDA, and Sveriges Riksbank. Each writes rates from foreign currencies to the legal entity base currency (ECB and OANDA for any configured base; Riksbanken requires SEK). Rates can be imported one at a time or in bulk, and optionally backfilled over a historical date range.
European Central Bank (ECB)
Overview
Younium downloads the daily euro reference rates published by the ECB and, when your base currency is not EUR, derives the cross rates from them.
Data source
Series template
https://data-api.ecb.europa.eu/service/data/EXR/D.{currencyFrom}.EUR.SP00.A
Query
startPeriod, endPeriod, format=csvdata
Default window
Last 7 days through today if dates omitted
Single-date mode
When either date omitted, only latest observation per currency
Rate mapping (ECB → Younium)
ECB CSV field (parsed)
Younium CurrencyExchangeRate
Column date
EffectiveFromDate
Foreign currency code
FromCurrency (tenant currency entity)
Base currency
ToCurrency (legal entity base)
Computed rate vs EUR
Rate (cross via EUR when base ≠ EUR)
Cross logic: if currencyFrom == EUR, invert latest EUR→target; else divide foreign/EUR series element-wise by base/EUR series for matching dates.
Import behaviour
Explicit from/to dates
addHistoricalExchangeRates = true
Default/latest only
addHistoricalExchangeRates = false
Per-currency failures are collected; partial success sets ImportMessage with joined errors.
Settings
ExchangeRateImport
Last run overall success flag
LastExchangeRateImport
UTC timestamp
LastExchangeRateImportCount
Count imported
ImportMessage
Partial failure summary or null
Scheduled job
ImportECBRatesJob — European Central Bank exchange rates job (minimum daily interval in job configuration).
OANDA
Overview
OANDA rates are fetched from the Rates API v2 spot endpoint, using an API key you store against the integration.
Authentication
OandaSettings.ApiKey
api_key query parameter
Validation request
GET .../rates/spot.json?api_key={key}&base=USD"e=SEK
ApiKeyValid
Set true on HTTP 200 parse success
ValidateApiKey persists key and clears ActivationErrorMessage on success.
Sandbox vs. Production
Single public endpoint host: https://web-services.oanda.com/rates/api/v2/ (no separate sandbox URL in code).
Sync workflow
SyncExchangeRates:
Base currency from
entityContext.BaseCurrency().Build query with
&base={eachForeignCode}and"e={baseCode}.For each quote in response
quotesarray:
OANDA JSON field
Younium CurrencyExchangeRate
base_currency
FromCurrencyId (match code)
ask
Rate
Current date/time
EffectiveFromDate (DateTime.Now)
Base currency id
ToCurrencyId
A rate that overlaps an existing interval for the same currency pair is not imported, and the conflict is reported on the import result.
Settings
ApiKey
Stored API key
ApiKeyValid
Activation flag
ExchaneRateSync
Last sync succeeded (typo preserved in code)
LastExchangeRateSync
UTC timestamp
LastExchangeRateSyncCount
Rates created
ActivationErrorMessage
Auth or per-rate errors
Deactivate removes settings row.
Sveriges Riksbank
Overview
Riksbank rates are imported from the Riksbank API as observation series, grouped by series, and are always quoted against SEK.
Eligibility
Base currency must be SEK
Otherwise SyncMessage = “Riksbanken can only synchronize with SEK as base currency.”, sync flag false, count 0
Observation window
Never synced (LastExchangeRateSync min)
One month ago
Prior sync exists
Last sync date (yyyy-MM-dd)
Series filtered: SeriesId prefix matches base currency code, series not closed, ObservationMaxDate ≥ from date.
Rate mapping (Riksbanken → Younium)
Riksbanken observation
Younium CurrencyExchangeRate
Series currency (from series id)
FromCurrency
SEK base
ToCurrency
Observation date
EffectiveFromDate
Observation value
The imported rate
Settings
ExchaneRateSync
Combined success across groups
LastExchangeRateSync
Timestamp (always updated)
LastExchangeRateSyncCount
Incremented per series processed
SyncMessage
Errors or informational text
Shared exchange rate semantics
Direction
Foreign currency → base currency
Duplicate intervals
Create may return null (“rate exist in another interval”)
Historical ECB
Bulk ImportExchangeRates with historical flag
ERP imports
NetSuite, Fortnox, Exact, etc. have separate jobs — not covered in this article
Last updated
Was this helpful?