Nuxeo CSV Importer update document, change existing integer to null
I am doing a bulk update using nuxeo csv-import.
The documents have existing data in an integer field.
I'd like to force the integer fields to have a null value. To be clear, this means the value in my:integerField will need to change from “12345” to ““. I've tried:
“name”,“type”,“my:integerField”
“MyDoc”,“MyType”,
“MyDoc”,“MyType”,
“MyDoc”,“MyType”,null
“MyDoc”,“MyType”,NULL
“MyDoc”,“MyType”,“null”
“MyDoc”,“MyType”,“NULL”
“MyDoc”,“MyType”,\N
“MyDoc”,“MyType”,“\N”
“MyDoc”,“MyType”,“”
“MyDoc”,“MyType”,''
“MyDoc”,“MyType”,“NULL”
“MyDoc”,“MyType”,“{@code null}”
“MyDoc”,“MyType”,{@code null}
etc etc.
I'm using Nuxeo 8.10 with postgresql.
Any suggestions?
Unfortunately it is currently not possible to import null values.
In case anyone else comes across this: I was able to use curl instead.
$ curl -d '{"entity-type": "document","properties":{"my:integerField":null}}' -H 'Content-Type:application/json' -X PUT -i -u Administrator:Administrator http://localhost:8080/nuxeo/api/v1/path/to/document