Company_number returning null values

Data Issues
1

We have been receiving a number of null data.company_number values from the streaming api today. Looking at the documentation this is a required field. Is this meant to be nullable or is this an issue?

1 Like
2

We have seen this too. We’ve seen required fields not being present pretty much everywhere in the streaming api by now, but company_number is obviously something we rely on (i.e. a primary key or part of it in most of our tables), so that has had a much bigger impact. We have counted 26 occurences so far.

Some examples of events received in the company profile streaming endpoint:

{
    "data": {
        "etag": "bbab352f639bf833ef19942c51d1fabb1e9f3566",
        "links": {
            "officers": "/company/FC041694/officers"
        }
    },
    "event": {
        "published_at": "2024-07-29T14:30:04.426437+01:00",
        "timepoint": 81387158,
        "type": "changed"
    },
    "resource_id": "FC041694",
    "resource_kind": "company-profile",
    "resource_uri": "/company/FC041694"
}

and

{
    "data": {
        "etag": "d8c0af13d7a34942a7e271c31b58ab7653e0cafa",
        "links": {
            "officers": "/company/15862369/officers",
            "persons_with_significant_control": "/company/15862369/persons-with-significant-control",
            "registers": "/company/15862369/registers"
        }
    },
    "event": {
        "published_at": "2024-07-29T08:25:02",
        "timepoint": 81352240,
        "type": "changed"
    },
    "resource_id": "15862369",
    "resource_kind": "company-profile",
    "resource_uri": "/company/15862369"
}
3

all occurences:

[{
  "event_timepoint": "81387158",
  "resource_uri": "/company/FC041694"
}, {
  "event_timepoint": "81395517",
  "resource_uri": "/company/FC041696"
}, {
  "event_timepoint": "81352240",
  "resource_uri": "/company/15862369"
}, {
  "event_timepoint": "81352247",
  "resource_uri": "/company/15862369"
}, {
  "event_timepoint": "81387184",
  "resource_uri": "/company/15863763"
}, {
  "event_timepoint": "81387142",
  "resource_uri": "/company/15863763"
}, {
  "event_timepoint": "81409222",
  "resource_uri": "/company/15864629"
}, {
  "event_timepoint": "81377211",
  "resource_uri": "/company/OC453179"
}, {
  "event_timepoint": "81377200",
  "resource_uri": "/company/OC453179"
}, {
  "event_timepoint": "81368272",
  "resource_uri": "/company/SC817709"
}, {
  "event_timepoint": "81368236",
  "resource_uri": "/company/SC817709"
}, {
  "event_timepoint": "81368215",
  "resource_uri": "/company/SC817709"
}, {
  "event_timepoint": "81398059",
  "resource_uri": "/company/SC817825"
}, {
  "event_timepoint": "81398052",
  "resource_uri": "/company/SC817825"
}, {
  "event_timepoint": "81398055",
  "resource_uri": "/company/SC817825"
}, {
  "event_timepoint": "81390632",
  "resource_uri": "/company/SO308031"
}, {
  "event_timepoint": "81435711",
  "resource_uri": "/company/15865672"
}, {
  "event_timepoint": "81435694",
  "resource_uri": "/company/15865672"
}, {
  "event_timepoint": "81445493",
  "resource_uri": "/company/15866030"
}, {
  "event_timepoint": "81445501",
  "resource_uri": "/company/15866030"
}, {
  "event_timepoint": "81445498",
  "resource_uri": "/company/15866030"
}, {
  "event_timepoint": "81454878",
  "resource_uri": "/company/15866377"
}, {
  "event_timepoint": "81454942",
  "resource_uri": "/company/15866377"
}, {
  "event_timepoint": "81454895",
  "resource_uri": "/company/15866377"
}, {
  "event_timepoint": "81455968",
  "resource_uri": "/company/15866405"
}, {
  "event_timepoint": "81455981",
  "resource_uri": "/company/15866405"
}]
4

This is still happening today, is anyone looking into this yet? Here is the three examples we have seen so far today.

{
"data": {
	"company_number": null,
	"links": {
		"persons_with_significant_control": "/company/15876544/persons-with-significant-control",
		"registers": "/company/15876544/registers"
	}
},
"event": {
	"timepoint": 81676137,
	"type": "changed",
	"published_at": "2024-08-05T08:37:02"
},
"resource_kind": "company-profile",
"resource_uri": "/company/15876544",
"resource_id": "15876544"
},
{
"data": {
	"company_number": null,
	"etag": "c9007c6ddf67c28d37fe434d3411d97daa95dab6",
	"links": {
		"filing_history": "/company/15876544/filing-history",
		"persons_with_significant_control": "/company/15876544/persons-with-significant-control",
		"registers": "/company/15876544/registers"
	}
},
"event": {
	"timepoint": 81676139,
	"type": "changed",
	"published_at": "2024-08-05T08:37:02.496755+01:00"
},
"resource_kind": "company-profile",
"resource_uri": "/company/15876544",
"resource_id": "15876544"
},
{
"data": {
	"company_number": null,
	"etag": "b0488cd4d161a71f4b1ee03b5bfb1f8f170ad3b4",
	"links": {
		"filing_history": "/company/15876544/filing-history",
		"officers": "/company/15876544/officers",
		"persons_with_significant_control": "/company/15876544/persons-with-significant-control",
		"registers": "/company/15876544/registers"
	}
},
"event": {
	"timepoint": 81676141,
	"type": "changed",
	"published_at": "2024-08-05T08:37:02.639525+01:00"
},
"resource_kind": "company-profile",
"resource_uri": "/company/15876544",
"resource_id": "15876544"
}