Good to hear, that should help anyone else using KNIME.
Maybe there should be a way of flagging threads here for a kind of FAQ - the article you mentioned at Getting invalid authorization should be on if so!
I can’t help with XBRL. Yes, it’s XML so readers should be able to parse it. I haven’t troubled with it because the financial data are rather complex and translating that into simple categories is outside my remit!
If you’re interested short examles can be found at https://beta.companieshouse.gov.uk/company/SC229764/filing-history - there are a couple of short filings there e.g. https://beta.companieshouse.gov.uk/company/SC229764/filing-history/MzE1MDYxMzMwNWFkaXF6a2N4/document?format=xhtml&download=1
The text on Beta says “Download iXBRL” - the document itself is just XBRL (XML) with a processing instruction for a stylesheet which will transform to XHTML. This works quite neatly using an XSLT processor. FYI when I tried in browser (Firefox, current) I get an error that it can’t load the stylesheet.
Note that for downloads as of now [2017-07] when you use the fetch a document request you’ll be send an http redirect response (302 here) which points to the document location on Amazon (S3). KNIME may handle this for you transparently (as happens if you make the request e.g. via AJAX call) - just saying as I had to explicitly catch the location returned then request this from Amazon.