Download the latest GLEIF Golden Copy full file from https://www.gleif.org/en/lei-data/gleif-golden-copy/download-the-golden-copy#/; files are published daily in CSV and XML formats
Unzip the LEI-CDF v3.1 XML or CSV file; for CSV, the columns include LEI, Entity.LegalName, Entity.LegalAddress.CountryCode, Entity.EntityStatus, and Registration.RegistrationStatus
Load the dataset into a database table (PostgreSQL, BigQuery, etc.) indexed on the LEI column for sub-millisecond lookups
For each entity in your counterparty list, look up LEI in the local database; flag records where Entity.EntityStatus != 'ACTIVE' or Registration.RegistrationStatus == 'LAPSED'
Schedule a nightly ETL job to re-download and reload the Golden Copy to keep the local database current; GLEIF publishes a delta file for incremental updates
Supplement with real-time GLEIF API calls only for newly encountered LEIs that may not yet be in the last daily snapshot
Known gotchas
The full Golden Copy ZIP file is several hundred megabytes uncompressed; ensure your ETL pipeline can handle the download and parse time within your nightly window
GLEIF publishes the Golden Copy once per day; entities whose LEI status changed intraday will not be reflected until the next publication — for real-time compliance checks, always fall back to the GLEIF API
The CSV format uses semicolons as delimiters in some versions; confirm the delimiter from the file header before parsing or use the XML format for unambiguous field boundaries
Give your agent this knowledge — and 200+ more routes
One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp