Download CSV from weblink

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

Hello denisnguyen,

I think this post can help you

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

6 Likes

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

Just intuition. I’ve dealt with such cases before :smile:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.