I’d like to search for companies using either the normal company search or the advanced company search API, but would like to filter the list to only those companies that have filed at least one set of iXBRL accounts.
Is there a way of doing this beyond doing the search, then for each result, getting the filing history for that company (filtering to category “accounts”), then for each filing history result, getting the document metadata? Happy to do it this way, but it uses an awful lot of my API request budget
Not from Companies House, but I don’t think there is a “search” way to do this with the API other than as you’ve described.
However there may be another way - and indeed you might not need the API at all, depending on exactly what you want to do.
The Companies House Accounts data provides “individual data files (instance documents) of company accounts filed electronically at Companies House. The data is provided in eXtensible Business Reporting Language (XBRL) format.” … “The individual filenames will identify the company number (e.g. 01234567) and balance sheet date (e.g. 31/12/2012). The file type indicates if it is iXBRL (html), XBRL (xml) or a ZIP (zip).”
Even if you aren’t actually interested in the actual data that will give you the company numbers.
Note this sounds like it will only cover at most year’s worth of filings - but I see that currently files are available back to 01/12/2023
