search

eisman / neo4jd3

Neo4j graph visualization using D3.js
https://eisman.github.io/neo4jd3/
MIT License
1.38k stars 424 forks source link

Querying Neo4j v3.3.5 data format doesn't match #26

Closed dougajmcdonald closed 6 years ago

dougajmcdonald commented 6 years ago

Hi there,

I'm querying Neo4J 3.3.5 with the following query:

MATCH (n) OPTIONAL MATCH (n)-[r]-() RETURN n, r;

This returns me data which looks like this:

{  
  "results":[  
      {  
         "columns":[  
            "n",
            "r"
         ],
         "data":[  
            {  
               "row":[  
                  {  
                     "phone_number":"079574290174"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":0,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":3,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574290174"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":0,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":2,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574290174"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":0,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":1,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574290174"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":0,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":0,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079929592107"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":1,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":13,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079929592107"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":1,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":7,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079929592107"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":1,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":6,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079929592107"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":1,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":5,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079929592107"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":1,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":4,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079755449190"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":2,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":17,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079755449190"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":2,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":14,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079755449190"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":2,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":13,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079755449190"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":2,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":12,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079755449190"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":2,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":11,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079755449190"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":2,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":10,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079755449190"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":2,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":9,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079755449190"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":2,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":8,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574308199"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":3,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":22,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574308199"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":3,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":20,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574308199"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":3,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":21,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574308199"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":3,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":18,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574308199"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":3,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":19,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574308199"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":3,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":16,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574308199"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":3,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":17,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079574308199"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":3,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":15,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079142653631"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":4,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":30,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079142653631"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":4,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":31,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079142653631"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":4,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":28,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079142653631"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":4,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":29,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079142653631"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":4,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":26,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079142653631"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":4,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":27,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079142653631"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":4,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":24,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079142653631"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":4,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":25,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079142653631"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":4,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":23,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079142653631"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":4,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":14,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"07994590507"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":5,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":16,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"07994590507"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":5,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":0,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079890024638"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":6,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":1,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"07900202872"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":7,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":15,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"07900202872"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":7,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":4,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"07900202872"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":7,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":2,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"07938441428"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":8,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":5,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"07938441428"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":8,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":3,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079562763146"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":9,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":6,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079460723019"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":10,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":22,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079460723019"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":10,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":7,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079114044356"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":11,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":8,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079930902463"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":12,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":29,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079930902463"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":12,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":9,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079970530368"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":13,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":20,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079970530368"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":13,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":10,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079441013326"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":14,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":11,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079119808095"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":15,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":12,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079341469140"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":16,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":18,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079742230649"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":17,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":19,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079545781483"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":18,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":23,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079545781483"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":18,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":21,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079781624770"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":19,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":24,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079448132402"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":20,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":25,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079516166315"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":21,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":26,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079810540025"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":22,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":27,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079506051500"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":23,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":28,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079885330165"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":24,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":30,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            },
            {  
               "row":[  
                  {  
                     "phone_number":"079259791034"
                  },
                  {  

                  }
               ],
               "meta":[  
                  {  
                     "id":25,
                     "type":"node",
                     "deleted":false
                  },
                  {  
                     "id":31,
                     "type":"relationship",
                     "deleted":false
                  }
               ]
            }
         ]
      }
   ],
   "errors":[  

   ]
}

I'm seeing an error in neo4jd3 Cannot read property 'nodes' of undefined where it seems to be expecting to find nodes under another property graph (as per this doc: https://www.npmjs.com/package/neo4jd3#neo4j-data-format) but as you can see from my data, I don't get that nested graph property mine just hangs straight out of data[].

Any ideas how I can reformat things? or is this a version issue?

dougajmcdonald commented 6 years ago

I figured it out, had to change the query to include as resultDataContents property, this is what my payload looks like.

{"statements": [ {
      "statement": "MATCH (n) OPTIONAL MATCH (n)-[r]-() RETURN n, r",
      "resultDataContents":["graph"]
    }]}