Creating a graph from json using apoc.graph.fromDocument - children's children do not appear in graph

[tony.chiboucas]

What you have is recursive json data. This can be especially tricky to handle properly, but there is a related post which should help:

Import nodes from recursively structured json

Hello, How would I go about creating a cypher query that imports and merges Nodes which are inside json of type: groups -> groups .. * .. groups groups within groups within groups groups may also be shared amongst other groups all of the same type all of the same relationship The nesting can be 'n' deep so a fixed number of UNWIND/FOREACH isn't possible. sample json: { "ID": "ROOT", "groups": [ { "ID": "GROUP_A6", "groups": [ { "ID": "GROUP_B6" } ] }, { …

Explaination

apoc.load.json supports jsonpath, allowing you to restructure the json into something more manageable.

Go to jsonpath.com, and experiment with paths which give you a flat list of all "children". Create a node for every ID, then MERGE your way through as you iterate.