How to extract dynamic property names from a json file in Neo4J using Cypher Query

Question

The tags property names are dynamic. e.g. linux and cypher are dynamic in the json. I am trying to extract the dynamic tags and their values and associate them as properties to the Person node. Here is what I have so far:

CALL apoc.load.json("file:///example.json")
YIELD value
MERGE (p:Person {name: value.name})
ON CREATE SET 
p.job = value.job,
p.department = value.department

RETURN p as Person;

example.json:

{
    "name": "Harry",
    "job": "Developer",
    "tags": {
        "linux": "awesome",
        "cypher": "Working on it"
    },

    "department": "IT"

}

NOTE: You can replace `ON CREATE SET` With `SET` so it updates the properties when making changes to an already deployed node — Sascha, May 08 '22 at 14:24

score 1 · Accepted Answer · answered May 07 '22 at 08:59

You can assign all properties from the "tags" key with p += value.tags syntax, ie:

CALL apoc.load.json("file:///example.json")
YIELD value
MERGE (p:Person {name: value.name})
ON CREATE SET 
    p.job = value.job,
    p.department = value.department,
    p += value.tags
RETURN p as Person

It creates the following node (with your data example):

{
  "identity": 29,
  "labels": [
    "Person"
  ],
  "properties": {
    "cypher": "Working on it",
    "linux": "awesome",
    "name": "Harry",
    "job": "Developer",
    "department": "IT"
  }
}

See doc here: https://neo4j.com/docs/cypher-manual/current/clauses/set/#set-setting-properties-using-map

Thanks @stellasia a very helpful and elegant answer – Sascha May 08 '22 at 14:26 — Sascha, May 08 '22 at 14:26

How to extract dynamic property names from a json file in Neo4J using Cypher Query

1 Answers1