knime server URL to filepath

[mathi]

Following issue happens only in server, In local it works fine.

I had placed few JSON files in knime server outside the WF. Using ListFiles I got he URL of the files, the URL of the files are knime server location and I need to get file path from it, so that i can use the file path variable to the java code to read the files. I am stuck at this place on how to get the file path from the knime server URL. I had tried to use URL to filePath node, but it fails to read the server location.

Any suggestions on getting the filepath from URL will be helpful.

[dyagaty]

Did you try using “List Remote files” ?

Error with Upload/Download and List Remote Files Nodes

Hi @szawadski - I think the problem is because you are trying to pass a directory as the URI you want to write to. Instead, you should pass a URI for each individual file. I did this by using a String Manipulation node to cobble together an appropriate filepath as shown below. This is a bit messy but hopefully you get the idea. [2019-08-28%2013_28_29-KNIME%20Analytics%20Platform] SSHDownloadFilesFromListExample.knwf (35.0 KB)

Upload a group of workflows — NodePit

[Iris]

Can you use the json reader node instead?

The local path would be a workaround only as the file transfer is typically done in the background via REST

[mathi]

Thanks for the suggestion @Iris

Yes i used json reader and I see the content of the JSON file, As my JAVA code(JAR) accepts only File path, JSON reader wont be useful for my WF.

If you have any suggestion on how to use the output of JSON reader and convert that to file path variable, will be really helpful.

[mathi]

List Remote Files is not useful in my case. As the files are there in knime server, the output will be similar to ListFiles node.

[Iris]

happy to make you an example.

Did I understand the setup correctly:

• you have a folder living on KNIME Server
• in this are a some jsons
• all should in one single table

How get the Jsons on the server? Once, manually or automatic?

[mathi]

I have a folder in knime server with JSON.
If i use list files, URL and location will be given as output. Location column consist of “?” and the URL column contains “knime://knime.workflow/…/…/…/Schema/JSON/dummy-catalogue.json”

• List item As the URL is knime server URL, My java code is like Files.get(Path(“knime://knime.workflow/…/…/…/Schema/JSON/dummy-catalogue.json” ), which fail to get read the json file in server. Because the URL is doesn’t provide the location of the File( File Path) .

• List item I am expecting server location like /Schemas/Datadrive/JSON/catalogue instead of URL “knime://knime.workflow/…/…/…/Schema/JSON/dummy-catalogue.json” .

Please see the attached image in the link provided.

ListFiles node output doesn't give a proper location of the file in server

Following issue happens in KNIME Server, I am using ListFiles to get the JSON files outside the WF(“knime://knime.workflow/…/…/…/Schema/JSON”). The output of the ListFiles contains Location and URL. Location filed consist of “?” as value. URL gives the file path like “file:/SomeFileLocation” in local and in server “knime://knime.workflow/…/…/…/Schema/JSON”. If i keep the JSON files inside the WF under some folder,(“knime://knime.workflow/Schema/”) In output of ListFiles node I am abl…