DEV Community: Rowcraft

UK company directors as clean JSON from Companies House: current or full history, no dates of birth

Rowcraft — Thu, 29 Oct 2026 20:00:36 +0000

Companies House has a good free API, but getting the directors of a list of companies means paging the officers endpoint 100 at a time, separating current from resigned officers, and dropping fields you probably should not store, such as dates of birth.

I added directors to my Apify tool for Companies House. You search companies by number, name, SIC code, status, location or incorporation date, switch on "Include officers", and each company row comes back with its officers. Disclosure: it is mine and it is paid, 3 USD per 1,000 companies; the officers are fields of the company row and cost nothing extra. It runs on your own free Companies House API key, which takes a few minutes to get on the Companies House developer hub.

What you get per company when officers are on:

officersActiveCount, officersResignedCount and officersTotal (Tesco PLC: 11 active, 63 resigned, 74 in total)
officers: name, role (director, secretary, LLP member, corporate director and the other roles), appointment and resignation dates, nationality, country of residence, occupation, and whether the officer is itself a company
current officers only (the default) or the full history, up to 500 officers per company

What is never returned: dates of birth (not even month and year), addresses, identity verification details and links to a person's other appointments. Persons with significant control and disqualifications are not requested at all. The register is public by law; the tool is meant for B2B work such as KYB checks, supplier due diligence and sales research, and any officer can ask for removal through the tool's Issues tab (handled within 14 days).

Example input:

{
  "apiKey": "YOUR_COMPANIES_HOUSE_API_KEY",
  "companyNumbers": ["00445790"],
  "includeOfficers": true,
  "officersStatus": "active",
  "maxOfficersPerCompany": 50
}

One officer as it comes back:

{ "name": "BETHELL, Melissa", "role": "Director", "roleCode": "director", "appointedOn": "2018-09-24", "resignedOn": null, "nationality": "British", "countryOfResidence": "United Kingdom", "occupation": null, "isCorporate": false }

Without officers, each row still has the company profile: status, type, incorporation date, SIC codes, registered office, and on request filing history, charges and insolvency. "Only new rows" plus a daily schedule gives you just the companies incorporated since the last run.

The tool: https://apify.com/rowcraft/uk-companies-house-scraper

Which other register would you want with directors in the same format?

Get the open jobs of any company from its website: Greenhouse, Lever, Ashby or Workday detected for you

Rowcraft — Thu, 29 Oct 2026 19:59:55 +0000

If you track hiring at a list of companies (for sales signals, market research or a niche job board), the hard part is not scraping. It is finding where each company keeps its jobs. Stripe is on Greenhouse, Ramp on Ashby, Palantir on Lever, Nvidia on Workday, and the board name is rarely the company name you have in your CRM.

I built an Apify tool that takes the list the way you already have it (websites, careers pages or plain company names) and returns every open job in one table. Disclosure: it is mine and it is paid, 3 USD per 1,000 job ads; the free monthly credit of an Apify account covers about 1,600.

How the detection works, the part I spent most time on:

A website: the tool reads at most 4 public pages of the site (the home page, the careers link it finds there, then /careers and /jobs), looks for links and embeds of nine career systems (Greenhouse, Lever, Ashby, Workday, Workable, Personio, Recruitee, Teamtailor, Gem) and reads the board it finds through that system's public job API. robots.txt is respected. A site behind an anti-bot wall is skipped, not forced, and the tool falls back to the company name.
A name: legal suffixes are dropped ("Stripe, Inc." becomes stripe), accents are normalised, and the joined and hyphenated forms are tried on each system.
Every input line ends up in a coverage report: matched by website, by name, or not found, with the reason and the names tried. Duplicates (stripe and stripe.com) are read once.

In my test on 12 real companies, 5 were found directly from their website (Notion, Linear, Figma, Palantir, bunq) and the rest by name (Stripe, Ramp, Deezer, Airbnb, Databricks, and GitLab after its site's bot wall). example.com was correctly reported as not found.

Example input:

{
  "companies": ["https://www.notion.so", "figma.com/careers", "linear.app", "Stripe, Inc.", "Hugging Face"],
  "maxItems": 100
}

Each row has the same columns whatever the system: title, company, locations, department, employment type, workplace type (remote, hybrid, on-site), salary range when the company publishes it, posting date, description and apply link. Turn on "only new rows" and schedule it daily to get just the jobs that appeared since the last run.

Real results, no account needed:

The tool: https://apify.com/rowcraft/career-site-jobs-scraper

What it does not do: LinkedIn, Indeed or other job boards (only the companies' own career systems), and no contact details: e-mails and phone numbers inside job texts are removed.

Which career system is missing for you? I add the ones that publish a public job API.

Look up companies across France, Norway, Poland and the UK in one run, with LEI and parent companies

Rowcraft — Sun, 25 Oct 2026 04:09:37 +0000

Company data in Europe is split across national registers that each speak their own format: Sirene in France, Brønnøysund in Norway, KRS in Poland, Companies House in the UK. If you have a list of suppliers or prospects from several countries, you end up with four lookups and four different column layouts.

I built an Apify tool that takes one list (names, websites, registry numbers or LEIs, one per line) and returns one flat row per company with the same columns whatever the country: legal form, status, founding date, activity code, registered office, website and VAT number when the register publishes them, plus the LEI and the direct and ultimate parent company from the GLEIF index. Disclosure: it is mine and it is paid, 1 USD per 1,000 profiles; the free monthly credit on Apify covers test runs.

How matching works, the part I spent most time on:

A registry number is recognised by its length and check digits (SIREN, Norwegian organisation number, KRS, Companies House number) and read directly. A number that fails its check digits is reported as invalid without a request.
A name is delivered only when a register name equals what you typed (legal-form words such as SA, ASA or Ltd are ignored). Close matches are delivered only if you ask for them, and the row says it is close.
A LEI leads back to the national register that holds the company and brings the parent companies with it.
Lines that match nothing, or only a person, are not charged and are listed with the reason in the run's coverage report.

Example input, five lines of four kinds:

{
  "companies": ["542051180", "923 609 016", "KRS 0000028860", "Equinor ASA", "https://www.orange.com"],
  "countries": ["FR", "NO", "PL", "GB"],
  "matchMode": "exact"
}

Each row has about 40 fields: identity (name, country, registry number and its type, the register, a row ID such as FR:542051180), legal form and status, the activity code with its classification (NAF, SN2007, PKD, UK SIC), employees and latest revenue where accounts are filed, registered office, website, VAT number, LEI and parents, and optionally a website profile (CMS, analytics, social profile links, SSL, name servers, mail provider). Real rows are on the example pages, no account needed:

Privacy by design: companies only. Sole traders and other natural persons are dropped at the source; directors, shareholders, e-mail addresses and phone numbers are never read.

Two limits worth knowing: the UK needs your own free Companies House API key, otherwise the UK is covered through the LEI index only; and the public APIs are called at one request per second per host, so a list of 10,000 lines takes a while.

Which other registers would make this useful for you? Germany and Spain are on my list, but I only add sources that publish company data openly, without a login or a paid contract.

Look up Brazilian companies by CNPJ, or find them by state, city and CNAE code

Rowcraft — Thu, 22 Oct 2026 21:19:20 +0000

Brazil has one of the richest public company registers, but getting it into a spreadsheet is awkward: the Receita Federal publishes monthly dumps of several gigabytes, and web lookups work one CNPJ at a time.

I built an Apify tool on top of the free community service minhareceita.org (with OpenCNPJ as a fallback for lookups). Disclosure: I made it and it is paid, 1 USD per 1,000 companies on the free plan, and the free monthly credit covers your first runs.

Two modes:

Lookup: paste CNPJ numbers (with or without dots) and get the register data back. A number with wrong check digits is reported without a request, and numbers that do not exist are not charged.
Search: states (UF), 7-digit CNAE activity codes, IBGE city codes, legal nature codes, opening date, active companies only, head offices only.

Example: listed software companies in São Paulo.

{
  "states": ["SP"],
  "activityCodes": ["6201501", "6202300", "6209100", "6311900"],
  "legalNatureCodes": ["2054", "2046"],
  "maxItems": 100
}

Each row: CNPJ, legal name, trade name, status and reason, main and secondary CNAE, legal nature, capital, size, address of the establishment, opening date. Real rows are on the example page, no account needed.

Privacy by design: no partners, no e-mail, no phone. Sole traders (MEI, "Empresário Individual") and other legal forms named after a person are skipped and never charged, because their register entry can carry the person's tax number.

Tip: name a legal nature such as 2054 (closed corporation) or 2046 (open corporation) in a search. Without it the tool also reads many sole-trader records only to skip them, which is slower.

Example page: https://apify.com/rowcraft/brazil-cnpj-companies-scraper/examples/listed-software-companies-sao-paulo-cnpj
Tool page: https://apify.com/rowcraft/brazil-cnpj-companies-scraper

Feedback and missing filters: the Issues tab of the tool, I answer within a day.

Get US federal contract opportunities as clean JSON, without a SAM.gov API key

Rowcraft — Thu, 22 Oct 2026 21:18:13 +0000

If you sell to the US government, you probably watch SAM.gov for new solicitations. The website is fine for browsing, but if you want the notices in a spreadsheet, a CRM or an alert script, you hit two walls: the official API needs a registered key with strict rate limits, and the daily extract is a 200 MB CSV with columns you have to decode.

I built a small tool that reads the official GSA Contract Opportunities extract (the one published on open.gsa.gov) and returns only the notices you filter for, as JSON or CSV. Disclosure: I made it and it is a paid tool on the Apify Store, 2 USD per 1,000 notices on the free plan, and the free monthly credit covers your first test runs.

What you can filter by: keywords (and keywords to exclude), NAICS and PSC codes, set-asides (small business, 8(a), HUBZone, SDVOSB and others), notice types, agencies, states, posting date, open notices only, award date and amount.

Example: open IT solicitations posted in the last 14 days.

{
  "naics": ["5415"],
  "noticeTypes": ["solicitation", "combined-synopsis-solicitation"],
  "openOnly": true,
  "publishedAfter": "14 days",
  "maxItems": 100
}

Each row has the title, notice type, agency, NAICS, set-aside, response deadline, posted date, place of performance, description and the link to the notice on SAM.gov. The first rows of a real run are on the example page, you can open it without an account.

What it does not do, on purpose: it does not return contact names, e-mails or phone numbers (the contact columns are never read, and e-mails and phones inside the description text are removed). It is for finding opportunities, not for building a contact list.

Try the example: https://apify.com/rowcraft/sam-gov-contract-opportunities-scraper/examples/open-it-solicitations-last-14-days
Tool page: https://apify.com/rowcraft/sam-gov-contract-opportunities-scraper

If a filter you need is missing, tell me in the comments or in the tool's Issues tab and I will look at it.