Streaming api contains keys with null value?

API Issues
1

I encountered an issue with the Companies Data streaming API, timepoint 86626191.

The data returned for this timepoint has numerous keys mapped to null, see:

{
“data”: {
“etag”: “aace90428a8ebc19f61405f85bc0ab8cd1044c9b”,
“type”: “registered-overseas-entity”,
“links”: {
“self”: “/company/OE032045”,
“charges”: null,
“officers”: null,
“overseas”: null,
“registers”: null,
“exemptions”: null,
“insolvency”: null,
“filing_history”: “/company/OE032045/filing-history”,
“uk_establishments”: null,
“persons_with_significant_control”: null,
“persons_with_significant_control_statement”: null,
“persons_with_significant_control_statements”: null
},
“status”: null,
“subtype”: null,
“accounts”: null,
“can_file”: null,
“sic_codes”: null,
“has_charges”: false,
“company_name”: “ORITO CAPITAL PARTNERS 8 LLC”,
“jurisdiction”: “united-kingdom”,
“proof_status”: null,
“annual_return”: null,
“company_number”: “OE032045”,
“company_status”: “removed”,
“officer_summary”: null,
“service_address”: {
“po_box”: null,
“region”: “Delaware”,
“care_of”: null,
“country”: “United States”,
“premise”: null,
“locality”: “Dover”,
“premises”: null,
“test_data”: null,
“postal_code”: “19901”,
“care_of_name”: null,
“address_line_1”: “3500 3500 South Dupont Highway”,
“address_line_2”: “C/O Accumera Llc”
},
“date_of_creation”: “2024-01-10”,
“date_of_cessation”: null,
“date_of_dissolution”: null,
“has_been_liquidated”: null,
“company_status_detail”: null,
“has_super_secure_pscs”: false,
“branch_company_details”: null,
“confirmation_statement”: null,
“has_insolvency_history”: false,
“partial_data_available”: null,
“previous_company_names”: null,
“foreign_company_details”: {
“accounts”: null,
“legal_form”: “Limited Liability Company”,
“governed_by”: “Delaware”,
“company_type”: null,
“business_activity”: null,
“registration_number”: null,
“originating_registry”: {
“name”: null,
“country”: “UNITED STATES”
},
“accounting_requirement”: null,
“is_a_credit_financial_institution”: null
},
“corporate_annotation_type”: null,
“registered_office_address”: {
“po_box”: null,
“region”: “Delaware”,
“care_of”: null,
“country”: “United States”,
“premise”: null,
“locality”: “Dover”,
“premises”: null,
“test_data”: null,
“postal_code”: “19901”,
“care_of_name”: null,
“address_line_1”: “3500 3500 South Dupont Highway”,
“address_line_2”: “C/O Accumera Llc”
},
“last_full_members_list_date”: null,
“external_registration_number”: null,
“is_community_interest_company”: null,
“registered_office_is_in_dispute”: false,
“super_secure_managing_officer_count”: 0,
“undeliverable_registered_office_address”: false
},
“event”: {
“type”: “deleted”,
“timepoint”: 86626191,
“published_at”: “2024-11-05T12:17:35.379020Z”
},
“resource_id”: “OE032045”,
“resource_uri”: “/company/OE032045”,
“resource_kind”: “company-profile”
}

In all of the previous 40M+ timepoints, there is not a single null value. So it seems based on previous data we can expect there to be no nulls in the data provided, instead we simply don’t get entries for keys without any data.

This seems inconsistent at best. Is there an explanation for what happened here?

John

2

Thank you for reporting this. I have passed that onto be investigated.

3

This is strange. This one is the only occurrence we can find on the stream. Still investigating.

4

Well, it’s pretty easy to deal with on the user end…assuming one’s code chokes on the first encounter (mine did), it’s def not a lot of work to just ignore items with null values going forward. But I thought it was worth flagging since it was unexpected and therefore maybe your folks would want to know about it. Appreciate your attention!

1 Like
5

Not quite the same, but a related issue just came up.
Got this event on the companies stream at 2024-11-14T16:28:06.799Z:

{
  resource_kind: 'company-profile',
  resource_uri: '/company/FC041944',
  resource_id: 'FC041944',
  data: {
    etag: '205aa825f5bd78141f05dd5e2c3d0e6b3d00e7b7',
    links: {
      filing_history: '/company/FC041944/filing-history',
      officers: '/company/FC041944/officers',
      uk_establishments: '/company/FC041944/uk-establishments'
    }
  },
  event: {
    timepoint: 87142533,
    published_at: '2024-11-14T16:28:04.261345498Z',
    type: 'changed'
  }
}

which is missing any data in the data field, even companyNumber (which evidently exists due to the resource_id).

As the OP advises, my code choked when it encountered this (no company number in a company event).

Is this an anomaly or intended behaviour for foreign companies where limited data may be held?