Hello. I am trying to learn how to load a json file and create the nodes and relationships. My json file has ~500K messages with 5 lists each: frame, ip, upd, eth, and data. I have learned how to read in the json file and then create one (1) message in the DBMS with all the appropriate nodes and relationships (thanks to those who helped school me). Not I need to figure out how to go through the map and to that for all 500k messages. I tried a FOREACH, but it only creates the first message an nothing else. I don't know if I am using the FOREACH incorrectly or if I should be using something else. Here is the pertinent parts:
CALL apoc.load.json("file:///FileExample.json") YIELD value
UNWIND value._source.layers as bigData
//THIS OPENS THE FOREACH LOOP
FOREACH (data in bigData |
a bunch of merge and sets
How can I cycle through the 500K messages to get them in the DBMS?