Issue with company_profile stream

API Issues
1

We have not received any company_profile messages since event_time_point 2022-10-31 06:30:02 UTC. The other streams that we collect are working as expected and we cannot see any issues with our company_profile collection logic.

Is this a known issue and is anyone else experiencing an interruption in this data stream?

Thanks
Lance

2 Likes
2

There are no issues with our companies stream.
I have just tested it myself and got data back that included the following…

{“resource_kind”:“company-profile”,“resource_uri”:"/company/13472625",“resource_id”:“13472625”,“data”:{“accounts”:{“accounting_reference_date”:{“day”:“30”,“month”:“06”},“last_accounts”:{“type”:“null”},“next_accounts”:{“due_on”:“2023-03-23”,“period_end_on”:“2022-06-30”,“period_start_on”:“2021-06-23”},“next_due”:“2023-03-23”,“next_made_up_to”:“2022-06-30”},“can_file”:true,“company_name”:“DOLLARBOATENG GROUP LIMITED”,“company_number”:“13472625”,“company_status”:“active”,“confirmation_statement”:{“last_made_up_to”:“2022-06-22”,“next_due”:“2023-07-06”,“next_made_up_to”:“2023-06-22”},“date_of_creation”:“2021-06-23”,“etag”:“e0ab7ea4c8d5f77c0cead38a6859c45cbef27a11”,“jurisdiction”:“england-wales”,“links”:{“filing_history”:"/company/13472625/filing-history",“officers”:"/company/13472625/officers",“persons_with_significant_control”:"/company/13472625/persons-with-significant-control",“self”:"/company/13472625"},“registered_office_address”:{“address_line_1”:“43 Whitehall Road”,“country”:“England”,“locality”:“Walsall”,“postal_code”:“WS1 4AR”},“sic_codes”:[“07290”,“09100”,“42220”,“73110”],“type”:“ltd”},“event”:{“timepoint”:52063920,“published_at”:“2022-11-04T14:05:03”,“type”:“changed”}}

3

we’ve identified the problem to be with this event:

"event":{"timepoint":51801959,"published_at":"2022-10-31T06:30:02.387131Z","type":"changed"}

The Zulu timezone in 2022-10-31T06:30:02.387131Z is not being accepted as part of a valid ISO format date and so our processes have been stuck on this since then. Most events coming from companies house don’t normally have that Z but for some reason this particular event did.

4

The Z at the end of a timestamp indicates that the timestamp is in the UTC time zone (eg GMT+00:00).

If you want to check the streaming API to see if its sending events, you can use https://companies.stream which I made for this purpose.

2 Likes
5

yeah, I know it means UTC but for some reason it’s not accepted as valid by python’s datetime.fromisoformat. We’ve worked around that since then.

1 Like