Tracking appointments between two dates and finding the officer id

[simon3]

Hi Community!

I would like keep check on any customers that appoint new PSCs or where PSC is no longer valid.

I’ve tried the following api, passing the registration number to return a list of officers…
GET https://api.company-information.service.gov.uk/company/{company_number}/officers

But the returned list of officers does not appear to contain the PSC_ID

There is a “person_number” but this number appears to be unique to the appointment and not unique to the officer.

And therefore I cannot use this value in the following api

GET https://api.company-information.service.gov.uk/company/{company_number}/persons-with-significant-control/individual/{psc_id}

Does anyone know if the CH api can be used to get PSC changes for passed registration numbers or if there is another way (without using a different paid-for service)

Thanks in advance!

[voracityemail]

Short: the PSC dataset and the Officers datasets are (as far as I know) completely independent - with no links between. No relationship (that we punters can find out) between an Officer ID and a PSC ID. (Again as far as I know this is because Companies House - by law - just record what people submit to them, and the forms don’t have an explicit link between officers and PSCs).

You can list all PSCs for a given company using the PSC list / PSC statements lists. (Note that even these sometimes - albeit rarely - have multiple entries for “the same” individual / entity - search this forum for info on that.)

It sounds like you might be better using the PSC feed from the Streaming API if you’re tracking changes. Depending on how many you want to follow you might populate your initial data by getting the PSC bulk data dump, then use the streaming API to keep that up-to-date.

The main (Public Data) API basically mirrors the flow of the Companies House search website.

[simon3]

Thanks for the response. I will look at the daily dump and work from that. Thanks for pointing out the hurdles too.

[simon3]

In the Streaming API i can’t see how to retrieve data that has changed. I don’t have a ‘timepoint’ to enter. If I run the call without a timepoint, I eventually just see a 504 gateway timeout.

I’ve started without any historic data (ie not imported the data dump) because ultimately I’m only interested in changes to PSCs going forward. I would like to enter a date range (e.g. all changes to PSCs between the last KYC check date (e.g. 1.1.24) and today.

And within the result set hopefully the company registration is available for each PSC so that I can then lookup the company (customer) and keep a record of important PSC changes.

Does nyone have any thoughts on the best approach here?

I can lookup by company registration number however with over 5000 customers, running this type of query is consuming a lot of calls for it to only return one or two results.

Thanks!

[voracityemail]

I don’t use the Streaming API but I would recommend the following unofficial guide:

https://chguide.co.uk/streams/

The same user has a live demo of a “stream monitor” (with source code) here:

https://companies.stream/

There are also many posts on how to get started / timepoints eg.:

Suggestion: put the timepoint on the download pages

The timepoint is sent with each event on the streaming APIs, so you don’t need a snapshot for that purpose. If you make a request to https://stream.companieshouse.gov.uk/charges for example, you will get charge events, each containing their timepoint. If you don’t specify a timepoint in the request, you will get the latest by default. You can then keep track of the timepoints in your database.

Stream API timepoint

Hi When you make a request for the first time do you need to use timepoint or this is requre when any other second request is made ? Do you have test timepoint to test small load when developing to test the responces? Regards

Streaming API Snapshot Timepoints

Hi, I have been trying to get the timepoints to work but it’s not working? e.g. I get an “Response status code 416 (Requested Range Not Satisfiable).” Has this now been implemented, if so what is the correct timepoint format and how long does the snapshot go back to? Example using Unix epoch time?: https://stream.companieshouse.gov.uk/companies?timepoint=1616067600 Thanks, Matt

How can I update my dataset with the streaming API

Hi there, I currently have a big dataset with 1,034,000 rows that contains the charges of the companies I have chosen. The attributes are: ChargeCode, CompanyName, CompanyNumber, DeliveredOn, Has_insolvency_history, accounts_overdue, Persons entitled, Director1, Director2, Director3, Director4. I have basically created this dataset with a combination of the bulk datasets available and the REST API by calling 3 endpoints (company, company/charges and officers). I am very interested on updatin…

Good luck.

[SmokeAndMirrors]

Hi simon3

As voracitymail commented, the PSC dataset and Officers datasets are completely independent.
However, it is relatively easy to fetch PSC changes (PSC name, appointment date, temination date, company number etc) realtime from the Companies House API. One way to do this is to:

1. Fetch the data using the streaming API “https://stream.companieshouse.gov.uk/filings”
2. Store the data in the database. This should include::
   date, category, description, type, timepoint, URI, datestamp, published_at, PSC_name, appointment_date, and termination_date
3. Extract the company number from the URI using a regular expression or similar method and use it to fetch the company name if necessary
4. Display and manipulate the data as desired.

I estimate that the whole process should take less than 5 minutes.

Good luck!