When importing a string array field with a blank value, the attribute value is interpreted as [""] instead of NULL as expected.

[sterin501]

Guidelines

When importing a string array field with a blank value, the attribute value is interpreted as [""] instead of NULL as expected.

Expected Behavior (Mandatory)

It should import like neo4j-admin import

Actual Behavior (Mandatory)

It imports as empty list . it should be null value

How to Reproduce the Problem

APOC is importing as empty list .

├─────────────────────────────────────────────────────────────┤
│{"arr":["a","b","c","d"],"description":"string arr","id":"1"}│
├─────────────────────────────────────────────────────────────┤
│{"arr":[""],"description":"null arr","id":"2"} │
└──────────────────────────────────────────────────────

But neo4j-admin import importing it correctly

╒═════════════════════════════════════════════════════════════╕
│"n" │
╞═════════════════════════════════════════════════════════════╡
│{"arr":["a","b","c","d"],"description":"string arr","id":"1"}│
├─────────────────────────────────────────────────────────────┤
│{"description":"null arr","id":"2"} │
└─────────────────────────────────────────────────────────────┘

Simple Dataset (where it's possibile)

id:ID,:LABEL,description:STRING,arr:STRING[]
1,lab,string arr,a;b;c;d
2,lab,null arr,

Cypher : ``` `CALL apoc.import.csv([{fileName: 'test.csv', labels:[]}], [], {ignoreBlankString: true})` ```

Steps (Mandatory)

1. Import sample file using APOC
2. Import sample file using neo4j-admin import tool
3. compare the output

Screenshots (where it's possibile)

Specifications (Mandatory)

4.4.5

Versions

• OS: Linux
• Neo4j: 4.4.5
• Neo4j-Apoc:4.4.0.3