# Proposal to Strike Off Discrepancy **URL:** \ **Category:** Data Issues\ **Created:** [August 1, 2017, 8:18am UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260 "2017-08-01T08:18:16Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ian\_barker](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/i/ecc23a/32.png) [@ian\_barker](http://forum.companieshouse.gov.uk/u/ian_barker)\ **Post date:** [August 1, 2017, 8:18am UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260/1 "2017-08-01T08:18:16Z")
API doesn’t show that a Company is Proposal To Strike Off, where as the URI does Example: [http://data.companieshouse.gov.uk/doc/company/08622846](http://data.companieshouse.gov.uk/doc/company/08622846) Above URI link shows the company as Active - PTSO API returns “status”: “active”, ---
**Author:** ![frank](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/f/3d9bf3/32.png) [@frank](http://forum.companieshouse.gov.uk/u/frank)\ **Post date:** [August 1, 2017, 10:16am UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260/2 "2017-08-01T10:16:31Z")
The API is showing this correctly “company\_status”: “active” “company\_status\_detail”: “active-proposal-to-strike-off”, and the BETA site more clearly shows Company status Active — Active proposal to strike off Frank Murphy, StatBooks Ltd ---
**Author:** ![voracityemail](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/v/b77776/32.png) [@voracityemail](http://forum.companieshouse.gov.uk/u/voracityemail)\ **Post date:** [August 1, 2017, 12:40pm UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260/3 "2017-08-01T12:40:52Z")
As Frank said. It’s the “company\_status\_detail” field which has the information you’re after. Where were you looking? I checked Beta: > **[GRILL 65 LIMITED - Overview (free company information from Companies House)](https://find-and-update.company-information.service.gov.uk/company/08622846)** and API (via cURL): curl -u{MyApiKey}: “[https://api.companieshouse.gov.uk/company/08622846](https://api.companieshouse.gov.uk/company/08622846)” ---
**Author:** ![ian\_barker](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/i/ecc23a/32.png) [@ian\_barker](http://forum.companieshouse.gov.uk/u/ian_barker)\ **Post date:** [August 1, 2017, 6:09pm UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260/4 "2017-08-01T18:09:34Z")
Ah the guys have been referencing the status field, and not the detail field. Thanks! ---
**Author:** ![ian\_barker](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/i/ecc23a/32.png) [@ian\_barker](http://forum.companieshouse.gov.uk/u/ian_barker)\ **Post date:** [August 7, 2017, 1:47pm UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260/5 "2017-08-07T13:47:10Z")
The search API doesn’t show the “company\_status\_detail”, only the “company\_status” ---
**Author:** ![voracityemail](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/v/b77776/32.png) [@voracityemail](http://forum.companieshouse.gov.uk/u/voracityemail)\ **Post date:** [August 8, 2017, 9:01pm UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260/6 "2017-08-08T21:01:52Z")
Indeed. It’d be annoying if you wanted to use the search to pull out that. Maybe put in a improvement / change request with CH? You can get the info, anyway. There are already a few places where extra “categories” have been added or merged into existing fields (I’m thinking “community interest companies”). If you don’t need live data you can probably pull this out of the [data product](http://download.companieshouse.gov.uk/en_output.html). ---
**Author:** ![frank](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/f/3d9bf3/32.png) [@frank](http://forum.companieshouse.gov.uk/u/frank)\ **Post date:** [August 9, 2017, 10:34am UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260/7 "2017-08-09T10:34:24Z")
I suspect you have not fully grasped how this works. If you look at our entry > **[STATBOOKS LTD - Overview (free company information from Companies House)](https://find-and-update.company-information.service.gov.uk/company/08814113)** through the API there is no “company\_status\_detail”; our “company\_status” is Active with a “company\_status\_detail” of " " which does not give a return value because there is nothing to return. If you then compare with your original query for [http://beta.companieshouse.gov.uk/company/086228461](http://beta.companieshouse.gov.uk/company/086228461) then you get "company\_status"s and company\_status\_detail because there is detail present to return. I am sure a CH staff member will correct this if I am wrong but it sure works for us!! ---
**Author:** ![ian\_barker](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/i/ecc23a/32.png) [@ian\_barker](http://forum.companieshouse.gov.uk/u/ian_barker)\ **Post date:** [August 9, 2017, 12:58pm UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260/8 "2017-08-09T12:58:50Z")
> [@frank](#): > > I suspect you have not fully grasped how this works. > > If you look at our entry > > [STATBOOKS LTD overview - Find and update company information - GOV.UK](https://beta.companieshouse.gov.uk/company/08814113) [1] > > through the API there is no “company\_status\_detail”; our “company\_status” is Active with a “company\_status\_detail” of " " which does not give a return value because there is nothing to return. > > If you then compare with your original query for > > [https://beta.companieshouse.gov.uk/company/086228461](https://beta.companieshouse.gov.uk/company/086228461) {1] > > then you get "company\_status"s and company\_status\_detail because there is detail present to return. > > I am sure a CH staff member will correct this if I am wrong but it sure works for us!! Hi - the field you’re talking about isn’t available on the search results, it requires an extra query to find it. Hence the confusion ---
**Author:** ![frank](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/f/3d9bf3/32.png) [@frank](http://forum.companieshouse.gov.uk/u/frank)\ **Post date:** [August 9, 2017, 4:45pm UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260/9 "2017-08-09T16:45:48Z")
I am just cannot replicate your problem - an API call on for the Company Profile for 086228461 as follows [https://api.companieshouse.gov.uk/company/{company\_number}](https://api.companieshouse.gov.uk/company/%7Bcompany_number%7D) returns both company\_status and company\_status\_detail in the result regardless of whether I use the Try It page on this hub or through our own front end. For the vast majority of Companies company\_status\_detail is not appropriate and therefore there is no data that can be returned on a call. ---
**Author:** ![voracityemail](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/v/b77776/32.png) [@voracityemail](http://forum.companieshouse.gov.uk/u/voracityemail)\ **Post date:** [August 9, 2017, 6:38pm UTC](http://forum.companieshouse.gov.uk/t/proposal-to-strike-off-discrepancy/1260/10 "2017-08-09T18:38:07Z")
An [X-Y misunderstanding](http://xyproblem.info/) here? Up to @ian_barker to confirm but it seems what he is trying to do is: > “how can I _search_ for / exclude companies by Proposal To Strike Off” (or some similar category) or > “why doesn’t _company search_ show **X** status?” (where **X** is PTSO etc.). So he’s found an example in Beta, and looked for the “status” (e.g. [https://api.companieshouse.gov.uk/company/08622846](https://api.companieshouse.gov.uk/company/08622846)) - but “status” didn’t have the value he saw. You gave a correct answer - but this hasn’t helped him since he then says: > The search API doesn’t show the “company\_status\_detail”, only the “company\_status” And then > field you’re talking about isn’t available on the search results E.g. he’s now expecting to get this status (or the “company\_status\_detail”) from **search** e.g. [https://api.companieshouse.gov.uk/search/companies?q](https://api.companieshouse.gov.uk/search/companies?q)… …so round we go! The canonical response is to yell at the original questioner “WHAT IS IT YOU ARE REALLY TRYING TO DO?”. Or (more politely but less helpfully) suggest they open a new thread since their original question was indeed answered. If Ian is trying to use the search / company search request to look for company status which involves PTSO or stuff that isn’t in the [company\_status](https://github.com/companieshouse/api-enumerations/blob/develop/constants.yml) field …the answer is my previous one e.g. probably the search won’t do what you want ([read the spec](https://developer.companieshouse.gov.uk/api/docs/search-overview/CompanySearch-resource.html) / search this forum to check). …as Frank said originally the “company\_status\_detail” field is available only when you do a company profile query (not a search) and only on companies to which one of the values which go in the field apply. …So as @ian_barker says “it requires an extra query to find it” if you’ve located the company via the search request because he’ll then want to call company profile to check if the PTSO applies. Again Ian might be able to do the search on offline data via the [data product](http://download.companieshouse.gov.uk/en_output.html).