search

neo4j / apoc

Apache License 2.0
86 stars 27 forks source link

apoc.load.json treats windows filepath as relative no matter what #505

Open Podbrushkin opened 11 months ago

Podbrushkin commented 11 months ago

Guidelines

Following this official video: https://www.youtube.com/watch?v=iyjgOR7nBck In neo4j desktop execute this:

call apoc.load.json('C:/Users/user/Desktop/openAlexConcepts/conceptsAll.json') YIELD value RETURN value LIMIT 10

Expected Behavior

A series of dictionaries returned.

Actual Behavior (Mandatory)

Neo.ClientError.Procedure.ProcedureCallFailed
Failed to invoke procedure `apoc.load.json`: Caused by: java.io.IOException: Cannot open file C:\Users\user\.Neo4jDesktop\relate-data\dbmss\dbms-e96d02e2-cf3a-42bf-89f0-1f9608860ce6\import\Users\user\Desktop\openAlexConcepts\conceptsAll.json for reading.

Screenshots (where it's possibile)

image

I don't know. To me filepath I provide looks literally the same as one shown as example in error message above. But it is treated as relative path.

Versions

Lojjs commented 11 months ago

@Podbrushkin I think you have done the correct adaptation according to the error message. The new error message is not about the same thing but seems to indicate that your Neo4j user is not allowed to read from that place in the file system. This is something you need to configure on your own computer most likely.