How do I get fund or ETF data by ISIN in n8n?

What you need

• An API key from fundfactsapi.com/signup. The Free plan is 15 lookups a month and asks for no card. Keys start with ffk_.
• The ISIN of the share class you want. Every share class has its own ISIN; GET /search?q= turns a name into ISINs and is free.
• An HTTP Request node is all it takes; the example below is a workflow you can paste into n8n (Ctrl/Cmd+V on the canvas). Add a Header Auth credential with name Authorization and value Bearer ffk_....

The code

json
{
  "nodes": [
    {
      "parameters": {},
      "name": "Manual Trigger",
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [0, 0]
    },
    {
      "parameters": {
        "url": "=https://fundfactsapi.com/api/v1/funds/{{ $json.isin || 'IE00B4L5Y983' }}",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "options": { "timeout": 300000 }
      },
      "name": "FundFacts lookup",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [260, 0],
      "credentials": { "httpHeaderAuth": { "name": "FundFacts API" } }
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            { "name": "name", "value": "={{ $json.name }}", "type": "string" },
            { "name": "ter", "value": "={{ $json.data.headlineMetrics.ter }}", "type": "string" },
            { "name": "risk", "value": "={{ $json.data.riskRating }}", "type": "number" },
            { "name": "topHolding", "value": "={{ $json.data.topHoldings[0].name }}", "type": "string" },
            { "name": "asOf", "value": "={{ $json.data.dataAsOf }}", "type": "string" }
          ]
        }
      },
      "name": "Pick fields",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [520, 0]
    }
  ],
  "connections": {
    "Manual Trigger": { "main": [[{ "node": "FundFacts lookup", "type": "main", "index": 0 }]] },
    "FundFacts lookup": { "main": [[{ "node": "Pick fields", "type": "main", "index": 0 }]] }
  }
}

What comes back

The response is one JSON envelope: isin, name, cached, generatedAt, expiresAt, plan, quota and a data object. Inside data you get keyFacts (asset class, currency, fund size, inception date, distribution policy, number of holdings), headlineMetrics (TER, AUM, 3-year volatility and Sharpe, yield to maturity and duration for bond funds), riskRating (the 1–7 KID indicator), profile (a rule-based classification: kind, category, risk band, region focus, sector tilt), topHoldings, sector, geography, region, assetAllocation, creditQuality, maturity, calendarReturns, annualisedReturns, cumulativePerformance, indexedPerformance, metrics (max drawdown, P/E, income yield…), sfdrArticle, costs (PRIIPs entry, exit, ongoing, transaction and performance fees, reduction in yield) and dataAsOf, the date of the underlying figures.

Money and percentages arrive as the fund house prints them, as strings such as "0.20%" or "USD 151.7bn". Breakdown weights and return series are plain numbers in percent. Fields that do not apply to the fund's asset class are empty strings, null or empty arrays, never missing keys; treat empty as "not disclosed", not as zero.

A trimmed example for iShares Core MSCI World UCITS ETF (IE00B4L5Y983):

json
{
  "isin": "IE00B4L5Y983",
  "name": "iShares Core MSCI World UCITS ETF",
  "cached": true,
  "expiresAt": "2026-09-13T06:00:00.000Z",
  "data": {
    "keyFacts": { "assetClass": "Equities", "currency": "USD", "aum": "USD 151.7bn", "inception": "2009-09-25", "distribution": "Accumulating", "holdings": 1253 },
    "headlineMetrics": { "ter": "0.20%", "volatility3y": "11.8%", "sharpe3y": "1.68" },
    "riskRating": 6,
    "profile": { "kind": "equity", "category": "Global Equity", "riskBand": "high", "regionFocus": "Global", "sectorTilt": "Broad" },
    "topHoldings": [ { "name": "NVIDIA", "weight": 5.48 }, { "name": "APPLE", "weight": 5.24 } ],
    "sector": [ { "label": "Information Technology", "weight": 29.8 }, { "label": "Financials", "weight": 16.46 } ],
    "geography": [ { "label": "United States", "weight": 72.07 }, { "label": "Japan", "weight": 5.85 } ],
    "calendarReturns": { "years": ["2023", "2024", "2025"], "fund": [23.9, 18.7, 21.2], "benchmark": [23.8, 18.7, 21.1] },
    "metrics": { "maxDrawdown": "-16.5%" },
    "dataAsOf": "2026-09-01"
  }
}

Things to know before shipping

First call is slow, later calls are fast. A fund nobody has requested in the last 24 hours is loaded on demand from the documents the fund house publishes. That first call takes 15 seconds to about 3 minutes; set your client timeout to 300 seconds and do not fire a second request for the same ISIN while the first is running. Every later call within 24 hours returns from the store in well under a second with cached: true.

Requests are counted per ISIN. One request is counted per ISIN answered. X-RateLimit-Remaining on every response tells you how many are left this month; a 429 rate_limited response carries Retry-After. Search and /me are free. Cache payloads by ISIN until expiresAt and you will rarely spend more than one request per fund per day.

Batch when you have a list. POST /funds with { "isins": [...], "wait": true } answers up to 10 ISINs per call on Starter, 50 on Pro and 200 on Scale. ISINs still loading come back with status: "pending"; send them again a minute later.

Not every ISIN is a fund. A stock, bond or index ISIN returns 404 fund_not_found. Validate the format first (12 characters, Luhn check digit) so a typo does not spend a request; the ISIN validator shows the rule.

Show the as-of date. data.dataAsOf is the date printed on the fund's documents. Display it next to any figure.

Going further

• Endpoints: batch, search, portfolio look-through, holdings overlap, factsheets, SCPI.
• Field reference: every key of data with type and example.
• OpenAPI 3.1 spec to generate a client in any language.
• AI agents & MCP if a coding agent is writing this code for you.