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
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"
}
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"
}]
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"
}