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 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…