Load Json on the fly

[martin_ebert]

I'm trying to load JSON files with NiFi. With apoc.load.json this works fine. But it would be interesting to load json on the fly without the need to save it first. Use Case: I read the data from a relational database, convert it into Json and import these results in my graph database.

That's the kind I had in mind. But of course not working.

[terryfranklin82]

What about apoc.convert.fromJsonMap (or fromJsonList if appropriate)?

with apoc.convert.fromJsonMap('{"fieldA":"1","fieldB":"2"}') as value
merge (a:FieldA {name: value.fieldA})
merge (b:FieldB {name: value.fieldB})

[conker84]

Hi @martin.ebert may I suggest to use the apoc.graph.fromDocument procedure?
I wrote an article about how to use it in combination with apoc.mongodb.get procedure but it should work with apoc.load.json as well:

Medium – 29 Nov 19

Transform MongoDB collections automagically into Graphs

Using the apoc.graph.fromDocument procedure in Neo4j

Reading time: 5 min read

Feel free to ask or raise an issue into the Github repo.