# Company\_number returning null values

**URL:** <http://forum.companieshouse.gov.uk/t/company-number-returning-null-values/8256>\
**Category:** Data Issues\
**Created:** [July 29, 2024, 4:10pm UTC](http://forum.companieshouse.gov.uk/t/company-number-returning-null-values/8256 "2024-07-29T16:10:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![lfdatadevteam](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/l/cab0a1/32.png) [@lfdatadevteam](http://forum.companieshouse.gov.uk/u/lfdatadevteam)\
**Post date:** [July 29, 2024, 4:10pm UTC](http://forum.companieshouse.gov.uk/t/company-number-returning-null-values/8256/1 "2024-07-29T16:10:44Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![bchazalet](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/b/94ad74/32.png) [@bchazalet](http://forum.companieshouse.gov.uk/u/bchazalet)\
**Post date:** [July 31, 2024, 7:55am UTC](http://forum.companieshouse.gov.uk/t/company-number-returning-null-values/8256/2 "2024-07-31T07:55:19Z")

</div>

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:

```auto
{
    "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

```auto
{
    "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"
}

```

---

<div class="post-metadata">

**Author:** ![bchazalet](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/b/94ad74/32.png) [@bchazalet](http://forum.companieshouse.gov.uk/u/bchazalet)\
**Post date:** [July 31, 2024, 7:59am UTC](http://forum.companieshouse.gov.uk/t/company-number-returning-null-values/8256/3 "2024-07-31T07:59:19Z")

</div>

all occurences:

```auto
[{
  "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"
}]

```

---

<div class="post-metadata">

**Author:** ![lfdatadevteam](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/l/cab0a1/32.png) [@lfdatadevteam](http://forum.companieshouse.gov.uk/u/lfdatadevteam)\
**Post date:** [August 5, 2024, 9:50am UTC](http://forum.companieshouse.gov.uk/t/company-number-returning-null-values/8256/4 "2024-08-05T09:50:04Z")

</div>

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