# Parse json with Cypher

**URL:** <https://community.neo4j.com/t/parse-json-with-cypher/14842>\
**Category:** Cypher\
**Created:** [February 18, 2020, 11:09am UTC](https://community.neo4j.com/t/parse-json-with-cypher/14842 "2020-02-18T11:09:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![12kunal34](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/12kunal34/32/2617_2.png) [@12kunal34](https://community.neo4j.com/u/12kunal34)\
**Post date:** [February 18, 2020, 11:09am UTC](https://community.neo4j.com/t/parse-json-with-cypher/14842/1 "2020-02-18T11:09:55Z")

</div>

Hi Everyone,

I have a json structure like below.

```auto
  '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

---

<div class="post-metadata">

**Author:** ![anthapu](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/anthapu/32/4113_2.png) [@anthapu](https://community.neo4j.com/u/anthapu)\
**Post date:** [February 18, 2020, 12:22pm UTC](https://community.neo4j.com/t/parse-json-with-cypher/14842/2 "2020-02-18T12:22:47Z")

</div>

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.

> **[Using APOC to parse JSON results from Trello API - Knowledge Base](https://neo4j.com/developer/kb/using-apoc-to-parse-json-results-from-trello-api/)**
>
> 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…