Re: [Neo4j] LOAD CSV with json format

166 views
Skip to first unread message
Message has been deleted

Michael Hunger

unread,
Dec 7, 2017, 4:36:15 AM12/7/17
to ne...@googlegroups.com
Yes via the apoc library with

Call apoc.load.json(url) yield value

You find a lot of examples if you google for it 

Von meinem iPhone gesendet

Am 07.12.2017 um 10:15 schrieb Liping Huang <liping.h...@gmail.com>:

Hi there,

Is it possible to load the CSV file with json content like:

json
{'id': "ID", "data": { ...... }}

then

USING PERIODIC COMMIT 50000
LOAD CSV FROM 'file:///data.csv' AS row
WITH row AS document
RETURN document.id

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Liping Huang

unread,
Dec 7, 2017, 5:00:20 AM12/7/17
to Neo4j
  • Error
ERROR

Neo.ClientError.Procedure.ProcedureCallFailed

Failed to invoke procedure `apoc.load.json`: Caused by: java.lang.RuntimeException: java.net.URISyntaxException: Illegal character in path at index 0: {}

在 2017年12月7日星期四 UTC+8下午5:36:15,Michael Hunger写道:

Liping Huang

unread,
Dec 7, 2017, 5:21:21 AM12/7/17
to Neo4j
it is not support as the json will has the characters like quote ""

在 2017年12月7日星期四 UTC+8下午6:00:20,Liping Huang写道:

Michael Hunger

unread,
Dec 7, 2017, 10:41:07 AM12/7/17
to ne...@googlegroups.com
That's not a json url

Von meinem iPhone gesendet

Liping Huang

unread,
Dec 8, 2017, 1:13:19 AM12/8/17
to Neo4j
Yes, thanks, only the url path to "***.json" is working for this case.

在 2017年12月7日星期四 UTC+8下午11:41:07,Michael Hunger写道:
Reply all
Reply to author
Forward
0 new messages