I am trying to download list of scottish charities from https://www.oscr.org.uk/about-charities/search-the-register/charity-register-download/
It has additional steps where I have to tick T&C and click Proceed.
is there any way I can make downloading file automated using Knime?
I had a look at the request the website was sending. Then I just pasted the URL “https://www.oscr.org.uk/umbraco/Surface/FormsSurface/CharityRegDownload” into the Unzip Files node and it downloaded and extracted the contents without problem. You can then connect a Table Row to Variable to get the URI of the file as a variable and read in the file with the CSV Reader.
I had trouble reading in that particular CSV file as it contains line breaks in the middle of its strings… Yet to figure out how to deal with that.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.