Download CSV from weblink

[denisnguyen]

Dear Community,
This might be a quite easy one for experienced KNIME users. I am pretty new to this and your help would be greatly appreciated.
I am trying download a csv using this weblink:

https://www.ishares.com/ch/individual/en/products/316040/fund/1495092304805.ajax?fileType=csv&fileName=SCWS_holdings&dataType=fund

If I enter it in my browser the file is downloaded without any problems.
I would be very grateful for a hint on which node (I tried but failed with CSV-Reader, GET-Request) I should use and how it should be properly configured.
With CSV-Reader I get a “data row has too few data element” response
With GET-Request I get an error “Illegal character in query at index 130”

Thank you so much in advance for your help!
Best regards,
Denis

[berserkersap]

Hello denisnguyen,

I think this post can help you

Obtain CSV file from URL

Hi all, I have Knime desktop installed only but moving to server soon. I’m new to Knime and loving it but have a problem. I wish to carry out the retrieval of data from a web URL which contains the query question mark within the address. For instance: www.webpage.com/subpage/anothersubpage/filename.csv?v=2021-08-06-13-27-04 It seems I am unable to achieve this with the file reader or excel reader as the question mark seems to throw an exception. I’ve searched for other solutions but they …

[duristef]

hi @denisnguyen
you can read it with the Csv reader node, but you must discard 2 rows at the beginning of the file and 1 at the end.
Configure the “Settings” tab of the node like this

and the “Limit Rows” tab like this

[denisnguyen]

@duristef : Thank you so much - you made my day! May I ask how you got to the solution?

[duristef]

Just intuition. I’ve dealt with such cases before