I have a webservice transforming data into a csv file. Now I want to call it in KNIME and process the resulting csv file. I tried the CSV Reader but always got the error “Execute failed: The specified file /XMLConverterServer/csvfile does not exist.”
Now I tried the GET Request and got my data in the body-column. Unfortunately I don’t know how to make them a table …
Happy for any guidance on this topic. Thank you in advance!
Can you be more specific about the contents of the body? Preferable with a (anonymized) example. The structure will determine what you can do with it and someone will be more easily be able to help you out
Most commonly you need either JSON Path or Xpath nodes.
Hi @ArjenEX, thanks for the reply.
The body is a normal CSV file. The single cells are seperated by a semi colon [;]. The body in a non-formatted way looks like this:
If I transform it into a string, it looks like this (sorry it it is small):
So basically: I read a CSV File from a server, but as it is created on the fly, it does not work for the CSV Reader node.
if it is a csv file then try the csv reader node directly with the url
Hi Daniel_Weikert, I tried that, but KNIME said “Execute failed: The specified file /XMLConverterServer/csvfile does not exist.” /XMLConverterServer/csvfile is the path on the server to get the csv file as a stream.
I currently solve this problem by storing the stream into a temporary file and then read that. I just hoped that there is another solution…
Apologies, the solution only works with a path to the csv
Hi Daniel_Weikert, no problem and thanks for the help. Probably my problem is a little specific.
I think I will go with my workaround.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.