topic Re: Can't set integer to null with Feature Service REST update in ArcGIS Enterprise Questions

Can't set integer to null with Feature Service REST update

Anonymous User — Fri, 07 Sep 2012 14:18:49 GMT

Original User: oppedahl

I have a feature class published to a Feature Service with one of its attributes a nullable integer with no default value defined. I'm trying to edit the attribute with the REST API's Update operation. It works if I set it to a number, but saving null doesn't work. There's no error--the call goes through fine--but the value remains unchanged. Is it not allowed to set a numeric field to null once it's been set to something else? I can set it to null just fine in ArcMap. Here's a snippet of the JSON I'm sending to the update:

[
{
   "attributes": {
    "OBJECTID_1": 1234,
    "AnInt": null,
   }
}
]

Re: Can't set integer to null with Feature Service REST update

Anonymous User — Tue, 11 Sep 2012 18:06:03 GMT

Original User: oppedahl

Bump. Anyone from ESRI? I can blank out a string field by setting it to an empty string, but how do I blank out other data types since null appears to be ignored?

Re: Can't set integer to null with Feature Service REST update

JayPaige — Thu, 13 Sep 2012 20:49:15 GMT

Ditto. I am unable to set integers to null since null parameters appear to be ignored.

Below is my json (captured directly by Fiddler), and I am unable to update the fields HabitGroup and PlantCount to null. As you can see, they are included in the json.

updates=[{"geometry":null,"attributes":{"OBJECTID":78433,"PlantingNumber":"2012-0698-1","TaxonName":"Boltonia asteroides 'Pink Beauty' ","PrimaryCommonName":"false aster","GridCoordinates":null,"HabitGroup":null,"Honoree":null,"PlantCount":null,"GardenArea":"KCLA","GardenBed":"","created_user":null,"last_edited_user":null,"created_date":null,"last_edited_date":null}}]&f=json

Re: Can't set integer to null with Feature Service REST update

Anonymous User — Thu, 20 Sep 2012 13:29:08 GMT

Original User: oppedahl

Help ESRI!

Re: Can't set integer to null with Feature Service REST update

NilsRydh — Sat, 11 Dec 2021 18:57:48 GMT

I'm having the same problem with fields of the type 'date'.
If I send this JSON:

"Systime_from": 1195826644000,
"Systime_to": null

These are the field definitions:

Systime_from ( type: esriFieldTypeDate , alias: Systime_from , editable: true , nullable: false , length: 36 )
Systime_to ( type: esriFieldTypeDate , alias: Systime_to , editable: true , nullable: true , length: 36 )

The 'Systime_to' will be set to the Jan 1, 1970 in the database, so it seems like it is treated as '0' and then parsed to a date.
If I omit this attribute in the request, the attribute is not updated.

It looks like the same issue, as the datetime here is also an integer.

Is this a bug, or what is the correct way to update an attribute to NULL?

Re: Can't set integer to null with Feature Service REST update

Anonymous User — Mon, 01 Oct 2012 12:30:57 GMT

Original User: KG22

I am experiencing similar

Re: Can't set integer to null with Feature Service REST update

Anonymous User — Tue, 02 Oct 2012 14:40:50 GMT

Original User: oppedahl

This is still a breaking issue for our application, and there doesn't seem to be a workaround. Are we missing something or is this a bug in the REST service?

Re: Can't set integer to null with Feature Service REST update

NilsRydh — Tue, 02 Oct 2012 18:45:28 GMT

Does anybody know if this has been reported to the secret Esri bug database?

Re: Can't set integer to null with Feature Service REST update

Anonymous User — Tue, 02 Oct 2012 19:17:24 GMT

Original User: kpeter

It would be best if you contacted Esri Support. One of our engineers in development just tried this and was not able to replicate the problem. We'd need to know all the details (versions of software used, database...) to truly replicate and debug, so Support is the place to collect this information and get the ball rolling.

Re: Can't set integer to null with Feature Service REST update

GaryMacDougall — Tue, 02 Oct 2012 22:04:40 GMT

One thing to check is the server log. It may have more detailed information on why you are getting an error.

thanks
Gary

Re: Can't set integer to null with Feature Service REST update

Anonymous User — Tue, 23 Oct 2012 11:45:18 GMT

Original User: oppedahl

This has been confirmed as a bug by ESRI: #NIM085862 Using REST to setting a feature service feature value to null returns success message but does not modify value.

Re: Can't set integer to null with Feature Service REST update

KevinGooss — Tue, 23 Oct 2012 12:40:21 GMT

Ugh. Not good news. I wonder if they stuck the fix in the next sp. which is supposed to be released in October although we only have one week left.

Re: Can't set integer to null with Feature Service REST update

DaleGeo24 — Tue, 13 Feb 2024 11:02:44 GMT

Massive stretch here given the time passed... Has anyone seen this issue reappear since? We're seeing the exact same thing in our application currently in development, but can't be certain when it started occurring.