Parse json with Cypher

[12kunal34]

Hi Everyone,

I have a json structure like below.

  'ha': StringType(),  
  'confirmations': LongType(), 
  'previousha': StringType(), 
  'nextha': StringType(), 
  'ax': [{  
      'axid': StringType(), 
      'ha': StringType(), 
      'ex': StringType(), 
      'win': [{  
          'axid': StringType(), 
          'Sig': {'as': StringType(),'ex': StringType(),'seq': LongType()},  
          'sequence':LongType(), 
        }], 
      'wout': [{  
          'value': DoubleType(),'n': LongType(), 
          'Pub': {
            'type': StringType(), 
            'addresses': [StringType()]} 
        }]}]}

i want to parse above json structure and want to create nodes for each addresses element and for each 'ax' element.

please help me into this

[anthapu]

Hi Kunal,
How are you passing this data to Neo4J? If you are using client driver then Cypher is map friendly and json parameter will be converted to MAP.

If you are loading it from file then please look at apoc.load.json method.

Here's a blog post that explains it's usage.

Neo4j Graph Database Platform

Using APOC to parse JSON results from Trello API - Neo4j Graph Database Platform

Prior to Neo4j 3.0, if you wanted to parse the JSON results from a call to a Web API, it would require you use one of the database drivers to fetch and parse the JSON data. This is described here.… Read more →