How to refer to imported file ? | Voters

How to refer to imported file ?

jerome baton

After adding a file, I wanted to do a plain old load csv. 
The URL can not be guessed , as it is not file:///filename.csv
This could appear via the ... button or in a right click menu on the file
And I know, the Import part it is a great addition

August 26, 2022

Michael Hunger

you can use the statements that data importer shows
but replace the UNWIND line with
LOAD CSV WITH HEADERS FROM "url" AS nodeRecord

Gregory King

Hi Jerome,
If you're referring to the Import tab, the way the application is currently  architected, it is streaming those files from your web browser through a driver connection to do the import.  The file itself does not reside on a backend filesystem, so you can't access it via file://
 in Cypher, neither does it exist as a http://
 web resource because we aren't uploading it anywhere. This has the benefit you keep everythign local to you, but the downside of this approach is that your web browser needs to retain access to your files on your local filesystem
 in order to stream them - you can see this manifested if you reload the page and the Import tab will ask you to re-add the files.
So we can't currently provide you with a resource identifier to reach these files.  One interesting thought is that we could, in theory at least, allow the commands you run in Query to access those files in the same streaming way the Import tab does. This needs some careful consideration though as it breaks the boundaries of what is happening across the different parts of the app, we'll give it some thought.
Thanks for taking the time to post the feedback!
Greg