How to parse json and create nodes with foreach in Neo4j?

Question

Sample json:

{
    "data": [
            {
                "file" : "1.txt",
                "type" : "text"
            },
            {
                "file" : "2.json",
                "type" : "json"
            },
            {
                "file" : "1.html",
                "type" : "html"
            }
    ]
}

I am trying to create 3 nodes with file and type as properties

I am using following query to create nodes in neo4j

WITH {json} AS document 
UNWIND document.data AS data
FOREACH (node in data| CREATE(m:`member`) SET m = node )

I am getting following error when i use py2neo driver:

AttributeError: 'module' object has no attribute 'SyntaxError'

Michael Hunger · Accepted Answer · 2019-11-12 08:23:56Z

1

In your case either use UNWIND or FOREACH

WITH {json} AS document 
UNWIND document.data AS data
CREATE(m:`member`) SET m = data

or

WITH {json} AS document 
FOREACH (node in document.data | CREATE(m:`member`) SET m = node )

answered Nov 12, 2019 at 8:23

Michael Hunger

41.7k3 gold badges59 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

krishna reddy · Accepted Answer · 2019-11-08 03:33:20Z

0

Query should be like -

 WITH {json} AS document
 FOREACH (node in document.data| CREATE(m:`memeber`) SET m = node )

answered Nov 8, 2019 at 3:33

krishna reddy

3254 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to parse json and create nodes with foreach in Neo4j?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related