Errors when using apoc.load.json() when you have NULL, FALSE, TRUE in your JSON data files

It's quite often you have a JSON data file you would like to import it into an AuraDB Instance by using the apoc.load.json() procedure. You need to make sure these JSON data files do NOT have values in upper case like: "NULL", "FALSE","TRUE", otherwise the apoc.load.json() will return an error and the load fails. If you hit this problem. you can use "sed" (or gsed on MacOS) command line tool to fix the problem and reload the data file again.

gsed -i 's/NULL/null/g' nodes-example.json

gsed -i 's/FALSE/false/g' relationships-example.json

gsed -i 's/TRUE/true/g' nodes-example.json

* the gsed here for MacOS users, if you are using Linux OS, you should use "sed" Command Line Tool.