Tags: apoc.load.json()Tags: NULLTags: FALSETags: TRUETags: JSON
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.
Please sign in to leave a comment.