Joao Pedro Rosado

Pull CEIS and CNEP Brazil sanctions (Portal da Transparência / CGU) as delta-friendly JSON. CNPJ/CPF, sanction type, dates and authority — for KYC, AML, supplier due diligence and bid-desk screening.

Pull Brazil import/export statistics by NCM, country and period from the official Comex Stat / MDIC public API.

Filter the official public Receita Federal CSV of companies habilitadas to operate in foreign trade. No Siscomex credentials.

Lookup Brazil NCM / TIPI (Mercosur Common Nomenclature) codes and Portal Único public attributes from official downloadable JSON. Trade/customs classification without Siscomex Client credentials.

Fetch Brazilian public contracts (contratos públicos PNCP) with buyer, supplier CNPJ, vigência and BRL valorGlobal from the official PNCP API. Structured JSON for awarded-contract monitoring and spend analytics.

Monitor Brazilian public procurement tenders (licitações / editais / pregão) from PNCP — Portal Nacional de Contratações Públicas. Official public API → structured JSON for bid desks, GovTech, compliance and supplier intel.

Monitor public Siscomex import/export/systems news via official gov.br RSS — no login or credentials.

Fetch daily European Central Bank reference FX rates via the Frankfurter API (ECB data). Supports latest quotes, historical dates, and multi-currency targets. One Dataset row per rate quote.

Validate EU VAT identification numbers via the official European Commission VIES REST API. Returns validity, registered name/address when available, country code and raw VIES fields as structured JSON.

Screen company or individual names against the official World Bank Listing of Ineligible Firms and Individuals (JSON). Returns firm name, country, ineligibility from/to dates, grounds, and source URL. Includes World Bank debarments and cross-debarments from ADB, AfDB, EBRD and IDB.

Screen person or entity names against the official US Treasury OFAC Specially Designated Nationals (SDN) XML list. Downloads the official list once per run, filters locally (exact or contains), and returns uid, name, type, programs, remarks and source URL. Screening aid — not legal advice.

Search US FDA enforcement reports (recalls) via the official openFDA API for food, drug or device. Returns classification, status, product description, recalling firm, distribution pattern and report dates as structured Dataset rows.

Search Paraguay DNCP public procurement processes via the official Datos API v3 and return structured OCDS notice/contract rows (ocid, title, buyer, dates, value, status, source URL). Optional detail fetch of compiled releases.

Resolve Peppol participant IDs against the official Peppol Directory search API. Returns found/not found, entity names, country, websites, document types and metadata as structured JSON — one Dataset row per lookup.

Look up Harmonized Tariff Schedule (HTS) codes, product descriptions and duty rates from the official USITC HTS reststop API. Search by HTS number and/or keyword; returns structured JSON with general/special/other rates and a link to the public schedule.

Monitor TCU acórdãos (Tribunal de Contas da União) via official open data. Keyword search on titles/summaries with DOC/PDF links — structured JSON for legal, compliance and procurement-risk intel.