OK, so with the API call using the GET Request, if it seems to be returning a CSV, how how do the results look in KNIME? Is it a table with just a single cell, or multiple rows?
Unfortunately I haven’t found an example of a rest api that returns a CSV to play with, but obviously if it is CSV data, then XML and JSON nodes won’t work on it.
UPDATE:
I found a previous form post, that has an example csv on an API.
The answer was using the CSV Reader so I’m not sure why it isn’t working for you
e.g.
Does that definitely not work for you? You did say “Custom URL/KNIME” as mentioned before, didn’t you?
One thought… do you have to login to the API when you do the Get Request (e.g. do you need to obtain some sort of session key or other authentication? )