How to load nested json in neo4j

[kushwah.raja1]

Hi Team,

I am unable to load nested JSON to neo4j using apoc. Please find the steps and errors below.

DATA

Error

[dhruv.sharma8826]

Hi @kushwah.raja1

Whenever a variable is mentioned with a '$' at its start, Neo4j interprets it as a parameter and hence in your query above as well, it expects $props is referring to a parameter 'props' and not to the variable mentioned on line 3 of your query.

Regarding loading nested data from json into Neo4j, check these-

How to create nodes in nested array of JSON

Hi, I just had the problem of storing a 3-dimensional array as a property. The way I did it is this: flattened the 3-dim array into a single array containing all the values (column-first) wrote a user-function to index into the array like this: f(x,y,z) = (x-1)ab + (y-1)*b + z where a and b are the dimensions of y and z. This, of course, only works if the dimensions are the same for each row. In your case the innermost dimension is always 2 (lon, lat), but the outer dimension which is a…

Creating nodes from nested JSON using apoc.load.json() procedure

I have the following JSON file "test.json": { "Environment": { "Environment_elements": [{ "name": "weather", "id": "1", }, { "name": "enemy", "id": "2", }, { "name": "external_operator", "id": "3", } ], "System_element": { "name": "weapons_system", "id": "4", }, "Co…

Read nested json

**I AM new to neo4j. Can anyone help me creating cypher query for below json. I've a path array in my code which contains three objects, i want to get 3 separate nodes as path1, path2, path3 containing x, y, z properties in each path respectively. thanks in advance. ** { "nets": [{ "name": "Net 0", "path": [{ "x": 0.949999988079071, "y": 0.009999999776482582, "z": 0.20000000298023224 }, { "x": 0.949999988079071, "y": 0.009999999776482582, "z": 0…

Regards.

[kushwah.raja1]

Thanks for the reply.

But in my case, the JSON file is very big. So finding it difficult to write the CQL.

Please find the data link below

JSON DATA

[dhruv.sharma8826]

Hi @kushwah.raja1

Have you tried the apoc library?, to maybe import the json data in a list form that might make it easier to create a cypher query around it.

Below link has some examples that might give you some idea to proceed.

Load JSON - APOC Extended Documentation

Looking at your query and at the data you have attached, I am a bit confused as to why you want to load all the json as a single property on a Patient node. Ideally there would be different aspects of the json that should go into different components that in turn connect to each other through relationships, to fully utilize the graph.
Apologies if I misunderstood your design and requirement, but just trying to suggest the best option.

Regards.