API documentation

egenio FX serves official daily exchange rates from Latin American central banks and tax authorities, and the ECB, through one HTTPS API with consistent JSON.

Authentication

Send your key in the X-API-Key header:

curl -H "X-API-Key: fx_your_key_here" https://api.egenio.net/v1/rates

For a quick test in a browser you may add ?api_key=… to the address instead; prefer the header in integrations, because addresses can end up in logs and browser history. Keep keys secret: anyone with your key can use your quota. New free test keys are paused for now; keys you already have keep working.

curl https://api.egenio.net/v1/rates?currencies=MXN,BRL

Try it

Enter your API key, pick an endpoint and options, and send a real request. Your key stays in this page: it is sent only to api.egenio.net in the X-API-Key header and is not saved anywhere. Each request counts toward your limit. No key? Leave the field empty to use the no-key access level.

Latest & daily rates

All rates for one day: each currency's most recent official rate on or before date.

GET /v1/rates?date=2026-09-28

{
  "date": "2026-09-28",
  "base": "USD",
  "rates": [
    { "currency": "BRL", "rate": "5.30160", "rate_date": "2026-09-28", "source": "BCB" },
    { "currency": "MXN", "rate": "17.7100",  "rate_date": "2026-09-28", "source": "Banxico" }
  ]
}

rate_date is the day the rate was published for. It can be earlier than date on weekends and holidays (see below).

Some currencies: latest rate or a specific date

Add currencies with one code, or several separated by commas (currencies=MXN,BRL,COP). Leave out date for the latest rate, or add it for the rate in effect on that day (on a weekend or holiday, the previous business day's rate).

# Latest USD→MXN rate
curl -H "X-API-Key: fx_your_key_here" \
  "https://api.egenio.net/v1/rates?currencies=MXN"

# USD→MXN rate for 28 September 2026
curl -H "X-API-Key: fx_your_key_here" \
  "https://api.egenio.net/v1/rates?currencies=MXN&date=2026-09-28"

# Mexican peso, Brazilian real and Colombian peso for 28 September 2026
curl -H "X-API-Key: fx_your_key_here" \
  "https://api.egenio.net/v1/rates?currencies=MXN,BRL,COP&date=2026-09-28"

{
  "date": "2026-09-28",
  "base": "USD",
  "rates": [
    { "currency": "MXN", "rate": "17.7100", "rate_date": "2026-09-28", "source": "Banxico" }
  ]
}

With one currency, the rate is at rates[0].rate; with several, rates has one entry per currency, in alphabetical order. Other examples: euro to Brazilian real with base=EUR&currencies=BRL; for a quick look in a browser, https://api.egenio.net/v1/rates?currencies=MXN&api_key=fx_your_key_here.

In Power Automate: an HTTP action with method GET, the address above and the X-API-Key header; then use the expression body('HTTP')?['rates']?[0]?['rate'] wherever you need the rate (wrap it in float(…) for calculations).

In Excel: Data → From Web → Advanced, enter the address and add the header X-API-Key; Power Query turns the reply into a table.

History

One currency, one rate per published day, oldest first.

GET /v1/rates/MXN?from=2026-09-24&to=2026-09-30

{
  "base": "USD", "currency": "MXN", "from": "2026-09-24", "to": "2026-09-30",
  "rates": [
    { "date": "2026-09-24", "rate": "17.5030", "source": "Banxico" },
    …
  ]
}

Dynamics 365 Finance & Operations

Rows named like the Exchange rates data entity (ExchangeRates). EndDate is omitted: F&O sets it from the next rate's start date.

GET /v1/fo/exchange-rates?from=2026-09-28&to=2026-09-28&currencies=MXN&rate_type=Default

{
  "value": [{
    "RateTypeName": "Default", "FromCurrency": "USD", "ToCurrency": "MXN",
    "StartDate": "2026-09-28T00:00:00Z", "Rate": "17.7100", "ConversionFactor": "One"
  }]
}

With Power Automate

Download our sample solution and import it into the Power Platform environment linked to F&O. It contains one cloud flow that runs twice a day, reads the last 7 days of rates from egenio FX, skips the rates F&O already has, and creates the rest in the ExchangeRates entity. It signs in to F&O with the standard Fin & Ops Apps connector, so no Azure app registration is needed. If a run fails, it emails you which step failed and why; while you test, it can also email a summary after every successful run.

Download sample solution (.zip)

Before you import

1. Get an egenio FX API key (a free test key is fine to start).
2. Choose the F&O account the flow will work as: a user (ideally a service account) who may maintain exchange rates.
3. Make sure the exchange rate type (e.g. Default) and the currencies exist in F&O.
4. Pick the Office 365 mailbox that will send the flow's emails (a shared or service mailbox works well).

Import

1. In Power Apps → Solutions → Import solution, choose the downloaded zip.
2. When asked for connections, create or pick a Fin & Ops Apps (Dynamics 365) connection, signed in as that F&O account, and an Office 365 Outlook connection for that mailbox.
3. Fill in the environment variables when asked:

   Variable	Example
   egenio FX API key	fx_…
   FO environment URL	https://contoso.operations.dynamics.com
   Exchange rate type	Default
   Currencies	MXN,BRL,ARS,CLP,COP,PEN
   Notification email	[email protected] (several: separate with ;)
   Email on success	Yes while testing, No later (failures are always emailed)

4. Open the flow egenio FX - Import exchange rates into FO, run it once with Test → Manually, then turn it on. It is imported turned off.

The flow uses the premium HTTP action and the premium Fin & Ops Apps connector, so its owner needs a Power Automate premium license. Building it yourself instead? The steps are: Recurrence → HTTP GET /v1/fo/exchange-rates with the X-API-Key header → Parse JSON → Apply to each over value → Fin & Ops Apps Create record in ExchangeRates.

With Data management (CSV)

1. Download /v1/fo/exchange-rates?from=…&to=…&format=csv.
2. In F&O: Data management → Import, entity Exchange rates, source format CSV. Columns map automatically.
3. Dates are YYYY-MM-DD; if your source data format expects another date format, adjust it there.

Always test the import in a sandbox first.

Sources & conventions

Sources are checked every hour; recent days are re-checked so corrections are picked up. Rates are never computed or inverted: what you get is what the authority published.

Weekends & holidays

Most authorities publish nothing on weekends and holidays. /v1/rates then returns each currency's most recent rate (at most 10 days old) and shows its rate_date. This follows the usual rule (e.g. SUNAT's) of using the previous business day's rate. The history and F&O endpoints list only published days; F&O keeps each rate in effect until the next one.

Service endpoints

Two public addresses that need no API key, both plain text or JSON for tools rather than pages to read:

Errors

Errors return JSON: {"error": "explanation"}.

Limits

Access is free during testing. Each key has an access level with a monthly request limit and a history window:

Every response includes X-RateLimit-Limit and X-RateLimit-Remaining for the month (for the day, without a key). Separately, each client address may make up to 300 requests per minute, and addresses sending many invalid keys are paused for a minute.

FAQ