My hope was to massively reduce the data set returned, by requiring a partial match on the name. I wanted to bring back a list of companies that have MGCRM in the name using:
Yes, we tried the bulk data product as well, but it sadly won’t contain dissolved companies, which is simply insufficient for our use case.
We also tried to compute the dissolved companies ourselves by looking at diffs across subsequent bulk data exports. However, these are not kept historically so that’s not an option either.
Looking forward to this advanced search coming to the API in 2022, it’s absolutely essential.
After some investigation, I have discovered that there is an error in the documentation. The query parameter company_name has been changed to company_name_includes.
So sorry about this. I am trying to get the documentation corrected.
So a call to https://api.company-information.service.gov.uk/advanced-search/companies?company_name_includes=vodaphone
will get something like
{
:
:
“top_hit”: {
“company_name”: “VODAPHONE LIMITED”,
“company_number”: “02373469”,
“company_status”: “active”,
“company_type”: “ltd”,
“kind”: “search-results#company”,
“links”: {
“company_profile”: “/company/02373469”
},
“date_of_creation”: “1989-04-18”,
“registered_office_address”: {
“address_line_1”: “Vodafone House”,
“address_line_2”: “The Connection”,
“locality”: “Newbury”,
“postal_code”: “RG14 2FN”,
“region”: “Berkshire”
},
“sic_codes”: [“70100”]
},
“items”: [{
“company_name”: “VODAPHONE LIMITED”,
“company_number”: “02373469”,
“company_status”: “active”,
“company_type”: “ltd”,
“kind”: “search-results#company”,
“links”: {
“company_profile”: “/company/02373469”
},
“date_of_creation”: “1989-04-18”,
“registered_office_address”: {
“address_line_1”: “Vodafone House”,
“address_line_2”: “The Connection”,
“locality”: “Newbury”,
“postal_code”: “RG14 2FN”,
“region”: “Berkshire”
},
“sic_codes”: [“70100”]
}],
“kind”: “search#advanced-search”,
“hits”: 1
}
Thank you very much Mark - I was facing similar issues with the advanced search.
Can I reach you directly about another documentation issue related with the simple search?
The list of the possible values for the ‘restriction’ parameters and what are they meant for is not provided there. Can you please update the documentation there?
Carefully reading on the existing documentation only makes us guess two possible values:
the “active-companies” and “legally-equivalent-company-name”